Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87988 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / pcsenthil
we can achive all type of constraint in both level but we
cannot use NOT NULL in table Level, the reason was "All
Constraint will give logical view to that particular column
but NOT NULL will assign to the structure of the table
itself.. that's why we can see NOT NULL constraint while
Describe the table, no other constraint will be seen.
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
How to convert a string to a date in oracle database?
How to display employee records who gets more salary than the average salary in the department?
Can you create a synonym without having a table?
How to convert csv to table in oracle?
What happens to the current transaction if the session is ended?
How to set up autotrace for a user account?
what is the difference between functional dependecy and multilevel dependency?
Explain alias?
Explain about achiever in sql?
Please explain compound trigger in oracle?
Why oracle is used?
Explain how are indexes update?
How to list all indexes in your schema?
What do you mean by merge in oracle and how can we merge two tables?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
