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
What is enter substitution variable in oracle?
How to use null as conditions in oracle?
What is system tablespace?
Explain the use of rows option in imp command.
What is a directory object?
Difference between varchar and varchar2 data types?
How to display employee records who gets more salary than the average salary in the department?
What happens if the update subquery returns multiple rows?
Why do you use stored procedures and state some of its disadvantages?
What is redo log?
How to drop an existing table in oracle?
What happens in oracle commit?
How will you write a query to get a 5th rank student from a table student_report?
What is the fastest query method to fetch data from the table?
What is the difference between translate and replace?
