Importing Sybase SQL into Oracle

From: Emtek pc <ahc2_at_execpc.com>
Date: 1998/03/25
Message-ID: <6fc6rh$et7@newsops.execpc.com>#1/1

What would be involved in setting up the database table schema in Oracle and porting the current Sybase databases to Oracle?

The following statments are generated by a foreign system. The target is a SYBASE system. Are there any tools which would translate this "code" into Oracle syntax?

Sample insert statement:

INSERT INTO c_all_labs ( entered_at,
entered_by,
time_for,
data_src,
specimen_handle,
unique1,
l_value01,
l_value01_1,
rmt_entry_time,
specimen_annotation,
a_ref_range,
foo_id,
object_name, instance_number,
changed_date) VALUES ( "19980312 01:41:28", -1,
"19980312 01:30:00",

NULL,
656,
"G156502-0-1",
"75",

NULL,
"19980312 01:52:00",

0,
NULL,
220467,
"LAB_FIO2", 500,

NULL) go
Regards,

Jim.Vlazny_at_aurora.org Received on Wed Mar 25 1998 - 00:00:00 CST