|
|
-
|
|
@IfThen
Number1 is greater than Number2
PL/SQL procedure successfully completed.
2. IF..THEN........
|
|
-
|
|
%TYPE
Say we have a table as under
Create Table tblEmployee
(
EmpName VARCHAR2(50)
,Salary INT
);
It is a simple table with two columns viz. EmpName of type VARCHAR2 and Salary of Type INT
Consider we have variables for holding the datatype of a table's column.
DECLARE
var_EmpNa......
|
|
-
|
|
PL/SQL
PL/SQL stands for Procedural Language Structured Query Language. Inorder to enhance the SQL capabilities, it came into existence in 1990. It is based on ADA procedural language
The PL/SQL engine is use to process the PL/SQL statement.
Benefits of PL/SQL
Supports for Object-Oriented ......
|
|
-
|
|
Let Us Learn Oracle - Part 52 of N [ Model clause of Oracle 10g ]
Introduced in Oracle 10g, the Model clause builds a myraid number of dimensions with one or more matrices. The minimum requirement is to have atleast one dimension, one measure and one partition though the last is optional
Syntax:
......
|
|
-
|
|
Let Us Learn Oracle - Part 51 of N [ RecycleBin,Flashback and Purge Command of Oracle 10g ]
This feature was introduce in Oracle 10g. Whenever we drop a table object in Oracle , though it gets deleted from the user table but it remains in the RecycleBin view.It is similar to the Windows Recycle......
|
|
-
|
|
Let Us Learn Oracle - Part 50 of N [ Sys_Context Function of Oracle 10g ]
Purpose: This function retrives information about Oracle Environment.
Syntax: Sys_Context(Namespace,parameter [,length])
Where,
Namespace => Oracle namespace to be use.If we use 'UserEnv' as the namespace, we can get info......
|
|
-
|
|
Let Us Learn Oracle - Part 49 of N [ UserEnv Function of Oracle 10g ]
Purpose: This function retrives information about current Oracle Session.
Syntax: UserEnv(Parameter)
Where,
Parameter = > It is value return from the current Oracle Session
Examp;le 1: Get the current langauge and it's ISO a......
|
|
-
|
|
Let Us Learn Oracle - Part 48 of N [ Bin_To_Num Function of Oracle 10g ]
Purpose: This function converts a bit vector to it's corresponding numeric value
Syntax: Bin_To_Num(value1,value2,value3...,valueN)
Where,
value1,...valueN => are the bit vectors which can have either 0 or 1.
<pre class="......
|
|
-
|
|
Let Us Learn Oracle - Part 47 of N [ Remainder Function of Oracle 10g ]
Syntax: Remainder(x,y)
Purpose: It returns the remainder of x divided by y. It is similar to Mode function but the difference is that it uses Round function while Mod uses Floor function in it's formula while computing.
......
|
|
-
|
|
Let Us Learn Oracle - Part 46 of N [ UID and USER function of Oracle ]
Uid
Purpose: It is the user id and helps to find the id of the user who is currently logged in. It returns an integer value
SQL> Select Uid From Dual;
UID
----------
54
</pre>
User
Purpose: It helps......
|
|