Re: How: convert a Sybase query to Oracle query

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 15 Mar 1999 16:40:11 GMT
Message-ID: <36f037bf.13874059@192.86.155.100>

A copy of this was sent to wesley_xu_at_yahoo.com (if that email address didn't require changing) On Mon, 15 Mar 1999 15:23:21 GMT, you wrote:

>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
>

drop table usocback;
create table usocback as select * from m_usoc; truncate table i_usoc;

>/* 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
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Mar 15 1999 - 10:40:11 CST