Answer / siva

Both SQL Constraint and PL/SQL constraint are the same.

Answer / kotesh

sql & plsql constraints are same
namly

primary key
check
not null
unik
foreign key

Answer / dinesh

SQL:- Primary Key,Foreign Key,NOT NULL,CHECK,DEFAULT Etc
PL/SQL :-Trigger just use a constraint

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

What is a recursive join sql?

0 Answers  

---

what is recursive stored procedure? : Sql dba

0 Answers  

---

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

---

---

what is organisational index?

1 Answers  

---

Is sql procedural language?

0 Answers  

---

What is INSTEAD OF trigger ?

13 Answers   Hexaware, TCS,

---

what is a constraint? : Sql dba

0 Answers  

---

Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

What is auto increment?

0 Answers  

---