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...


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is trigger in sql?

0 Answers  


What are all different types of collation sensitivity?

0 Answers  


How do sql databases work?

0 Answers  


What does select count (*) mean in sql?

0 Answers  


How to write pl sql program in mysql command prompt?

0 Answers  






i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,


What is auto increment in sql?

0 Answers  


Is microsoft sql free?

0 Answers  


What is t-sql? : Transact sql

0 Answers  


what is meant by databases

4 Answers  


What is the use of index in hive?

0 Answers  


What is date functions?

0 Answers  


Categories