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

Home -> Community -> Usenet -> c.d.o.misc -> Dynamic Columns in a Select Statement

Dynamic Columns in a Select Statement

From: T.S.S. <tss_at_webspace.com.au>
Date: Tue, 22 Dec 1998 17:05:44 +1030
Message-ID: <367F3DBF.5BC67F97@webspace.com.au>


Here's a quick question:

I need to have a select statement with a dynamic number of columns returned depending on an input parameter.

The catch is, I need to use it within a OPEN v_Cursor FOR SELECT ... type structure (i.e. REF CURSOR);

Any ideas?

Paul. Received on Tue Dec 22 1998 - 00:35:44 CST

Original text of this message

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