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

How do you concatenate in sql?

1013

---

What is nested table in pl sql?

1051

---

How many parts of a pl sql block are optional?

1101

---

Is it possible to read/write files to-and-from PL/SQL?

1084

---

What are pl/sql cursors?

1036

---

How do you use join?

921

---

Is mariadb a nosql database?

1035

---

How to use distinct and count in sql query? Explain

1000

---

What does (*) mean in sql?

939

---

how can we find the number of rows in a table using mysql? : Sql dba

1069

---

How can you select unique records from a table?

1053

---

Is a view faster than a stored procedure?

947

---

what are integrity rules?

1010

---

What is sql query limit?

959

---

What are the types of triggers in sql?

1066

---