If a cursor is open, how can we find in a pl/sql block?
No Answer is Posted For this Question
Be the First to Post Answer
how many no of table can be join in a sql query.
How do I add a database to sql?
What is a system versioned table?
How to find only %th Highest Sal
Explain constraints in sql?
Can we use joins in subquery?
Can a view be mutating? If yes, then how?
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 do you run a query?
Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.
What is function and procedure?
How do you break a loop in pl sql?