What is the difference between column level constraints and
table level constraints?

Answer Posted / nilesh

Column level constraints are applicable to that column
only, whereas table level conatraints are used to define
composite keys like primary key for the combination of two
or more columns in a table

Is This Answer Correct ?    201 Yes 35 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to rename a column in an existing table?

609


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

541


What is the usage of analyze command in oracle?

603


How to define an external table with a text file?

576


What is meant by recursive hints in oracle?

613






Explain about achiever in sql?

576


What is pragma autonomous transaction in oracle?

511


What is a database schema in oracle?

611


Why oracle is used?

573


Please explain oracle left join with an example?

575


How to drop an existing table in oracle?

585


What is max rowid in oracle?

551


In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1201


What is key preserved table?

556


What is the use of aggregate functions in oracle?

571