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

what is rollback? : Sql dba

589


Describe different types of general function used in sql?

530


What is data type in database?

541


What is foreign key and example?

508


Mention what is the function that is used to transfer a pl/sql table log to a database table?

482






How to run sql commands in sql*plus?

581


How to set up sql*plus output format in oracle?

591


How can a pl sql block be executed?

526


Can we join more than 2 tables in sql?

489


Which software is used for pl sql programming?

515


Is it possible to read/write files to-and-from PL/SQL?

650


What are the ddl commands?

531


What are the advantages of stored procedure?

535


How to handle bulk data?

889


What are the disadvantages of not performing database normalization?

591