Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: variable and cusor definition

Re: variable and cusor definition

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Mon, 09 Jul 2001 15:33:38 -0700
Message-ID: <3B4A3142.14E4A2BC@attws.com>

Tony wrote:

> How to pass a variable or parameter into a column name or table name into the
> cursor definition(such as 'CUSROR get_date IS SELECT &2 from &1') (not talking
> about in where clause or subselect statement).
>
> Thanks.

Use native dynamic SQL.

Daniel A. Morgan Received on Mon Jul 09 2001 - 17:33:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US