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 user in sql?

585

---

What is procedure function?

541

---

How can you load multi line records? : aql loader

663

---

What is the largest value that can be stored in a byte data field?

521

---

When is the explicit cursor used ?

594

---

---

What are the differences between implicit and explicit cursors?

523

---

what is cross join? : Sql dba

576

---

Can variables be used in sql statements?

554

---

Is there a 64 bit version of ssms?

520

---

Can a table contain multiple foreign key’s?

579

---

How do I enable sql encryption?

520

---

What is sql integrity?

585

---

What is primary key and foreign key with example?

498

---

Explain 3 basic parts of a trigger.

843

---

How is data stored on a disk?

545

---