Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / priya tyagi
1.In Oracle 8i defualt table space is dictionary managed
where as in 9i it is locally managed.
2.oracle 8i doesn't provide auto undo segment managment
where as 9i provides auto undo segment managment .
3.in 8i multi table insert is not possible where as it is
present in 9i.
4.in 8i Dynamic memory managment facility is not present
which is present in oracle 9i.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
Explain cursor types?
Is nosql relational?
what is “go” in t-sql? : Transact sql
What will you get by the cursor attribute sql%notfound?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Can we use two order by clause in query?
Why is the cursor important?
what is union, minus and interact commands? : Sql dba
Why do we need cursor in pl sql?
What is the difference between pl and sql?
Is drop table faster than truncate?
What is sql partition function?
What is pragma in sql?
Is it possible to sort a column using a column alias?
write an sql query to find names of employee start with 'a'? : Sql dba
