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
7267 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 error ora-01000: maximum open cursors exceeded

1132

What are the constraints available in sql?

1037

How to process query result in pl/sql?

1113

Is sql scripting language?

1039

Is left join faster than inner join?

1116

How do you update sql?

963

What is database migration?

960

What is the best free sql database?

1049

Is pl sql a scripting language?

1021

Write a sql query to convert all character to uppercase after hypen.

1425

How many types of sql are there?

982

what are wild cards used in database for pattern matching ? : Sql dba

1131

Is left join and outer join same?

1049

Is not equal in sql?

1005

What is the difference between view and stored procedure?

955