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 can you know that statistics should be updated?

606

---

Is pl sql and postgresql same?

573

---

Why we use cross join?

543

---

What is set transaction?

582

---

What are the various restrictions imposed on view in terms of dml?

523

---

---

What is sql exception?

517

---

List the ways to get the count of records in a table?

512

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

504

---

Why schema is used in sql?

517

---

What is function and procedure?

568

---

Is left join faster than join?

549

---

how to analyze tables with 'mysqlcheck'? : Sql dba

547

---

What is meant by user defined function?

582

---

Can a primary key be a foreign key?

577

---

What is trigger and stored procedure in sql?

558

---