What is the difference between SQL Constraint and PL/SQL
constraint.Pls give all the constraint name.

Answer Posted / dinesh

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many sql commands are there?

849


How do I run a program in pl sql?

698


What is the purpose of normalization?

748


Explain architecture of sql server notification services?

785


What are keys in sql?

722






Can we create a trigger on view?

666


Which table is left in join?

686


Where is sql database stored?

686


Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1899


Is primary key an index?

713


What is data control language (dcl)?

790


What are different types of functions in sql?

723


how to calculate expressions with sql statements? : Sql dba

713


Does normalization improve performance?

761


Why join is faster than subquery?

792