FUNCTIONS CONTINUES..
GENERAL FUNCTIONS::
The General functions are mainly used for Process the "NULL" Values.
There are following four types of General functions are there::
1.NVL()
--It's having two arguments
2.NVL2()
--It's having three arguments
3.NULLIF()
--It's...
Saturday, 30 April 2016
Thursday, 28 April 2016
Func Part..2
FUNCTION CONTINUES
NUMBER FUNCTIONS::
1.ROUND()
2.TRUNC()
3.MOD()
4.POWER()
1.ROUND()::
The ROUND() Function mainly used for Round of the Decimal Values Or Round of the Values based on the Position Which is
Passed in the argument.
Example::
**Using Second Argument As Postitive Values--ROUND(Arg1,Positive...
Func Part..1
FUNCTIONS
FUNCTIONS::
1.Single Row Functions
2.Multi Row Functions
1.Single Row Functions::
If we input 'n' number of input and it produce 'n' number of Output.(n->n)
Types in Single Row Function::
1.Case Functions
i)Case Manipulation
ii)Character Manipulation
...
Sunday, 24 April 2016
Oracle SQL Introduction
Oracle SQL Introduction
WHERE Condition:
A table contains the lacks of records but if we want any "specific record" from the table,in this case we use "WHERE".
Example:
SELECT * FROM employees where Employee_Id='100';
It return the value who all are having the id only 100.
Conditional...
Introduction
Oracle SQL Introduction
An Oracle Database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management
I.Technical...
