Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87513 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
column constraint is only for particular column to provide restriction,
where in table level constraint we define multiple constraint at same time except not null .
not null is only used for column level.
ex: create table customer(cust_id number(2) not null,cust_name varchar2(20)check(cust_name like 'C%');
above example is shows constraints on column level.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / riddhi
Difference between column level constraints and table level constraints
1)Column level constraint is declared at the time of creating a table but table level constraint is created after table is created.
2)Column Level Constraints refers Only One Column whereas table level constraints refers to one or more than one column
3)not null constraint can't be created as table level constraints because it don't have name.
Column level constraint-
Ex : Create table emp
( empno number primary Key);
Table level constraint
Ex: Create table emp
( empno number);
Constraints pk_con primary Key(empno));
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / chunnu
is questn ka ans mai pichle 50 saal se dund rha hu....mile
to apne pas hi rakhna.........varna mere sir ko bta
dena .....sir kha gae...pad k ana bhul gae the.....
| Is This Answer Correct ? | 32 Yes | 39 No |
Answer / 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 |
Is truncate autocommit in oracle?
How to work with data objects interactively?
What is format trigger?
How to retrieve 5th highest sal from emp table?
How to list all user accounts in oracle?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is the use of aggregate functions in oracle?
23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
What is indexing, and how does it improve performance?
Oracle General 
