Answer Posted / chakri

Syntax of procedure :

CREATE OR REPLACE PROCEDURE proce_name (Arg list)
IS
LOCAL VARIBLE DECLARATION

BEGIN
----------
----------
---------
END;


In the about syntax

Up to IS key word called as Procedure Header and

Remaining Part is called as Procedure Body.

List and explain the different types of join clauses supported in ansi-standard sql?

1344

---

What is sp_helptext?

1051

---

Do foreign keys improve performance?

1005

---

What is the trigger in sql?

929

---

what is the use of double ampersand (&&) in sql queries?

1156

---

What are the popular database management systems in the it industry?

978

---

Can you have a foreign key without a primary key?

937

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2001

---

how to check server status with 'mysqladmin'? : Sql dba

1051

---

How many columns should be in an index?

950

---

How are sql commands classified?

1070

---

What are field types?

973

---

How do you drop a trigger?

967

---

Can we perform dml on view?

1028

---

What are tuples in sql?

1114

---