1.
ORACLE-BASE - Efficient SQL Statements
The EXISTS function searches for the presence of a single row meeting the ... In the second case, Oracle jumps straight to the first index entry with an ...
2.
ORACLE-BASE - Partitioning an Existing Table using EXCHANGE PARTITION
This article presents a simple method for partitioning an existing table using the EXCHANGE PARTITION syntax. The contents of the article should not be used ...
3.
VMware Server 2.0… | The ORACLE-BASE Blog
I have a shiny new 64 bit HP desktop with Vista professional (quad core -6GB ram). According to VMware website, Ver 2.0 needs to be installed on a Server OS ...
4.
ORACLE-BASE - Explain Plan Usage
The explain plan process stores data in the PLAN_TABLE . .... The EXPLAIN PLAN method doesn't require the query to be run, greatly reducing the time it ...
5.
ORACLE-BASE - Oracle9i XMLSEQUENCE
getStringVal() AS hiredate, extract(value(d), '//SAL/text()').getNumberVal() AS sal FROM xml_tab x, table(xmlsequence(extract(value(x), '/ROWSET/EMP'))) d; ...
6.
ORACLE-BASE - Oracle9i Export And Import Enhancements
If the export character set differs from that specified by the import users NLS_LANG parameter another conversion is performed. This conversion cannot be ...
7.
ORACLE-BASE - Oracle Database 10g (10.1.0.2) Installation On ...
In this article I'll describe the installation of Oracle Database 10g ... bin/bash export DISABLE_HUGETLBFS=1 exec $ORACLE_HOME/bin/oracle.bin $@ EOF chmod ...
8.
ORACLE-BASE - Oracle Database OCA & OCP Certification (11g, 10g, 9i)
OCP Oracle Database 11g: New Features for Administrators Exam Guide Sam Alapati, OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0-051) ...
9.
ORACLE-BASE - Oracle8i Locally Managed Tablespaces
In Oracle 8i the EXTENT MANAGEMENT clause was introduced into the CREATE TABLESPACE statement allowing extent management to be LOCAL or DICTIONARY . ...
10.
ORACLE-BASE - External Tables Containing LOB Data
This articles shows how external tables are used to read CLOB and BLOB ... The documents contain the CLOB and BLOB data to be read by the external table. ...
