Oracle Functions - August 11, 2008 at 15:00 PM by Amit Satpute
What are conversion functions?
Answer
CHARTOROWID
Converts a string to a ROWID.
CONVERT
Converts a string from one character set to another.
HEXTORAW
Converts from hexadecimal to raw format.
RAWTOHEX
Converts from raw value to hexadecimal.
ROWIDTOCHAR
Converts a binary ROWID value to a character string.
TO_CHAR
Converts a number or date to a string.
TO_DATE
Converts a string to a date.
TO_NUMBER
Converts a string to a number.
What is nested function?
Answer
When one function is called inside the other, it is called a nested
function.
Oracle Functions - Nov 17, 2008 at 15:00 PM by Nishant Kumar
What is NVL function?
Answer
Oracle deals with Null values using NVL function. The function
replaces the NULL value in the given column with the value provide to it. The
function accepts two parameters, the first one is the column name and the
second one is the value with which NULL has to be replaced.
Example
Select Amount – NVL(Disc, 0) from Price
What are SQL functions in oracle?
Answer
There are two types of functions – Single row that operates row by
row. Group function operates on multiple rows.
Functions that fall under single functions are Date, Numeric, Character,
Conversion and miscellaneous function
Functions that fall under group functions are avg, max, min, count, and sum.
The answers to following questions will be made available soon. Keep
visiting.
Define Aggregate and Group function.
Explain Character, Numeric and Date function in brief.
What are conversion functions?
What is nested function?
|