Convert Sybase scripts to Oracle scripts
Posted on 2004-08-27
I've got problem converting a sybase scripts to oracle scripts. Here is the Sybase script:
if exists (select name from sysobjects
where name = "parameter" and type = "U")
print "Dropping table: parameter - for replacement"
drop table parameter
How shoud it be converted to Oracle scripts? The difficulties include:
1) PL/SQL does not allow DROP TABLE
2) I dont know the equivalences for sysobjects, type in Oracle
Would appreciate very much if you can provide the complete conversion for the above script.