Other Functions
UID:- To display the user id.
Syn:- UID
Ex:- select uid from dual;
USER:- to display the user name.
Syn:- USER
Ex:- select user from dual;
NVL:- It is used to in the case where we want to cinsider Null values as zero.
Syn:- NVL(exp1,exp2)
Ex:- select eno,na,nvl(sal,0) from vision;
VSIZE:- This function returns the number of bytes in the expression
Syn:- VSIZE(‘exp’)
Ex:- select vsize(‘prasad’) from dual;
For
Online Classes
Contact Us: +919885348743
Online Classes
Contact Us: +919885348743