NT MS SQL SERVER 6.5 to UNIX ORACLE 8 on Solaris

From: John Duran <d3plan_at_hotmail.com>
Date: Fri, 22 Oct 1999 20:43:27 GMT
Message-ID: <7uqi9f$fmc$1@nnrp1.deja.com>

Would apprecitate some help in rewriting the following MS SQL SERVER 6.5 (on NT) scripts into UNIX ORACLE 8.0.5 on Sun SPARC running Solaris 2.6/

#1/****** Object: Group qswebs Script Date: 10/21/99 ******/
if not exists (select * from sysusers where name = 'qswebs' and uid > 16383)

EXEC sp_addgroup 'qswebs'
GO

#2/****** Object: Stored Procedure dbo.SP_Load_Order_Export_Data
Script Date: 10/21/99 ******/
if exists (select * from sysobjects where id = object_id ('dbo.SP_Load_Order_Export_Data') and sysstat & 0xf = 4)

drop procedure dbo.SP_Load_Order_Export_Data GO

#3/****** Object: Table dbo.QST_Tracking_Info Script Date: 10/21/99
******/
if exists (select * from sysobjects where id = object_id ('dbo.QST_Tracking_Info') and sysstat & 0xf = 3)

drop table dbo.QST_Tracking_Info
GO

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 22 1999 - 15:43:27 CDT