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 there a function to split a string in plsql?
what are actual and formal parameters?
What do you mean by merge in oracle?
How do I find the database name in oracle?
Explain compound trigger in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to set up autotrace for a user account?
What are a collation and state the different types of collation sensitivity?
What is merge in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is the difference between formal parameters and actual parameters?
Explain joins in oracle?
What is control file used for?
How to install oracle database 10g xe?
How do you tell what your machine name is and what is its IP address?
