You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for EXTRACT


1 to 20 of 301 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.xdb.dom

extractpublic XMLType extract(java.lang.String xpath, java.lang.String nsmap) throws java.sql.SQLException … Function to extract the given set of nodes from the XMLType. This set of nodes is specified by the

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 42 of 177

EXTRACT (datetime)Syntax extract_datetime::= Text description of extract_datetime Purpose EXTRACT extracts and … extract a TIMEZONE_REGION or TIMEZONE_ABBR (abbreviation), the value returned is a string containing … the appropriate time zone name or abbreviation. When you extract any of the other values, the value … of the datetime_value_expr or

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 43 of 177

EXTRACT (XML)Syntax extract_xml::= Text description of extract_xml Purpose EXTRACT (XML) is similar to the … the warehouse_spec column in the sample table oe.warehouses: SELECT warehouse_name, EXTRACT

Reference Guide for IBM DB2/400 V4R5 Migrations, 9i Release 2 (9.2.0.2)

Migration Process

Generating Extract ScriptsTo create the extract_nn data extraction scripts and the SQL*Loader control files for all tables: From the Oracle Model, select the Tables folder. Choose Object -> Generate SQL*Loader Scripts. Note: You can also generate the scripts for a specific table by selecting that table from the Oracle Model, then choosing Object -> Generate SQL*Loader Scripts. When you are sure you want to generate the SQL*Loader

Administrator's Guide, 9i Release 2 (9.2.0.2)

Using LogMiner to Analyze Redo Logs

Extract a DictionaryTo use LogMiner you must supply it with a dictionary by doing one of the following: Extract … database dictionary information to a flat file. See Extracting the Dictionary to a Flat File. Extract

Reference Guide for IBM DB2/400 V4R5 Migrations, 9i Release 2 (9.2.0.2)

Migration Process

Using the Extract Scriptstable in the extract.omwb file is as follows: EXTRACT( "SCHEMA_NAME", "TABLE_NAME", "/TABLE_NAME.DAT … want to extract. The Migration Workbench automatically completes this parameter. "TABLE_NAME" The … table name from which you want to extract the data. The Migration Workbench automatically completes this … parameter. "" The

Reference Guide for MySQL 3.22, 3.23 Migrations, 9i Release 2 (9.2.0.2)

Migration Process

Generating mysqldump Data Extract ScriptsTo create the mysqldump data extraction script and the SQL*Loader control files for all tables: From the Oracle Model, click the Tables folder in the Oracle Model. Choose Object -> Generate SQL*Loader Scripts. Note: You can also generate the scripts for a specific table by highlighting that table from the Oracle Model, then choosing Object -> Generate SQL*Loader Scripts. If you are sure you want to

interMedia User's Guide and Reference, 9i Release 2 (9.2.0.2)

Exceptions and Error Messages

IMG-00801, "cannot extract height and width"Cause: Height and width are not set in the image object. Action: Set the properties of the image object by calling setProperties and then generate the signature.

Administrator's Guide, 9i Release 2 (9.2.0.2)

Configuring Kerberos Authentication

Task 3: Extract a Service Table from KerberosExtract the service table from Kerberos and copy it to the Oracle database server/Kerberos client … system. For example, use the following steps to extract a service table for dbserver.someco.com … : Enter the following to extract the service table: kadmin.local: ktadd -k /tmp/keytab oracle

XML Developer's Kits Guide - XDK, 9i Release 2 (9.2.0.2)

XML Parser for PL/SQL

How Do I Extract Elements from the XML File?Answer: If you're using DOM, the you can use the NamedNodeMap methods to get the elements.

Administrator's Guide, 9i Release 2 (9.2.0.2)

Configuring CyberSafe Authentication

Task 5: Extract the Service Table from CyberSafeExtract a service table from CyberSafe and copy it to both the Oracle database server and CyberSafe … TrustBroker client systems. For example, to extract a service table for dbserver.someco.com

XML Developer's Kits Guide - XDK, 9i Release 2 (9.2.0.2)

XML Parser for PL/SQL

How Do I Extract Part of a CLOB?… We want the ability to extract only part of the CLOB (XML document), modify it, and replace it back

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Using Oracle XML DB

Using extract()The extract() syntax is shown in Figure 3-3. Figure 3-3 extract() Syntax Text description of the … illustration extract_xml.gif extract() is used when the XPath expression will result in a collection … of nodes being returned. The nodes are returned as an instance of XMLType. The results of extract … () can be

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Using XMLType

extract () FunctionThe extract() f unction is similar to the e xistsNode () function. It applies a VARCHAR2 XPath … . The syntax is described in Figure 4-3 and as follows: extract(XMLType_instance IN XMLType … , XPath_string IN VARCHAR2, namespace_string In varchar2:= ) RETURN XMLType; Figure 4-3 extract() Syntax … Text description of the illustration

XML Database Developer's Guide - Oracle XML DB, 9i Release 2 (9.2.0.2)

Structured Mapping of XMLType

Rewrite for extract()extract() retrieves the results of XPath as XML. The rewrite for extract() is similar to that of … extractValue() for those Xpath expressions involving text nodes. Extract Mapping with Document Order … Maintained Table 5-15 shows the mapping of various XPath in the case of extract() when document order … Mapping

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

EXISTSNODEEXTRACT (XML)

Error Messages, 9i Release 2 (9.2.0.2)

ORA-29250 to ORA-32799

ORA-30076 invalid extract field for extract sourceCause: The extract source does not contain the specified extract field. Action: Specify a valid extract field for the extract source.

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

CURRENT_TIMESTAMPDBTIMEZONE EXTRACT (datetime)

Error Messages, 9i Release 2 (9.2.0.2)

interMedia Image Messages (IMG)

IMG-00801 cannot extract height and widthCause: Height and width are not set in the image object. Action: Set the properties of the image object by calling setProperties and then generate signature.

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Extraction in Data Warehouses

Data Warehousing Extraction ExamplesYou can extract data in two ways: Extraction Using Data Files Extraction Via Distributed Operations