Hi, When you are using this: cursor cursor

type type_name is table of varchar2(30) index by
binary_integer
for the above type you have to create a identifier...

like

identifier_name type_name;

for the above type you can use the below methods..like
first , last , prior, next , delege..etc...like this..

if you create a cursor...like

cursor cursor_name is select * from scott.emp;
is there any methods like above to use prior, fist , last ,
next , trim ,etc...

Question Posted / sagar

1 Answers
7195 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / sagar

Hi,

When you are using this:

cursor cursor_name is select * from scott.emp;

you can use
record_name cursor_name%rectype;

But I think the methods you mentioned like prior, fist ,
last ,
next , trim ,etc...are not present here..(Iam not sure)

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a common use of group by in sql?

994

Which is faster count (*) or count 1?

964

What is an inconsistent dependency?

978

Can we create a trigger on view?

840

How can a function retun more than one value in oracle with proper example?

1025

How can you create an empty table from an existing table?

1009

what is collation? : Sql dba

1077

Can we use commit inside a trigger?

1026

What is your daily office routine?

2215

Can a foreign key be null?

1029

How many types of tables are there?

899

Which command is used to delete a package?

1089

What is the best sql course?

930

What is embedded sql with example?

984

How can you get sql*loader to commit only at the end of the load file? : aql loader

964