Answer Posted / sujit pharande
In 9i merge , insert all, case is introduced .
SPfile in 9i which is not available in 8i version.
Oracle 9i added idea of somewhat pure m-commerce database
with lot of data warehouse feature .
In oracle 8i default tablespace is dictonary managed while
in 9i it is locally managed.
| Is This Answer Correct ? | 26 Yes | 5 No |
Post New Answer View All Answers
Why query optimization is needed?
What are the uses of sysdate and user keywords?
What is query optimization in sql?
What is sql used for?
Why do we use procedures?
What is recursive stored procedure?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
What is a behavioral trigger?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What does where 1/2 mean in sql?
What is embedded sql in db2?
what is the command line end user interface - mysql? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?
How can a pl sql block be executed?
What is use of package in pl sql?