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
Explain the use of online redo log files in oracle.
What are the system predefined user roles?
Give the advantages and disadvantages of clusters.
What is concurrency in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to create a testing table in oracle?
What is an anonymous block?
How to use regular expression in pattern match conditions in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Why oracle is used?
How to convert raw data type into text in oracle? Explain
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Explain the use of inctype option in exp command.
What are the logical operations?
