Results for EXTRACT


1 to 20 of 324 results. Prev  Next
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, 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

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

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

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

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 … (file) that you 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 … extract from the table. You

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 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 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 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 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 … XPath

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





Was this page helpful?

Integrated Cloud Applications & Platform Services