Re: T-SQL to PL/SQL Please

Steve Hennessey <steve_at_hennessey.net> wrote in message news:<g4msbusrm2a3ma59rtunc9fihoog9b2arf_at_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

How much do you offer to pay for doing your work? (ie reading manuals and the like). It looks like you just want to pass off someone elses work as your own and refuse to learn Oracle.

--
Regards

Sybrand Bakker
Senior Oracle DBA