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

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  


How do you take the union of two tables in sql?

0 Answers  


How show all rows in sql?

0 Answers  


Is there a 64 bit version of ssms?

0 Answers  


What is trigger and stored procedure in sql?

0 Answers  






What is indexing oracle sql?

0 Answers  


What is int identity in sql?

0 Answers  


What are the types pl/sql code blocks?

0 Answers  


What are the different types of functions in sql?

0 Answers  


Is time a data type in sql?

0 Answers  


Why do we use subquery?

0 Answers  


what is a composite key ? : Sql dba

0 Answers  


Categories