What is the difference between column level constraints and
table level constraints?
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 many categories of data types?
What is a database schema in oracle?
What is oracle rowcount?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is the data pump export utility?
How do we create privileges in oracle?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How to write a query with a right outer join in oracle?
How to update a table row with a record?
Why do you use stored procedures and state some of its disadvantages?
How to best split csv strings in oracle 9i?
What is bulk collect in oracle?
How do you find current date and time in oracle?
What is snapshot is too old? Give and example for better understand.
What suggestions do you have to reduce the network traffic?