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 clustered index in sql?

0 Answers  


Is sql a scripting language?

0 Answers  


What is a schema sql?

0 Answers  


What are all the difference between Like and Contains ?

2 Answers   LG Soft,


Why is theta join required?

0 Answers  






Which one is better sql or oracle?

0 Answers  


How do you change a value in sql?

0 Answers  


What does where 1 1 mean in sql?

0 Answers  


What are types of exception?

0 Answers  


What is the purpose of normalization?

0 Answers  


Which is faster truncate or drop?

0 Answers  


Does sql*plus have a pl/sql engine?

0 Answers  


Categories