Home » SQL & PL/SQL » SQL & PL/SQL » URGENT: PL/SQL TABLE
URGENT: PL/SQL TABLE [message #40987] Fri, 15 November 2002 06:38 Go to next message
Samir
Messages: 32
Registered: April 2002
Member
Hello the world;
please i need a help !
how can i use PL/SQL table to stores a data of my database table table1 ( id, name, amt).
raison:
i have a procedure that when executing need to read my table table1 n times. thus to avoid this i want to store a data in temporary table (pl/sql table) and use these data in run time.
Please this is urgent

Thinks.

Report message to a moderator

Re: URGENT: PL/SQL TABLE [message #40993 is a reply to message #40987] Fri, 15 November 2002 08:23 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
It is easy enough to do, but you should read this before you leap to a possibly incorrect conclusion that this will be more efficient:
http://asktom.oracle.com/pls/ask/f?p=4950:8:1598238::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:5408706816128,%7Bpl%2Fsql%7D%20and%20%7Btable%7D%20and%20%7Bmore%7D%20and%20%7Befficient%7D

Report message to a moderator

Previous Topic: Re: database login problem
Next Topic: dbms_job package problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 06 14:05:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.