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 difference between decode and case function?

2 Answers  


Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  


Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,


how to find 5th row ?

10 Answers  


What are the constraints available in sql?

0 Answers  






explain commit and rollback in mysql : sql dba

0 Answers  


what is a record in a database ? : Sql dba

0 Answers  


What is online transaction processing (oltp)?

0 Answers  


How to create a menu in sqlplus or pl/sql?

0 Answers  


how to create a database in oracle?

3 Answers  


Explain table and field in sql?

0 Answers  


What type of database is cloud sql?

0 Answers  


Categories