Re: help with decode command: is there a way to include a select statement in the result of a decode function

I don't think you can do this because you can't execute the output of a SQL statement.

You may try to spool the output of a SQL statement to a file, and then run that file. However, you have to set the SQL*Plus to eliminate the heading and feedback.

Let me know if there are any solutions!

dan wrote:
>
> i want to use the decode command but the result of the search should be a
> select statement
>
> i.e. select decode(payrate, 1, 'text'
> 2, column name
> 3, "a select statement with a where
> clause)
> from labor;
>
> is this possible
> select decode(payrate, 1, 'hi'
> 2, laborcode
> 3, select status from stat where age = 32)
> from labor;
>
> I tried quotes around select etc nothing works any way to do it?
>
> Dan Ramriez

--

Stanley Fung                 | Software Analyst
Mobile Data Solutions Inc.   | Direct Line: (604)207-6290
Suite 135                    | Tel:         (604)270-9939
10551 Shellbridge Way,       | Fax:         (604)270-1310
Richmond, B.C.               | E-Mail:      sfung_at_mdsi.bc.ca
Canada V6X-2W9               | http://www.mdsi-advantex.com

------------------------------------------------------------