How do you explain an index number?
No Answer is Posted For this Question
Be the First to Post Answer
What is user define exception and example
What plvcmt and plvrb does in pl/sql?
What is normalisation in sql?
What is the criteria while applying index to any column on any table.
How do you declare a constant?
What does stand for in sql?
what is msql? : Sql dba
What are the subsets of sql?
Explain uses of cursor.
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...
Can we use the cursor's to create the collection in PL/SQL?
What is group by in sql?