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
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to use null as conditions in oracle?
How to import one table back from a dump file?
Is oracle the best database?
How to invoke the data pump export utility?
How to get a list of all user accounts in the database?
Explain enable novalidate constraint.
What is a nvl function?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Explain the use of grant option in imp command.
When do we use group by clause in a sql query?
How can we find out the current date and time in oracle?
Explain a private synonyms?
How to use values from other tables in update statements using oracle?
What are the different types of trigger and explain its various uses and functions?