OraFAQ Forum: Server Administration » how to create pl/sql tables and how to manupulate data in that

Home » RDBMS Server » Server Administration » how to create pl/sql tables and how to manupulate data in that

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

how to create pl/sql tables and how to manupulate data in that [message #369872]

Mon, 30 October 2000 19:31

Hari
Messages: 59
Registered: August 2000

Member

Hi,
Could you please tell me how to create pl/sql tables and how to insert multiple records into them
and how to update those pl/sql table in a stored procedure.

I have a situattion I need to create 4 pl/sql tables and insert values from the database tabales.

Next step is select values from pl/sql table and insert them into another pl/sql table.

if you have any sample code please send me in reply.

Thanks & Regards,
Hari

Report message to a moderator

Re: how to create pl/sql tables and how to manupulate data in that [message #369884 is a reply to message #369872]

Wed, 01 November 2000 23:03

Sonali Panda
Messages: 4
Registered: November 2000

Junior Member

To create PL/SQL table the command is

TYPE t_tablename IS TABLE OF DATATYPE(LENGTH)
INDEX BY BYNARY_INTEGER;

Report message to a moderator

Previous Topic:	Re: Create Package body problem in Oracle v7.3
Next Topic:	How to increase the MAX_ENABLED_ROLES for SYS?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 18:13:22 CDT 2024