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
7280 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

Are null values same as that of zero or a blank space?

1028

Does sql*plus have a pl/sql engine?

1075

what is sub-query? : Transact sql

1105

What is data profiling in sql?

1081

Can we join tables without foreign key?

962

What is parallel hint?

1328

What is bulk compiling in pl/sql.?

1130

What is the use of function "module procedure" in pl/sql?

1198

What are dml commands?

1020

What does seeding a database mean?

968

What is sql and also describe types of sql statements?

1066

What is the difference between the sql*loader and import utilities? : aql loader

1043

what is “go” in t-sql? : Transact sql

1105

Is null operator in sql?

1041

How to run sql statements with oracle sql developer?

1070