How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
Contents → Database 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 126.96.36.199 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
Before Migrating From Microsoft SQL Server or Sybase Adaptive Server → To 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
Oracle Sybase → B.2.2.4 String Functions Oracle Sybase || + ( expression1 + expression2 ) ASCII ASCII CHR CHAR
Oracle Sybase → B.2.2.1 Arithmetic Operators Oracle Sybase + + - - * * / /
Oracle Sybase → B.2.2.2 Comparison Operators Oracle Sybase = = > > = >=, !=, ^= <>, != IS NOT NULL IS NOT NULL IS NULL IS NULL
Oracle Sybase → B.2.2.3 Group Functions Oracle Sybase AVG AVG COUNT COUNT MAX MAX MIN MIN SUM SUM
Oracle Sybase → B.2.2.5 Other Functions Oracle Sybase ABS ABS CEIL CEILING COS COS EXP EXP FLOOR FLOOR LN LOG LOG
Sybase Oracle Comment → BIGINT 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
3.8.5 Multiple Sybase Databases Example: Accessing Sybase Data → 3.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
3.8.5 Multiple Sybase Databases Example: Accessing Sybase Data → created, you can verify the connection to the new Sybase databases, as in the following: SQL> SELECT
2.7.7 Sybase Identifiers Length Limit → By 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.
C.1.1 Sybase System Tables → Sybase 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
2.8.6 Sybase NCHAR and NVARCHAR Data Types → The gateway cannot select a column defined with a Sybase NCHAR or NVARCHAR data type.
B.2.2 Functions Supported by Sybase → equivalent Sybase functions: Arithmetic Operators Comparison Operators Group Functions String Functions Other Functions
C.1.3 Direct Queries to Sybase Tables → Queries 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.
2 Installing Oracle Database Gateway for Sybase → procedure 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
2 Sybase Gateway Features and Restrictions → After 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
View Name Sybase System Table Name → ALL_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
2.7 Database Compatibility Issues for Sybase → Sybase and Oracle databases function differently in some areas, causing compatibility problems. The … Naming Rules Data Types Queries Locking Sybase Identifiers Length Limit
3.8 Case 3: Joining Sybase Tables → Case 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