What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 84826 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / hari
Column level and Table level Constraint
In column level we will give primary key after the data type
create table table-name(name varchar2(10) primary key)
In Table Level we will use constraint name..
| Is This Answer Correct ? | 19 Yes | 29 No |
Post New Answer View All Answers
How to call a stored function with parameters?
What is a user role in oracle?
How to define an external table with a text file?
What is a subquery?
Can a formula column referred to columns in higher group ?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to filter out duplications in the returning rows using oracle?
Which is better Oracle or MS SQL? Why?
How to drop a tablespace?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to retrieve data from an explicit cursor?
Explain temporal data types in oracle
What is system global area (sga) in oracle?
What is snapshot is too old? Give and example for better understand.
