|
|
-
|
|
Purpose: It is a DML statement that is use for performing the Insert / Update or Delete statement to the target table based on the conditions supplied. It is introduce from Oracle 9i
Let us see an example to understand this one
First let us create a source table as under
CREATE TABLE tblStudent......
|
|
-
|
|
Select * From Players;
PLAYERID PLAYERFIRS PLAYERLAST BELONGSTO DOB FEEPERMATCH
---------- ---------- ------......
|
|
-
|
|
Purpose:Generates auto number field in tables.
Syntax
CREATE SEQUENCE sequence_name
MINVALUE value
MAXVALUE value
START WITH value
INCREMENT BY value
CACHE value;
We can create a sequence as under
SQL> CREATE SEQUENCE MySequence
2 MINVALUE 1
3 MAXVALUE 10......
|
|
-
|
|
Purpose: It is a dummy table in Oracle with one row and one Varchar2 column whose length is 1.
It's structure looks as under
SQL> Desc Dual;
Name Null? Type
----------------------------------------- -------- -------------
DUMMY ......
|
|
-
|
|
Purpose: It compares the field values that sounds like the supplied input word.
Syntax: SOUNDEX(Value to compare)
SQL> Select * From tblPlayers
2 Where Soundex(BELONGSTO) = Soundex('Lindia');
PLAYERID PLAYERFIRS PLAYERLAST BELONGSTO DOB FEEPERMATCH
---------- ---------- ----......
|
|
-
|
|
Purpose: It replaces a value for Not a number while dealing with Binary_Float or Binary_Double values.
Syntax: NANVL(Binary_Float/Binary_Double values, replace with)
Let us create a test environment
Create Table tblTestNANVL(Val1 Binary_Float, Val2 Binary_Double);
Insert Into tblTestNANVL Valu......
|
|
-
|
|
Select * From tblTestLNNVL;
EMPID SALARY COMMISSION
---------- ---------- ----------
1 100
2 200 45
3 25 ......
|
|
-
|
|
Purpose: Sorts characters by using string of bytes. It can be use both as a comparison and sorting parlance.
Syntax: NLSSORT(Sort_Column, NLS_PARAM)
Where,
Sort_Column => Column to sort
NLS_PARAM => It takes the form of NLS_SORT = sort where <i>sort</i> is binary or linguistic sort sequence.
......
|
|
-
|
|
Select * From tblEmployee;
EMPID EMPNAME SALARY BELONGSTO DEPTID
---------- -------------------------------------------------- ---------- ---------- ----------
1 Deepak Kumar Goyal 6000 Ind......
|
|
-
|
|
VB, VB.net and C# (4.0) developers knows what a named and optional parameter is. For those who are not familiar with the concept,it is like calling a function parameter by it's name instead of passing all of them.
Consider a small example( it is only a pseudo code)
function Add(int a = 0, int b......
|
|