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