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
Explain parameter file in oracle.
Explain what does a control file contain?
what is the dual table in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
How to change system global area (sga) in oracle?
Who developed oracle & when?
What is set verify off in oracle?
How to connect to a remote server?
How is it different from a normal table?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to change program global area (pga) in oracle?
Which are the five query types available in oracle?
What are the different types of database objects?
What is a cognitive schema?
How to assign values to data fields in record variables?
