Decode() function query in Oracle

Question

Can we use a select query in embedded sql (Pro*C) as the first argument in a Decode() function.

Are you sure you need to do that? Is there no criteria you can use to join on? — OMG Ponies, Dec 31 '09 at 08:46

score 1 · Answer 1 · answered Dec 31 '09 at 08:35

1

I'm not sure about embedded sql, but I guess it should work:

SELECT DECODE( ( SELECT 1 FROM dual ), 1, 'Yes', 'No' ) FROM dual

Yes

You need to put the SELECT in brackets.

answered Dec 31 '09 at 08:35

Peter Lang

I have edited the question, my intention is to use this in ProC (Embedded sql in C) – Sachin Dec 31 '09 at 08:38
1

What happens when you try that? – Tony Andrews Dec 31 '09 at 10:09
There's a lot of modern SQL constructs (eg introduced since 8.0) the precompilers can't use directly. You can use dynamic SQL or hide the SQL in a view. – Gary Myers Jan 03 '10 at 09:59

1 Answers1