You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for Sybase


1 to 20 of 320 results. Previous page Prev  Next next page
Results per page:  20 |  40  | 60


Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Database Gateway for Sybase User's Guide - Contents

ContentsDatabase Gateways 2 Sybase Gateway Features and Restrictions 2.1 Using the Pass-Through Feature 2.2 … Issues for Sybase 2.7.1 Chained Mode 2.7.2 Column Definitions 2.7.3 Naming Rules 2.7.3.1 Rules for … Variables 2.7.6 Locking 2.7.7 Sybase Identifiers Length Limit 2.8 Known Restrictions 2.8.1 Transactional … Cursors 2.8.4 Stored

SQL Developer User's Guide, 11g Release 2 (11.2)

Migrating Third-Party Databases

Before Migrating From Microsoft SQL Server or Sybase Adaptive ServerTo configure a Microsoft SQL Server or Sybase Adaptive Server database for migration: Ensure that … the source database is accessible by the Microsoft SQL Server or Sybase Adaptive Server user that is … captured in the Microsoft SQL Server or Sybase Adaptive Server database; objects that the user cannot … can connect to the Microsoft

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle SybaseB.2.2.4 String Functions Oracle Sybase || + ( expression1 + expression2 ) ASCII ASCII CHR CHAR

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle SybaseB.2.2.1 Arithmetic Operators Oracle Sybase + + - - * * / /

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle SybaseB.2.2.2 Comparison Operators Oracle Sybase = = > > = >=, !=, ^= <>, != IS NOT NULL IS NOT NULL IS NULL IS NULL

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle SybaseB.2.2.3 Group Functions Oracle Sybase AVG AVG COUNT COUNT MAX MAX MIN MIN SUM SUM

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle SybaseB.2.2.5 Other Functions Oracle Sybase ABS ABS CEIL CEILING COS COS EXP EXP FLOOR FLOOR LN LOG LOG

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Data Type Conversion

Sybase Oracle CommentBIGINT NUMBER(19)   BINARY RAW - BIT NUMBER(3) - CHAR CHAR - DATE DATE   DATETIME DATE - DECIMAL NUMBER(p[,s]) - FLOAT FLOAT(53) - IMAGE LONG RAW - INT NUMBER(10) NUMBER range is -2,147,483,647 to 2,147,483,647 MONEY NUMBER(p[,s]) - NUMERIC NUMBER(p[,s]) - REAL FLOAT(24) - SMALLDATETIME DATE - SMALLINT NUMBER(5) NUMBER range is -32,767 to 32,767 SMALLMONEY NUMBER(p[,s]) - SYSNAME VARCHAR2   TEXT LONG

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 2 (11.2)

Configuring Oracle Database Gateway for Sybase

3.8.5 Multiple Sybase Databases Example: Accessing Sybase Data3.8.4 Multiple Sybase Databases Example: Configuring Oracle Database for Gateway Access Add two … the Oracle Net Listener. 3.8.5 Multiple Sybase Databases Example: Accessing Sybase Data Enter the … can verify the connection to the new Sybase databases, as in the following: SQL> SELECT * FROM ALL_USERS@SYBS2; SQL> SELECT

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 2 (11.2)

Configuring Oracle Database Gateway for Sybase

3.8.5 Multiple Sybase Databases Example: Accessing Sybase Datacreated, you can verify the connection to the new Sybase databases, as in the following: SQL> SELECT

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Sybase Gateway Features and Restrictions

2.7.7 Sybase Identifiers Length LimitBy default, the gateway will always quote identifiers. However, certain Sybase releases have a … characters. In order to support the maximum length limit in those Sybase releases, you need to … will follow the case sensitivity of the Sybase database being used.

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Data Dictionary

C.1.1 Sybase System TablesSybase data dictionary information is stored in the Sybase database as Sybase system tables. All … Sybase system tables have names prefixed with \"sys\". The Sybase system tables define the structure … of a database. When you change data definitions, Sybase reads and modifies the Sybase

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Sybase Gateway Features and Restrictions

2.8.6 Sybase NCHAR and NVARCHAR Data TypesThe gateway cannot select a column defined with a Sybase NCHAR or NVARCHAR data type.

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

B.2.2 Functions Supported by Sybaseequivalent Sybase functions: Arithmetic Operators Comparison Operators Group Functions String Functions Other Functions

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Data Dictionary

C.1.3 Direct Queries to Sybase TablesQueries issued directly to individual Sybase system tables are allowed but they return different … results because the Sybase system table column names differ from those of the data dictionary view … . Also, certain columns in an Sybase system table cannot be used in data dictionary processing.

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 2 (11.2)

Installing Oracle Database Gateway for Sybase

2 Installing Oracle Database Gateway for Sybaseprocedure for Oracle Database Gateway for Sybase. To install the gateway, follow these steps … Requirements for Oracle Database Gateway for Sybase\" Run the Oracle Universal Installer. See \"Step Through … depend on your platform. See Table 2-3 for a description of the installation procedure of Oracle Database Gateway for Sybase

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Sybase Gateway Features and Restrictions

2 Sybase Gateway Features and RestrictionsAfter the gateway is installed and configured, you can use the gateway to access Sybase data, pass … Sybase commands from applications to the Sybase database, perform distributed queries, and copy data … Session IDLE Timeout Database Compatibility Issues for Sybase Known Restrictions Known Problems

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Data Dictionary

View Name Sybase System Table NameALL_CATALOG sysusers + sysobjects ALL_COL_COMMENTS sysusers + sysobjects + syscolumns ALL_CONS_COLUMNS sp_pkeys + sp_fkeys ALL_CONSTRAINTS sysconstraints + sysusers + sysobjects ALL_IND_COLUMNS sysusers + sysindexes + syscolumns ALL_INDEXES sysusers + sysindexes + sysobjects ALL_OBJECTS sysusers + sysobjects + sysindexes ALL_TAB_COLUMNS sysusers + sysobjects + syscolumns ALL_TAB_COMMENTS sysusers

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Sybase Gateway Features and Restrictions

2.7 Database Compatibility Issues for SybaseSybase and Oracle databases function differently in some areas, causing compatibility problems. The … Naming Rules Data Types Queries Locking Sybase Identifiers Length Limit

Database Gateway for Sybase User's Guide, 11g Release 2 (11.2)

Case Studies

3.8 Case 3: Joining Sybase TablesCase 3 demonstrates the following: Joins between Sybase tables Subselects The query retrieves … information from three Sybase tables and relates the employees to their department name and salary grade