Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87498 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / adinarayana
COLUMN LEVEL
1.Column level constraints can be defined along with the
columns.
2.NOT NULL constraints can be defined at this level(to only
one column).
3.Composite keys can't be defined at this level
TABLE LEVEL
1.Table level constraints can be defined after defining the
all columns
2.NOT NULL constraints can't be defined at this level.
3.Composite key can be defined at this level
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How can I see all tables in oracle?
What is the order of defining local variables and sub procedures/functions?
What are the system predefined user roles?
Can the query output be sorted by multiple columns in oracle?
How to convert characters to numbers in oracle?
How to connect to the server with user account: sys?
Explain compound trigger in oracle?
How can Oracle users be audited?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How to create tables for odbc connection testing?
How can we find out the current date and time in oracle?
Where do you use decode and case statements?
Difference between oracle's plus (+) notation and ansi join notation?
What are the extensions used by oracle reports?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
