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
List and explain the different types of join clauses supported in ansi-standard sql?
What is embedded sql with example?
What are the advantages of pl sql over sql?
What is Difference Between Unique and Primary Key Constraints?
What is field delimiter?
what is bcp? When is it used?
What is the plv (pl/vision) package offers?
what are the differences between char and nchar? : Sql dba
How do you update a table in sql?
What is sharding in sql?
How do I create a memory optimized filegroup?
What is the size of partition table?
What is a sql trace file?
What is mutating error in pl sql?
What are the main features of cursor?
