Do we need to create index on primary key?
No Answer is Posted For this Question
Be the First to Post Answer
How will you delete a particular row from a Table?
What is the difference between microsoft access and sql server?
What is pivot query?
Is it possible to create startup or shutdown trigger for on-schema?
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...
How can we avoid duplicating records in a query?
What is pseudo column ?
What is sap sql?
How to create an array in pl/sql?
define different types of trigger. : Sql dba
What is basic structure of pl sql?
What is the difference between anonymous block and named block or stored procedure?