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 I remove sql developer from windows 10?

1011

---

Can a commit statement be executed as part of a trigger?

995

---

What is a sql instance vs database?

1033

---

What is sql dialect?

1035

---

How can get second highest salary in sql?

907

---

What is normalisation and its types?

952

---

how to drop an existing table in mysql? : Sql dba

981

---

What do you understand by exception handling in pl/sql?

958

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

917

---

What is package in pl sql?

961

---

what are the advantages of using stored procedures? : Sql dba

1058

---

What is query execution plan in sql?

1124

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

944

---

What is a relationship and what are they?

1047

---

Explain sql data types?

1028

---