What are conversion functions?

What are conversion functions?

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?
When one function is called inside the other, it is called a nested function....
What are SQL functions in oracle?
There are two types of functions – Single row that operates row by row. Group function operates on multiple rows..
Explain IN, OUT and INOUT in procedures
IN, OUT and INOUT are the arguments that are passed to the procedures. IN is a 'read only' argument and must be initialised.....
Post your comment