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

Why are sql stored procedures used?

0 Answers  


how to create temparary sequence

2 Answers   TCS,


Can a commit statement be executed as part of a trigger?

0 Answers  


Can we join 3 tables in sql?

0 Answers  


What are triggers and its uses?

0 Answers  






what is rdbms? : Sql dba

0 Answers  


function can return multiple value?how give give sample coding

2 Answers   3i Infotech, CTS, Excelity Global, UHG,


When should I use nosql database?

0 Answers  


Is pl sql a scripting language?

0 Answers  


how to rename an existing table in mysql? : Sql dba

0 Answers  


Will truncate release space?

0 Answers  


What is sql injection owasp?

0 Answers  


Categories