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;

Is sql a dbms?

542

---

What is the starting oracle error number? What is meant by forward declaration in functions?

551

---

how to fetch common records from two tables? : Sql dba

639

---

how to select first 5 records from a table? : Sql dba

520

---

What is the use of sqldataadapter?

545

---

---

when is the use of update_statistics command? : Sql dba

510

---

Do prepared statements prevent sql injection?

538

---

What is cost in sql execution plan?

498

---

What is union?

660

---

Do stored procedures prevent sql injection?

558

---

how would concatenate strings in mysql? : Sql dba

580

---

What do you know by pl/sql cursors?

580

---

What are the different ddl commands in sql?

586

---

What is primary key in db?

529

---

What is pivot table in sql?

531

---