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

552

---

Does truncate table reset auto increment?

528

---

what are the difference between clustered and a non-clustered index? : Sql dba

529

---

how can we submit a form without a submit button? : Sql dba

540

---

where are cookies actually stored on the hard disk? : Sql dba

582

---

---

write an sql query to find names of employee start with 'a'? : Sql dba

583

---

What are character functions in sql?

500

---

What is prepared statement in sql?

551

---

What is dbo in sql?

537

---

What is the reports view in oracle sql developer?

545

---

What are string functions in sql?

678

---

What is the syntax and use of the coalesce function?

605

---

Explain the difference between triggers and constraints?

522

---

Is natural join and inner join same?

502

---

What is coalesce sql?

518

---