Answer Posted / kirankumar.vangeti

create or replace procedure procedure_name as

Declare
/* Declarative section: variables, types, and local sub
programs */
Begin
/* Executable section: Procedural and sql statements go
here */
Exception
/* exception handling section: error handling statements go
here */
End;

What is offset and limit in sql?

549

---

Can you have a foreign key without a primary key?

507

---

Explain lock escalation? : Transact sql

702

---

What are the disadvantages of file system?

617

---

What is range partitioning?

517

---

---

What is procedure explain with example?

538

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

546

---

Explain the select statement in sql?

611

---

What are the topics in pl sql?

518

---

What is sql key?

516

---

How many sql statements are used?

565

---

Is sqlite good enough for production?

531

---

Which table is left in join?

516

---

Which is faster truncate or drop?

558

---

How many triggers can be applied on a table?

510

---