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 a temporal table?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
what is a field in a database ? : Sql dba
Explain the rollback statement?
How do you update a sql procedure?
What is bind variable in pl sql?
How to add a column ‘salary’ to a table employee_details?
what is union, minus and interact commands? : Sql dba
What's the difference between a primary key and a clustered index?
Which command is used to delete a package?
What found sql?
Is pl sql a programming language?
Does postgresql run on the cloud?
What is the difference between pl and sql?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000