Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kalpana
merge is a command which is used to both insert and delete.
timestamp datatype is introduced.
max no of columns in 8i is 256 where as in 9i we can have
999.
on delete set null supports only in 9i.
by using this, when we delete the parent record the child
records are replaced with null values
| Is This Answer Correct ? | 11 Yes | 7 No |
Post New Answer View All Answers
How does one get the view definition of fixed views/tables?
What is a nvl function? How can it be used?
What is the best way to do multi-row insert in oracle?
how to handle exceptions in post production
Can group functions be mixed with non-group selection fields?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to export several tables together?
What are the attributes that are found in a cursor?
How to drop an existing view in oracle?
How to invoke the data pump import utility?
what is the difference between substr and instr function in oracle?
What is user managed backup in Oracle?
What is an oracle user account?
What is an oracle tablespace?
How to create a new user account in oracle?
