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

Explain lock escalation? : Transact sql

1154

How to use sql statements in pl/sql?

1064

How to combine two stored procedures in sql?

1133

What is union and union all keyword in sql and what are their differences?

1052

Explain the commit statement.

1110

What is package in pl sql?

973

How do I save the results of sql query in a file?

937

what is union, minus and interact commands? : Sql dba

1128

Define a temp table?

978

what is primary key? : Sql dba

965

What is memory optimized table?

991

what is the use of set statement in tsql? : Transact sql

957

How to get unique records from a table?

909

Differentiate between syntax and runtime errors.

1129

How to install oracle sql developer?

996