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
Using PL/SQL to Create Server Pages → PL/SQL Server Pages (PSPs) enable you to develop Web pages with dynamic content. They are an … . Using special tags, you can embed PL/SQL scripts into HTML source code. The scripts are executed … content. Then, you can write the PL/SQL scripts that generate the content. When finished, you simply … Advanced Application
PL/SQL Server Pages → Also: Oracle Database PL/SQL Language Reference for detailed information on using collections and records PL/SQL Server Pages … , and trees. To support these techniques in database applications, PL/SQL provides the datatypes TABLE
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 … Arithmetic SQL Server IMAGE, TEXT and NTEXT Data Types String Functions Schema Names and
1.3.5 Oracle SQL Developer → definition language View and create reports View metadata and data of Microsoft Access, Microsoft SQL Server, and MySQL databases … Oracle SQL Developer is a graphical version of SQL*Plus that gives database developers a convenient … way to perform basic tasks. Following are the functions you can perform with Oracle
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 1 New Features in the … SQL Language Reference 1 Introduction to Oracle SQL History of SQL SQL Standards How SQL Works … Conventions Tools Support 2 Basic Elements of Oracle SQL Datatypes
Using SQL Server as a Source → Scenario Your company has data that is stored in SQL Server and you would like to import this into … from any Oracle data source. Case Study To connect to SQL Server and import metadata, refer to the … \" \"Adding the SQL Server as a Source in Warehouse Builder\" What's Next If you encounter
Contents → Using PL/SQL to Create Web Applications Using PL/SQL to Create Server Pages 3 PL/SQL Data Types … Documentation Accessibility Related Documents Conventions Syntax Descriptions What's New in PL/SQL … ? New PL/SQL Features for 11 g Release 1 (11.1) 1 Overview of PL/SQL
Contents → : Source-Specific Information 2.5.1 Before Migrating From Microsoft SQL Server 2.5.2 Before Migrating … Offline 220.127.116.11 Creating Data Files From Microsoft SQL Server or Sybase Adaptive Server 18.104.22.168 … Accessibility Related Documents Conventions Third-Party License Information 1 SQL
Adding the SQL Server as a Source in Warehouse Builder → SQL server into this module. To add an ODBC source module in Warehouse Builder: Within a project in
1.2.4 Oracle SQL Developer → Definition Language (DDL) View and create reports View metadata and data of Microsoft Access, Microsoft SQL Server, and MySQL databases … Oracle SQL Developer is a graphical version of SQL*Plus that gives database developers a convenient … way to perform basic tasks. Following are the functions you can perform with Oracle
Overview of PL/SQL → PL/SQL is the Oracle procedural language extension to SQL. It provides a server-side, stored … leveraged development model on both the client and the server side. In addition, PL/SQL stored … Functions PL/SQL Packages PL/SQL Collections and Records PL/SQL
SQL Server System Tables → SQL Server data dictionary information is stored in the SQL Server database as SQL Server system … tables. All SQL Server system tables have names prefixed with \" sys \". The SQL Server system tables … define the structure
9.8.5 Multiple SQL Server Databases Example: Accessing SQL Server Data → created you can verify the connection to the new SQL Server databases, as in the following: SQL … Enter the following to create a database link for the dg4msql2 gateway: SQL> CREATE PUBLIC DATABASE … following to create a database link for the dg4msql3 gateway: SQL> CREATE PUBLIC DATABASE LINK MSQL3
Multiple SQL Server Databases Example: Accessing SQL Server Data → created, you can verify the connection to the new SQL Server databases, as in the following: SQL … Enter the following to create a database link for the dg4msql2 gateway: SQL> CREATE PUBLIC DATABASE … following to create a database link for the dg4msql3 gateway: SQL> CREATE PUBLIC DATABASE LINK MSQL3
Debugging PL/SQL Server Pages → As you begin experimenting with PL/SQL Server Pages, and as you adapt your first simple pages into … get all the PL/SQL syntax and PSP directive syntax right. If you make a mistake here, the file does … . You might need to enclose a single-quoted value (needed by PL/SQL) inside double quotes (needed by … PSP).
Developing PL/SQL Server Pages → To develop a PL/SQL server page, you can start with an existing web page or with an existing stored … perform database operations and display the results. The file for a PL/SQL server page must have the … : In the simplest case, it is an HTML file. Compiling it as a PL/SQL server page
Functions Supported by SQL Server → equivalent SQL Server functions: Arithmetic Operators Comparison Operators Pattern Matching Group Functions … String Functions Other Functions Arithmetic Operators Oracle SQL Server + + - - * * / / Comparison … Operators Oracle SQL Server = = > > = >=, !=, ^= <> IS NOT NULL IS NOT NULL
Summary of Oracle Supplied PL/SQL Packages and Types → Table 1-1 lists the supplied PL/SQL server packages. These packages run as the invoking user … -side debuggers and provides a way to debug server-side PL/SQL program units DBMS_DEFER Provides the … Summary of Oracle Supplied PL/SQL Packages Package Name Description APEX_CUSTOM_AUTH Provides an
Contents → Conventions What's New in PL/SQL Packages and Types Reference? Oracle Database 11g Release 1 (11.1) 1 … Introduction to Oracle Supplied PL/SQL Packages & Types Package Overview Package Components Using … PL/SQL Packages and Types 2 APEX_CUSTOM_AUTH Documentation of APEX_CUSTOM_AUTH 3 APEX_APPLICATION … Data Structures SQLSET_ROW