Question on the IF Clause

From: Brandon Duncan <BDuncan_at_PIETECHNET.com>
Date: Tue, 12 Oct 1999 17:12:56 -0400
Message-ID: <7u08co$d1r$1_at_autumn.news.rcn.net>

To anyone who knows the answer:
[Quoted] [Quoted] Why does the following SQL Block fail on line 8? Are there only certain [Quoted] statements which can fall within an IF clause? If, so, what are they?

1     DECLARE
2           llTableExists     NUMBER(11,0);

3     BEGIN
4           SELECT INTO llTableExists TABLE_NAME FROM ALL_TABLES WHERE
TABLE_NAME = 'Table1' AND 5            OWNER = 'OWNER1';
6
7            IF llTableExists >=1 THEN
8                DROP TABLE Table1;
9            END IF;

10 END; Thanks,

Brandon Received on Tue Oct 12 1999 - 23:12:56 CEST