
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
8 Managing Schema Objects
Loading Data Into Tables → You can use Enterprise Manager to load data into tables in batch. Batch loading is useful when you … also export data into files. For loading data with Enterprise Manager, one method is to use control … example loads data into the PURCHASE_ORDERS table we created with MYUSER in "Managing Tables". For … and load.dat. The control
SELECT INTO Statement
SELECT INTO Statement → The SELECT INTO statement retrieves data from one or more database tables, and assigns the selected … Database SQL Reference. In its default usage ( SELECT... INTO ), this statement retrieves one or more … columns from a single row. In its bulk usage ( SELECT... BULK COLLECT INTO ), this statement … declared collection into
5 How Oracle Database Processes SQL Statements
Grouping Operations into Transactions → In general, only application designers using the programming interfaces to Oracle Database are concerned with which types of actions should be grouped together as one transaction. Transactions must be defined properly so that work is accomplished in logical units and data is kept consistent. A transaction should consist of all of the necessary parts for one logical unit of work, no more and no less.
11 Conventional and Direct Path Loads
Loading into Synonyms → You can load data into a synonym for a table during a direct path load, but the synonym must point
8 Host Arrays
8.4 Selecting into Arrays → following example, you select directly into three host arrays. Knowing the SELECT will return no … ]; float salary[50]; EXEC SQL SELECT ENAME, EMPNO, SAL INTO:emp_name,:emp_number,:salary FROM EMP … either declare a larger array or declare a cursor for use with the FETCH statement. If a SELECT INTO
20 Original Export and Import
Importing into Existing Tables → This section describes factors to take into account when you import data into existing tables.
Using Host Arrays
Selecting into Arrays → use of host arrays in data manipulation statements. Selecting into Arrays You can use host arrays as … select directly into three host arrays. Knowing the select will return no more than 50 rows, you dimension the arrays with 50 elements:
5 Binding and Defining in OCI
Binding RETURNING...INTO variables → may not be known at runtime. As a result, the variables corresponding to the RETURNING... INTO … useful when working with LOBs. Normally, an application must insert an empty LOB locator into the … can combine these two steps into a single statement: INSERT INTO some_table VALUES (:in_locator … ) RETURNING lob_column
7 Host Tables
7.4 Selecting into Tables → following example, you select directly into three host tables. The table was defined with 50 rows … TIMES PIC S9(6)V99 DISPLAY SIGN LEADING SEPARATE.... EXEC SQL SELECT ENAME, EMPNO, SAL INTO:EMP … FETCH statement. If a SELECT INTO statement returns more rows than the size of the table you
A Loading Metadata into Ultra Search
Loading Documents and Relevance Scores → To use the loader tool to add documents and their relevancy boosting scores into Ultra Search, the parameter -type value should be doc.
A Loading Metadata into Ultra Search
A Loading Metadata into Ultra Search → Ultra Search provides a co mmand-line tool to load metadata into an Ultra Search database. If you
A Loading Metadata into Ultra Search
The LOV XML File → The LOV entries and display names are defined in a XML file. You can define one or more search attribute LOVs in the XML file. Both default LOV and data source-specific LOVs are put in the XML file. The definition of the XML file is stored in the XML schema. See Also: "XML Schema for LOVs and LOV Display Names" Example of the LOV XML File In the previous example,
A Loading Metadata into Ultra Search
Loading Search Attribute LOVs and LOV Display Names → To use loader tool to add LOV entries and display names to Ultra Search, the parameter -type value should be lov.
A Loading Metadata into Ultra Search
The Input XML File → The document URL and relevance boosting scores are defined in an XML file. You can define one or more documents to be boosted. Each document can have one or more boosting score pairs. The definition of the XML file is stored in the XML schema. See Also: "XML Schema for Document Relevance Boosting" Example of the Document Relevance Boosting XML File database internet software Sever Technology
A Loading Metadata into Ultra Search
XML Schema for Document Relevance Boosting → The XML schema for document relevance boosting terms and scores is described as follows:
A Loading Metadata into Ultra Search
XML Schema for LOVs and LOV Display Names → The XML schema for LOV entries and display names is described as follows:
A Loading Metadata into Ultra Search
Launching the Loading Tool → The loader program binary file is located in the following directory: %ULTRASEARCH_HOME%/bin/MetaLoader. class. Your computer should have Java 1.2 compliant Java Runtime or higher. The following Java libraries should be included in the system Java CLASSPATH: Oracle JDBC Thin Driver version 1.2. The filename is classes12. zip. Oracle XML parser for Java version 2. The filename is xmlparserv2. jar.
8 SQL*Loader Control File Reference
Loading Logical Records into Tables → you want to load into them Default data delimiters for those records How to handle short records with missing data
12 Migrating Databases To and From ASM with Recovery Manager
Migrating a Database into ASM → database into ASM. This migration is performed using Recovery Manager (RMAN) even if you are not … storage directly into ASM, or you can back the database up to tape and then from tape backups move it … into ASM. Moving the database to tape backup and then into ASM is recommended if your database is so … simultaneously.
20 Original Export and Import
Importing Objects into Other Schemas → To import objects into another user's schema, you must have the IMP_FULL_DATABASE role enabled.