|
|
-
|
|
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......
|
|
-
|
|
Oracle Associative Arrays Collection Type
We can make composite datatypes in oracle that will hold multiple values of the same type. These composite types are known as collections.There are basically 3 types of collections in oracle
VArray
Nested Table
Associative Arrays
This article wil......
|
|
-
|
|
Oracle Nested Table Collection Type
We can make composite datatypes in oracle that will hold multiple values of the same type. These composite types are known as collections.There are basically 3 types of collections in oracle
VArray
Nested Table
Associative Arrays
This article will focu......
|
|
-
|
|
Oracle VARRAY Collection Type
We can make composite datatypes in oracle that will hold multiple values of the same type. These composite types are known as collections.There are basically 3 types of collections in oracle
VArray
Nested Table
Associative Arrays
This article will focus on V......
|
|
-
|
|
EndValue;
END LOOp;
DBMS_OUTPUT.PUT_LINE('Sum of even Numb......
|
|
-
|
|
@IfThen
Number1 is greater than Number2
PL/SQL procedure successfully completed.
2. IF..THEN........
|
|
-
|
|
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.
......
|
|