OraFAQ Forum: SQL & PL/SQL » how to read the data from type created as table

Home » SQL & PL/SQL » SQL & PL/SQL » how to read the data from type created as table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to read the data from type created as table [message #18756]

Wed, 13 February 2002 07:13

ksr
Messages: 112
Registered: January 2002

Senior Member

Hi,

I have few questions

1) How to create a type of table(or like table)

2) How do i assign the data to this type which is a selection of records from another select statement

3) How do i read all the columns in a loop from this type of table

Any example will be useful..

any help is appreciated

Report message to a moderator

Re: how to read the data from type created as table [message #18758 is a reply to message #18756]

Wed, 13 February 2002 07:30

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

How to create a type of table(or like table)
------------------------------------------
what do u mean by type of table.do u mean pl/sql table of records ?

Report message to a moderator

Re: how to read the data from type created as table [message #18761 is a reply to message #18756]

Wed, 13 February 2002 08:04

ksr
Messages: 112
Registered: January 2002

Senior Member

Hi,
I mean something like

type cur1 is table of tab1%rowtype;

Report message to a moderator

Re: how to read the data from type created as table [message #18775 is a reply to message #18756]

Wed, 13 February 2002 23:46

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

here is an example

declare
type cur1 is table of emp%rowtype index by binary_integer;
a cur1;
cursor abc is select * from emp;
n number:=0;
begin
for tmp in abc
loop
n:=n+1;
a(n).ename:=tmp.ename;
a(n).sal:=tmp.sal;
end loop;
end;

Report message to a moderator

Previous Topic:	Re: SQL TUTORIAL.
Next Topic:	how do i delete the records

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:08:36 CDT 2024