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
Is postgres faster than oracle?
What is Java Pool in Oracle?
How to pass a cursor variable to a procedure?
How to use group functions in the select clause using oracle?
What are the ways tablespaces can be managed and how do they differ?
How a tablespace is related to data files?
Explain the use of rows option in exp command.
Difference between inner join vs where ?
How to check your oracle database 10g xe installation?
How to turn on or off recycle bin for the instance?
How to increment dates by 1 in oracle?
What is the difference between online and offline backups?
How to use "for" statements in oracle?
Can a formula column be obtained through a select statement ?
Can we write dml statement in function in oracle?
