From: andyho99@yahoo.com
Newsgroups: comp.databases.oracle.misc
Subject: PL/SQL question
Date: Tue, 12 Dec 2000 16:51:29 GMT
Organization: Deja.com
Lines: 12
Message-ID: <915l2d$l4p$1@nnrp1.deja.com>
NNTP-Posting-Host: 204.71.174.14
X-Article-Creation-Date: Tue Dec 12 16:51:29 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
X-Http-Proxy: 1.0 RKV-SRV-MSP2B, 1.0 x57.deja.com:80 (Squid/1.1.22) for client 204.71.174.14
X-MyDeja-Info: XMYDJUIDandyho99


Hi,

Is it possible to declare a cursor where treat a table name as a
variable in PL/SQL (tried to retrieve data from same column name among
many tables)? I had been using variables in where clause but not table
name. It seemed that PL/SQL didn't like my idea.

Thanks, Andy


Sent via Deja.com
http://www.deja.com/