Struggling with multiple response scrip?

[ASmee]

I want to write a script that will do the following:

1 - select colum from table where condition = "R"

Then I want wrap this statement around the condition that if the outcome of the above is 0 rows then:

select message from messages where id = 1

I am struggling with Oracle, I could right it in MS SQL.

 

[sem]

Try something like

select message from messages where id = 1
and not exists ( select colum from table where condition = "R&quot

Note that in Oracle string literals are quoted by single quotes.

Regards, Dima