Oracle "IF" Question

Hello. I am new to SQL and Oracle, and I have a script that I'm trying to run on an Oracle database. However, the following line fails; the interpreter claims that it is an invalid SQL statement:

IF NOT EXISTS (SELECT * FROM sys.DBA_USERS WHERE username = 'Admin') CREATE USER Admin IDENTIFIED BY password

Does any have any ideas what I am doing wrong?

Thanks,
Steve Received on Mon Aug 02 1999 - 11:41:55 CDT