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 rank () in sql?
What are the indexing methods?
Can we use ddl statements in stored procedure sql server?
Is primary key always clustered index?
How is sql used in oracle?
What is string data type in sql?
How do I enable sql encryption?
how to add a new column to an existing table in mysql? : Sql dba
what are properties of a transaction? : Sql dba
How do I view stored procedures?
How do you explain an index number?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
Does sql require a server?
Is full outer join same as cross join?
Differentiate pl/sql and sql?