Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: T-SQL to PL/SQL Please

Re: T-SQL to PL/SQL Please

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 18 Apr 2002 02:57:57 -0700
Message-ID: <a20d28ee.0204180157.3ec629f4@posting.google.com>


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
Received on Thu Apr 18 2002 - 04:57:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US