Oracle® Database XBRL Extension Developer's Guide 11g Release 2 (11.2) Part Number E17070-04 |
|
|
PDF · Mobi · ePub |
This manual describes XBRL Extension to Oracle XML DB.
This manual is intended for developers building XBRL applications.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc
.
Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info
or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs
if you are hearing impaired.
For more information, see the following Oracle resources:
Oracle XML DB Developer's Guide
Oracle XML Developer's Kit Programmer's Guide
To download free release notes, installation documentation, white papers, or other collateral material, visit Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at
http://www.oracle.com/technetwork/community/join/overview/index.html
If you have a username and password for OTN, then you can go directly to the documentation section of the OTN Web site at
http://www.oracle.com/technetwork/documentation/
For additional information, see:
http://www.w3.org/TR/xml/
– XML (language)
http://www.xml.com/pub/a/98/10/guide0.html
– XML introduction
http://www.w3.org/XML/Schema
– XML Schema
http://www.w3.org/2001/XMLSchema
– XML Schema
http://www.w3.org/TR/xmlschema-0/
– XML Schema: primer
http://www.w3.org/TR/xmlschema-1/
– XML Schema: structures
http://www.w3.org/TR/xmlschema-2/
– XML Schema: data types
http://www.oasis-open.org/cover/schemas.html
– XML Schema
http://www.xml.com/pub/a/2000/11/29/schemas/part1.html
– XML Schema
http://xml.coverpages.org/xmlMediaMIME.html
– media/MIME types
http://www.w3.org/TR/xptr/
– XPointer
http://www.w3.org/TR/xpath
– XPath 1.0
http://www.w3.org/TR/xpath20/
– XPath 2.0
http://www.zvon.org/xxl/XPathTutorial/General/examples.html
– XPath
XML In a Nutshell, by Elliotte Rusty Harold and W. Scott Means, O'Reilly, January 2001, http://www.oreilly.com/catalog/xmlnut/chapter/ch09.html
http://www.w3.org/TR/2002/NOTE-unicode-xml-20020218/
– Unicode in XML
http://www.w3.org/TR/xml-names/
– XML namespaces
http://www.w3.org/TR/xml-infoset/
– information sets
http://www.w3.org/DOM/
– Document Object Model (DOM)
http://www.w3.org/TR/xslt
– XSLT
http://www.w3.org/TR/xsl
– XSL
http://www.zvon.org/xxl/XSLTutorial/Books/Book1/index.html
– XSL
http://www.w3.org/2002/ws/Activity.html
– Web services
http://www.ietf.org/rfc/rfc959.txt
– RFC 959: FTP Protocol Specification
ISO/IEC 13249-2:2000, Information technology - Database languages - SQL Multimedia and Application Packages - Part 2: Full-Text, International Organization For Standardization, 2000
http://java.sun.com/xml/tutorial_intro.html
– XML and Java
Note:
Throughout this manual, "XML Schema" refers to the XML Schema 1.0 recommendation,http://www.w3.org/XML/Schema
.The following placeholders are used in this book, in particular in Chapter 5, "Installing XBRL Extension to Oracle XML DB" and Chapter 4, "Administering XBRL Extension to Oracle XML DB".
xb_sys_pass
– Password for database user XBRLSYS
, which is the user that creates and administers all XBRL repositories.
xb_sys_ts
– A tablespace for user XBRLSYS
. For Oracle Database 11g Release 2 (11.2.0.2) or later, the tablespace must use automatic segment space management.
xb_rep
– Name of an XBRL repository, which is also a database user name. (See "Creating an XBRL Repository".)
xb_rep_ts
– A tablespace for XBRL repository xb_rep
. For Oracle Database 11g Release 2 (11.2.0.2) or later, the tablespace must use automatic segment space management.
xb_rep_idx_ts
– Tablespace for the XMLIndex
index storage tables for XBRL repository xb_rep
.
xb_rep_tmp_ts
– A temporary tablespace for XBRL repository xb_rep
.
xb_protocols
– Whether or not to use Oracle XML DB Repository to provide protocol access. TRUE
means use it; FALSE
means do not use it. If XBRL repository xb_rep
is likely to contain more than 100,000 documents, then use FALSE
for best performance.
obiee_home
– Directory where Oracle Business Intelligence Suite Enterprise Edition (OBIEE) is installed.
oracle_client
– Name of your Oracle client for OBIEE. For example, OracleClient11g_home1.
oracle_client_dir
– Directory where your Oracle client for OBIEE is installed.
See Also:
Oracle Database Administrator's Guide for information about automatic segment space managementThe following text conventions are used in this document:
Convention | Meaning |
---|---|
boldface | Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary. |
italic | Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values. |
monospace |
Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter. |
The code examples in this book are for illustration only. In many cases, however, you can copy and paste parts of examples and run them in your environment.
To promote readability, especially of lengthy or complex XML data, output is sometimes shown pretty-printed (formatted) in code examples.
When examining the examples in this book, keep in mind the following:
SQL is case-insensitive, but names in SQL code are implicitly uppercase, unless you enclose them in double-quotes.
XML is case-sensitive. You must refer to SQL names in XML code using the correct case: uppercase SQL names must be written as uppercase.
For example, if you create a table named my_table
in SQL without using double-quotes, then you must refer to it in XML code as "MY_TABLE
".