Answer Posted / rajesh
Integrity Constraints prevent invalid data entry into the
table.These constraints set a range and any violation takes
place oracle prevent the user from performing manipulation
on the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What is online transaction processing (oltp)?
Explain the uses of database trigger.
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is a rank in sql?
Does truncate table reset auto increment?
What is the difference between Union and Union all. Which is faster.
What is cursor and why it is required?
what are the differences between char and nchar? : Sql dba
How can get second highest salary in sql?
Enlist some predefined exceptions?
What are views in sql?
What are the two different parts of the pl/sql packages?
What is a temporal table?
What is pl sql package?
