SQL & PL/SQL

Hi All,

I'm in oracle 10gr2.

In a PL/SQl block I'm trying to verify if a table exist, is exist then i need to drop the table...the following query fails saying that the query is not correct...

PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:

   ( - + case mod new not null others <an identifier>

if NVL((SELECT table_name
                FROM all_tables
                WHERE owner = 'CORE' AND table_name = 'TBL_EDGE'), 'N')='N' then
                

        null;
        execute immediate ('DROP TABLE CORE.TBL_EDGE);

Any help is appreciated.

Thanks in advance
NU