T-SQL to PL/SQL Please

From: Steve Hennessey <steve_at_hennessey.net>
Date: Thu, 18 Apr 2002 05:23:43 GMT
Message-ID: <g4msbusrm2a3ma59rtunc9fihoog9b2arf@4ax.com>

Can anyone make a literal conversion of the following T-SQL script to Oracle PL/SQL for me?
I have no idea where to start.

Any help greatly appreciated,
Steve.

DECLARE @FLOWCONTROL INTEGER
SET @FLOWCONTROL = @@ERROR IF @FLOWCONTROL = 0
  BEGIN
    PRINT ' '
    PRINT 'SetScript.sql STEP 1'
    IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.tables WHERE TABLE_NAME = 'CUSTOMERMAP')
    CREATE TABLE EMPOWER.CUSTOMERMAP (

      MAPSCRIPT IMAGE,
      LASTMOD DATETIME)

  END
else
  BEGIN
    PRINT ' '
    PRINT 'SetScript.sql Step 1'
    raiserror(57012,12,1) with seterror
  END
GO

DECLARE @FLOWCONTROL INTEGER
SET @FLOWCONTROL = @@ERROR IF @FLOWCONTROL = 0
  BEGIN
    PRINT ' '
    PRINT 'SetScript.sql STEP 2'
    IF NOT EXISTS(SELECT * FROM EMPOWER.LAST_MOD where TABLENAME = 'CUSTOMERMAP')

      INSERT INTO EMPOWER.LAST_MOD (TABLENAME, CATEGORY, DESCRIPTION)
      VALUES ('CUSTOMERMAP','CUSTOMER CENTRIC','Import/Export Script')

  END
else
  BEGIN
    PRINT ' '
    PRINT 'SetScript.sql Step 2'
    raiserror(57012,12,1) with seterror
  END
GO

DECLARE @FLOWCONTROL INTEGER
SET @FLOWCONTROL = @@ERROR IF @FLOWCONTROL = 0
  BEGIN
    PRINT ' '
    PRINT 'SetScript.sql STEP 13'
    IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.[COLUMNS] WHERE TABLE_NAME = 'INSPINFO' AND COLUMN_NAME = 'PCTOFCOVG')       ALTER TABLE EMPOWER.INSPINFO ADD PCTOFCOVG FLOAT(53)   END
else
  BEGIN
    PRINT ' '
    PRINT 'SetScript.sql Step 13'
    raiserror(57012,12,1) with seterror
  END
GO Received on Thu Apr 18 2002 - 00:23:43 CDT