Answer Posted / narayan mishra
->SGA stands for System Global Area.
->it store the data and control information for oracle srever.
->it can be shared by database processes.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do you identify a primary key?
What is dense_rank in sql?
how to enter binary numbers in sql statements? : Sql dba
How does sql profiler work?
Mention what does the hierarchical profiler does?
What is a dirty read sql?
How to select random rows from a table?
What is numeric function sql?
How do you add a column to a table?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is a database trigger?
What is the purpose of using pl/sql?
Can we insert data in view?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is the difference between delete and truncate statement in sql?