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
What is primary and foreign key?
what is user defined functions? : Sql dba
What are local and global variables and their differences?
What is cost in sql execution plan?
What are the indexing methods?
What is a join?
Can we update views in sql?
how to shutdown mysql server? : Sql dba
Which is faster truncate or drop?
what is 'mysqld'? : Sql dba
How do I find duplicates in two columns?
Is it possible to pass parameters to triggers?
What are the operators used in select statements?
describe transaction-safe table types in mysql : sql dba
How do I filter in sql profiler?
