Home » SQL & PL/SQL » SQL & PL/SQL » Arrays in PL SQL
Arrays in PL SQL [message #38214] Tue, 02 April 2002 03:52 Go to next message
Hrishikesh Potdar
Messages: 1
Registered: April 2002
Junior Member
Hey guys,

Can one define an array in pl/sql and then use it in the where clause eg:

define array (9,10)

..

select * from table_name
where column_name in (select colname from array)

or

where colname = array.value

Please let me know..thx..

Regards,
Rishi

Report message to a moderator

Re: Arrays in PL SQL [message #38217 is a reply to message #38214] Tue, 02 April 2002 08:15 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
arrays and pl/sql tables are virtually the same. Use pl/sql tables.
http://asktom.oracle.com/pls/ask/f?p=4950:8:97868::NO::F4950_P8_DISPLAYID,F4950_P8_B:246014735810,Y

Report message to a moderator

Previous Topic: Re: List of Tables in Database
Next Topic: Re: Interaction between VB and Oracle Procedure using Cursor as return type
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 01 17:11:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.