0
POPSTypes of SQL Statements The tables in the following sections provide a functional summary of SQL statements and are divided into these categories: * Data Definition Language (DDL) Statements * Data Manipulation Language (DML) Statements * Transaction Control Statements * Session Control Statements * System Control Statements
0
POPSOracle Adds Database In-Memory Caching Option Oracle releases a new version of its TimesTen In-Memory database as well as a new database caching option for 11g customers. Both offerings are aimed at the middle tier. Oracle has announced the release of Oracle TimesTen In-Memory Database 11g as well as a new database caching option in a nod toward the middle tier.
0
POPSOracle DBA - Comments Comments within sql statements do not affect the statement execution, but they may make your application easier for you to read and maintain. You may want to include a comment in a statement that describes the statement's purpose within your application.
0
POPSOracle DBA - Pseudocolumns A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you cannot insert, update, or delete their values
0
POPSOracle DBA - Nulls If a column in a row has no value, then the column is said to be null, or to contain a null. Nulls can appear in columns of any datatype that are not restricted by NOT NULL or PRIMARY KEY integrity constraints. Use a null when the actual value is not known or when a value would not be meaningful.
0
POPSOracle DBA - Migration Tools Migration tools are used to transfer the loads of data from one database to another or from one version of the database to other version of database.
0
POPSLog Apply Services oracle data guard, Log Apply Services,oracle DBA,learn sql,learn dba,learn sqlplus,learn database,oracle9i tutorials
0
POPSRMAN (Recovery Manager) Recovery Manager (RMAN) is an Oracle provided utility for backing-up, restoring and recovering Oracle Databases. RMAN ships with the Oracle database and doesn't require a separate installation.