difference between table level constraint and column level and
advantages of table level constraint

Answer Posted / selvi

Column level constraint can not refer other columns or sysdate, UID, currVal, nextVal or rownum, and this is limitation of column level constraint over table level constraint.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a variable in sql?

725


What are all ddl commands?

744


What are actual parameters and formal parameters?

784


What is sql injection owasp?

729


In what condition is it good to disable a trigger?

746






What are different sql data types?

685


How to download oracle sql developer?

856


What is sqlca in db2?

697


What is AUTH_ID and AUTH_USER in pl/sql ?

1942


What is a table?

728


how many ways we can we find the current date using mysql? : Sql dba

818


Can we change the table name in sql?

707


how to use like conditions? : Sql dba

786


How to write a query to show the details of a student from students table whose

759


how would you enter characters as hex numbers? : Sql dba

725