type type_name is table of varchar2(30) index by binary

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 / sweetsarao

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

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

Answer / 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