Answer Posted / priyanka
conditions mentioned in the CHECK constraint must be a
boolean exp,they cannot be subqueries or sequences n
cannot include the SYSDATE,UID,USER, USERNV SQLfunctions
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What is max rowid in oracle?
Describe varray?
Explain the use of rows option in imp command.
What are the system predefined user roles?
How to create a new table in your schema?
How to call a stored function with parameters?
How can I combine multiple rows into a comma-delimited list in oracle?
Explain oracle instance.
How to delete an existing row from a table in oracle?
Explain the function of optimizer in oracle?
What is a table index in oracle?
What are the database administrators utilities available?
what is reindexing?
What is ceil and floor in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.