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 many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

How do I tune a sql query?

0 Answers  

---

Which are sql * plus commands?

0 Answers  

---

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

---

what is data integrity? : Sql dba

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

How much does a sql dba make? : SQL DBA

0 Answers  

---

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

0 Answers  

---

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

---

What is meant by <> in sql?

0 Answers  

---

Talk about views

10 Answers   Polaris,

---