How: convert a Sybase query to Oracle query

From: <wesley_xu_at_yahoo.com>
Date: Mon, 15 Mar 1999 15:23:21 GMT
Message-ID: <7cj8kr$tln$1@nnrp1.dejanews.com>

Does anyone know how to properly convert the following Sybase query to Oracle one?

/*

** Preparation table I_usoc before load new data

1. drop the backup table;
2. back up the production table;
3. truncate the production table for loading new data; */

use RFDB
go

if exists (select * from sysobjects where name = 'usocback')

drop table usocback
go

select * into usocback from m_usoc
go

truncate table I_usoc
go

/* End */

Any help will be appreciated.

Wesley

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 15 1999 - 09:23:21 CST