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
Support for Developing Server Pages → PL/SQL Server Pages (PSPs) let you develop web pages with dynamic content. PSPs are an alternative … tags let you embed PL/SQL scripts into HTML source text. The scripts run when Web clients, such as … PL/SQL scripts that generate the content. When finished, you simply load the resulting PSP files
Contents → Developing Server Pages Main Features of PL/SQL Error Handling Blocks Variables and Constants Subprograms … Documentation Accessibility Related Documents Conventions Syntax Descriptions What's New in PL/SQL? PL … /SQL Feature for Oracle Database 11 g Release 2 (126.96.36.199) PL/SQL Features for Oracle Database
Contents → Before You Start Migrating: Source-Specific Information Before Migrating From Microsoft SQL Server … Microsoft SQL Server or Sybase Adaptive Server Creating Data Files From Microsoft Access Creating Data … Accessibility Related Documents Conventions Third-Party License Information 1 SQL
Contents → Gateways 2 SQL Server Gateway Features and Restriction Using the Pass-Through Feature Executing … Program Fetching from Result Sets in Sequential Mode Database Compatibility Issues for SQL Server … Login Date Arithmetic SQL Server IMAGE, TEXT and NTEXT Data Types String Functions Schema
Connecting to SQL Server Database → You can connect to a SQL Server database using a JDBC connection. JDBC Connection Driver for SQL … Server To connect using JDBC, you must place the jar file sqljdbc.jar into OWB_HOME /owb/lib/ext on
Creating a SQL Server Module → Before you can import metadata from a SQL Server database, you must create a SQL Server module to … store the metadata. To create a SQL Server Module: Right-click SQL Server under the Databases node … in the Projects Navigator and select New SQL
Creating a SQL Server Module → The SQL Server node is available under the Databases node in the Projects Navigator. To create a … SQL Server module: Right-click SQL Server and select New SQL Server Module. The Create Module Wizard … module status. Select SQL Server
Tools Support → , Microsoft SQL Server, and Microsoft Access, view metadata and data in these databases, and migrate … Oracle provides a number of utilities to facilitate your SQL development process: Oracle SQL … and debug PL/SQL code, run SQL statements and scripts, manipulate and export data, and
Contents → Conventions What's New in the SQL Language Reference? Oracle Database 11 g Release 2 (188.8.131.52) New … Features in the SQL Language Reference Oracle Database 11 g Release 2 (184.108.40.206) New Features in the SQL … Language Reference Oracle Database 11 g Release 2 (220.127.116.11) New Features in the SQL Language … Reference
Connecting to SQL Server Database Through ODBC → Scenario Your company has data that is stored in SQL Server and you would like to import this into … the ways to connect to an SQL Server database from Oracle Warehouse Builder is to use an ODBC gateway … . Once connected, you can import metadata and load data. Case Study To connect to SQL Server
Importing Metadata into a SQL Server Module → To import metadata into a module: Right-click the SQL Server module and select Import, then … including PL/SQL mappings and code template mappings, see the Oracle Warehouse Builder Data Modeling
Creating IBM DB2 and SQL Server Functions → , you can use Oracle Warehouse Builder to load data into SQL Server and DB2 data objects also. In … functions for a DB2 or SQL Server database, you can use these functions in mappings and process flows with … publish these functions as Web Services. Defining IBM DB2 and SQL Server Functions
MS SQL Server Data Types Mapping → Table 11-7 lists the mapping of MS SQL Server data types to generic data types. Table 11-7 MS SQL … Server Data Types to Generic Data Types MS SQL Server Data Type Generic Data Type CHAR CHAR VARCHAR … the mapping of generic data types to MS SQL Server
Connecting to a SQL Server Database → To create a gateway connection to a SQL Server database, ensure that Oracle Database Gateway for SQL Server is installed.
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
SQL Injection → SQL injection maliciously exploits applications that use client-supplied data in SQL statements … describes SQL injection vulnerabilities in PL/SQL and explains how to guard against them. To try the … Setup for SQL Injection Examples DROP TABLE secret_records; CREATE TABLE secret_records ( user_name
7 PL/SQL Dynamic SQL → Dynamic SQL is a programming methodology for generating and running SQL statements at run time. It … compilation time the full text of a SQL statement or the number or data types of its input and output … variables. PL/SQL provides two ways to write dynamic SQL: Native dynamic SQL, a
6 PL/SQL Static SQL → Static SQL is a PL/SQL feature that allows SQL syntax directly in a PL/SQL statement. This chapter … describes static SQL and explains how to use it. Topics Description of Static SQL Cursors Query … Transactions See Also: \"Resolution of Names in Static SQL Statements\"
Connecting to a PeopleSoft Application Implemented on SQL Server → To import metadata from a PeopleSoft application that is implemented on a SQL Server database … , first define a CMI definition for PeopleSoft on SQL Server. To leverage on a CMI mechanism, you must … PeopleSoft on SQL Server as listed in Example 8-2. Ensure that you provide the correct
Rules for Naming Objects in Microsoft SQL Server → characters within Oracle Warehouse Builder. Rules for Naming Objects in Microsoft SQL Server When … you import data objects from SQL Server, the case used in object names is preserved. However, for all … . Following are the rules for naming objects in Microsoft SQL Server: Object names