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 sql database should I use?
What is sql*loader and what is it used for?
Explain what is sql*plus?
Can we use pl sql in sql server?
What is the difference between functions, procedures, and packages in pl/sql?
How do you explain an index?
In a distributed database system, can we execute two queries simultaneously?
Explian rowid, rownum?
What are sql functions? Describe in brief different types of sql functions?
What is a .db file?
What are system versioned tables?
How long it takes to learn pl sql?
What is varchar example?
How do I pipe the output of one isql to another?
What are different types of triggers?