https://sqlines.com/ 2026-04-17T15:33:24+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2012-03-28T09:04:15+00:00 https://sqlines.com/sybase-asa-to-oracle/autoincrement_identity?rev=1332925455&do=diff DEFAULT AUTOINCREMENT and IDENTITY properties allow you to automatically generate unique integer numbers (IDs, sequences) for a column in Sybase ASA. Quick Example: -- Define a table with DEFAULT AUTOINCREMENT (id starts at 1) CREATE TABLE cities ( id INTEGER DEFAULT AUTOINCREMENT, name VARCHAR(90) ); -- Insert a row, ID will be automatically generated INSERT INTO cities (name) VALUES ('San Francisco'); -- Retrieve generated ID SELECT @@IDENTITY; … text/html 2012-04-02T15:45:16+00:00 https://sqlines.com/sybase-asa-to-oracle/data?rev=1333381516&do=diff SQLines and SQLData tools can help convert database schema and transfer the data from Sybase SQL Anywhere to Oracle. * SQLData - High Performance Data Migration Tool (Free and Commercial Editions Available) Sybase SQL Anywhere and Oracle Versions The following versions are supported: text/html 2013-04-17T09:54:22+00:00 https://sqlines.com/sybase-asa-to-oracle/datetime?rev=1366192462&do=diff Sybase SQL Anywhere DATETIME data type stores date and time data - year, month, hour, minute, second and fraction of a second. Quick Example: -- Define a table with a DATETIME column in Sybase SQL Anywhere CREATE TABLE orders ( order_datetime DATETIME ); -- Insert a datetime value - March 20, 2012 05:09:31.123456 INSERT INTO orders VALUES ('2012-03-20 05:09:31.123456'); text/html 2012-03-26T12:16:11+00:00 https://sqlines.com/sybase-asa-to-oracle/default?rev=1332764171&do=diff The DEFAULT clause allows you specifying the default value for a column. The default value is assigned if you omit the column or specify DEFAULT keyword in a INSERT statement. Quick Example: -- Create a table CREATE TABLE teams ( id int, name VARCHAR(80) DEFAULT 'N/A' ); -- Insert default value 'N/A' to name column INSERT INTO teams(id) VALUES (1); INSERT INTO teams VALUES (2, DEFAULT); -- Insert default values to all columns INSERT INTO teams DEFAU… text/html 2012-03-29T11:13:45+00:00 https://sqlines.com/sybase-asa-to-oracle/key_join?rev=1333019625&do=diff KEY JOIN clause allows you joining 2 or more tables based on their foreign key relationship, and does not require specifying columns and ON condition. Quick Example: -- Define a parent table CREATE TABLE states ( abbr CHAR(2) NOT NULL PRIMARY KEY, name VARCHAR(90) ); -- Define a child table CREATE TABLE cities ( name VARCHAR(90), state CHAR(2) REFERENCES states ); -- Querying tables using KEY JOIN SELECT c.name, s.name FROM citie… text/html 2012-04-02T14:08:54+00:00 https://sqlines.com/sybase-asa-to-oracle/statements?rev=1333375734&do=diff Conversion of of Sybase SQL Anywhere statements to Oracle. denotes syntax or functional differences, or more strict restrictions when you convert from Sybase SQL Anywhere to Oracle. Summary SQL statement mapping: Sybase SQL Anywhere Oracle 1 COMMENT ON COLUMN The same syntax, no conversion required, but identifiers maybe changed 2 COMMENT ON TABLE The same syntax, no conversion required, but identifiers maybe changed 3 CREATE DOMAIN CREATE TYPE Last Update: Sybase SQL A…