A simple PL/SQL question...

Hi all,

I'm trying to port a SQL Sever application to Oracle. How do I write the following statement in PL/SQL?

IF EXISTS(SELECT 1 FROM table_x WHERE column_a = 'X')

    ... do stuff

The main purpose of the statement is to test if a record exists.

Thanks in advance,
Aiden Received on Fri May 14 2004 - 19:55:31 CDT