What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 84800 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / priya
Constraints define the conditions or predictions under
which data is valid.
column level constraints are applicable to single column
only like if we want to make Unique constraint on column
level then as shoen below:-
<column Name><data type>Unique
At table level
Unique(<coulmn>,<column>);
Table level constraints means when constraints apply on
more than single column.
| Is This Answer Correct ? | 22 Yes | 6 No |
Post New Answer View All Answers
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is the difference between count (*), count (expression), count (distinct expression)?
How to load data through external tables?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Does oracle partitioning improve performance?
How to retrieve data from an explicit cursor?
Explain cascading triggers.
How to generate query output in html format?
What is a table in oracle?
How to end the current transaction in oracle?
Describe an oracle table?
Explain what are the uses of rollback segment?
What is a parameter file in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is Trigger in Oracle?
