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 → 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 → 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
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
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
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
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
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
SQL Functions → The queries in Example 6-4 invoke a SQL function ( COUNT ). Example 6-4 Invoking the SQL COUNT … Function in PL/SQL SQL> DECLARE 2 job_count NUMBER; 3 emp_count NUMBER; 4 BEGIN 5 SELECT COUNT(DISTINCT … ; 12 END; 13 / PL/SQL procedure successfully completed. SQL>
SQL Pseudocolumns → PL/SQL recognizes the SQL pseudocolumns CURRVAL, LEVEL, NEXTVAL, ROWID, and ROWNUM. However, there … SQL pseudocolumns, see Oracle Database SQL Language Reference. Topics: CURRVAL and NEXTVAL LEVEL … already exist. To create a sequence, use the SQL statement CREATE SEQUENCE.) Example 6-5 Using
SQL Operators → PL/SQL lets you use all the SQL comparison, set, and row operators in SQL statements. This section … briefly describes some of these operators. For more information, see Oracle Database SQL Language
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
Avoiding SQL Injection in PL/SQL → SQL injection is a technique for maliciously exploiting applications that use client-supplied data … in SQL statements, thereby gaining unauthorized access to a database in order to view or manipulate … restricted data. This section describes SQL injection vulnerabilities in PL/SQL and explains how to … statements
Using SQL Functions in PL/SQL → You can use all SQL functions except the following in PL/SQL expressions: Aggregate functions (such … WIDTH_BUCKET PL/SQL supports an overload of BITAND for which the arguments and result are BINARY_INTEGER … . When used in a PL/SQL expression,the RAWTOHEX function accepts an argument of data type RAW and … Database
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
Guarding Against SQL Injection → If you use dynamic SQL in your PL/SQL applications, you must check the input text to ensure that it … Against SQL Injection Using Validation Checks to Guard Against SQL Injection Using Explicit Format … Models to Guard Against SQL Injection Using Bind Arguments to Guard Against SQL Injection
6 Using Static SQL → Static SQL is SQL that belongs to the PL/SQL language. This chapter describes static SQL and … explains how to use it in PL/SQL programs. Topics: Description of Static SQL Managing Cursors in PL/SQL … Querying Data with PL/SQL Using Subqueries Using
PL/SQL Data Abstraction → Assignment Operator SQL> DECLARE -- You can assign values here 2 wages NUMBER; 3 hours_worked NUMBER … comm_tab(5):= 20000 * 0.15; 25 END; 26 / PL/SQL procedure successfully completed. SQL> In Example 1-4 … Assign Values to Variables SQL> DECLARE 2 bonus NUMBER(8,2); 3 emp_id NUMBER(6):= 100; 4 BEGIN 5 … SELECT