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
How many sql commands are there?
How do I run a program in pl sql?
What is the purpose of normalization?
Explain architecture of sql server notification services?
What are keys in sql?
Can we create a trigger on view?
Which table is left in join?
Where is sql database stored?
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
Is primary key an index?
What is data control language (dcl)?
What are different types of functions in sql?
how to calculate expressions with sql statements? : Sql dba
Does normalization improve performance?
Why join is faster than subquery?