Oracle Sql, Pl/Sql Developers Posts - TopicsExpress

TO_CHAR ---------------- The TO_CHAR function converts a DATE,
TO_CHAR ---------------- The TO_CHAR function converts a DATE, TIMESTAMP or numeric input value to a VARCHAR2. If you are using TimesTen type mode, ...

Oracle/PLSQL: Roles:- Part -
Oracle/PLSQL: Roles:- Part - 1 ---------------------------------------------- A role is a set or group of privileges that can be granted to users ...

Understanding Rules-of-Thumb:- Part -
Understanding Rules-of-Thumb:- Part - 2 ----------------------------------------------- Use NOT EXISTS instead of NOT IN:- --------------------------...

PL/SQL - Packages:- Part - 11.2 Understanding The Package
PL/SQL - Packages:- Part - 11.2 Understanding The Package Spec:- The spec lists the package resources available to applications. All the informatio...

PL/SQL - Packages:- Part - 15 Some Examples of Package
PL/SQL - Packages:- Part - 15 Some Examples of Package Features:- Consider the package below named emp_actions. The package spec declares the follo...

Here is next part..... PL/SQL Tables and User-Defined
Here is next part..... PL/SQL Tables and User-Defined Records:- ------------------------------------------------- Part- 10 User-Defined Records:- ---...

PL/SQL Tables and User-Defined Records:- Part- 2 Defining TABLE
PL/SQL Tables and User-Defined Records:- Part- 2 Defining TABLE Types:- To create PL/SQL tables, you take two steps. First, you define a TABLE type,...

SQL Tuning Overview:- Part -
SQL Tuning Overview:- Part - 8 ------------------------------------------- Developing Efficient SQL Statements:- ------------------------------------...

SQL - INDEX Constraint:- ----------------------------------- The
SQL - INDEX Constraint:- ----------------------------------- The INDEX is used to create and retrieve data from the database very quickly. Index can ...