Answer Posted / manojbatra071

whenever we create stored procedure the syntax is:
CREATE OR REPLACE PROCEDURE proc_name
AS/IS
(declare variables inside this block)
BEGIN
perform whatever u want in stored procedure
EXCEPTION
(perform the steps if any errors occur than what to do )
END;

therefore the blocks are as/is , begin,exception and end

What is use of term?

1126

---

What is sql query limit?

1019

---

what is denormalization. : Sql dba

1159

---

State some properties of relational databases?

1115

---

What is difference between db2 and sql?

1046

---

how mysql optimizes distinct? : Sql dba

1123

---

Is left join inner or outer?

1055

---

what is row? : Sql dba

1275

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1286

---

What is varchar sql?

1205

---

Is left join same as join?

1035

---

Is sql dba a good career? : SQL DBA

1047

---

How to run sql*plus commands in sql developer?

1206

---

how many tables will create when we create table, what are they? : Sql dba

1114

---

What program will open a mdb file?

1018

---