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 the difference between clustered and non clustered index in sql? : Sql dba

1107

---

What are the types of optimization?

932

---

How to order siblings in oracle hierarchy queries?

1022

---

Why sql query is slow?

974

---

what are all types of user defined functions? : Sql dba

1030

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1092

---

Can %notfound return null after a fetch?

1040

---

What is crud stand for?

985

---

How to rename a column in the output of sql query?

1064

---

What is linq to sql?

1120

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1022

---

Explain table and field in sql?

1049

---

What is the plv (pl/vision) package offers?

1029

---

explain the delete statements in sql

1028

---

What type of join is sql join?

963

---