Tag: databases

Writes the record to the reject port

Writes a descriptive error message to the error port

Discards the information if you do not connect flows to the reject or error ports

Processes all records

Abort on any error

Abort after 50 errors

Abort if more than 2 in 100

Abort if more than 1 in 100

data definition language (DDL) for all objects in a schema

DDL for all object grants on a table in the database

report of invalidated objects in a schema

report of statistics of an object in the database

The COMPRESSION HIGH option can be enabled only for CLOBs.

The COMPRESSION HIGH option can be enabled for all internal LOBs.

The DECRYPT option can be used to remove encryption only if the LOB column is empty.

The DECRYPT option can be used to remove encryption from LOB columns that are empty or contain data.

subquery results

results of a query having the SYSDATE function

results of a query having the GROUP BY clause

results of a query having the DATE data type in the WHERE clause

Use subprograms as pasrt of packages instead of stand-alone parameters

Use dynamic SQL’s constructed using concatenation of input values.

Use bind arguments

Usage of the NOT NULL constraint in PL/SQL code can degrade performance

REF CURSOR types cannot be defined inside a package

SYS_ REFCURSOR can be used to declare cursor variables in stored procedures and functions

A REF CURSOR return type can be declared using %TYPE or %ROWTYPE or a user-defined record.

Only a weak REF CURSOR type can be used as a formal parameter of a stored procedure or function.

It must be part of a package.

It must be a pipelined table function.

It must not be defined in an anonymous block.

It must have at least one OUT or IN OUT parameter.

1. Insert into

1. Create mining structure

1. Browse data

1. Select from

1. Browse mining model

1. Many dimensions, large dense datasets

1. Few dimensions, small dense datasets

1. Few dimensions, small sparse datasets

1. Many dimensions, small sparse datasets

1. Many dimensions, large sparse datasets