| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: pl/sql question
Or use a cursor variable.
Jared
Christopher
Spence To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
<cspence_at_FuelS cc:
pot.com> Subject: RE: pl/sql question
Sent by:
root_at_fatcity.c
om
10/02/01 10:30
AM
Please respond
to ORACLE-L
Use DBMS_SQL or EXECUTE IMMEDIATE
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-----Original Message-----
Sent: Tuesday, October 02, 2001 12:50 PM
To: Multiple recipients of list ORACLE-L
Can I somehow use a variable for the table name in a cursor select?
Here is the example:
--Declaration Section
sSrcTableName VARCHAR2(50) := iFeedNm||'_1_1_' ||TO_CHAR(SYSDATE,'YYMMDD')||'_SRC';
--cursor for tmo daily source records
CURSOR cTMODaily IS
SELECT *
FROM sSrcTableName;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Eric.Chesebro_at_chase.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 02 2001 - 13:40:23 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |