Category: PL/SQL

Character / String Functions Ascii Chr Concat Concat || Dump Initcap Instr Length Lower Lpad Ltrim Replace Rpad Rtrim Soundex Substr Translate Trim Upper VSize Conversion Functions Bin_To_Num From_Tz NumToDSInterval NumToYMInterval To_Char To_Date To_Lob To_Number Advanced Functions BFilename Coalesce Decode Group_ID...

Oracle PL/SQL VSize Function The VSize function returns the number of bytes in the internal representation of an expression. The VSize Function syntax: vsize( expression ) Example select vsize('Database tutorial') from dual; would return 17 select vsize(' ') from dual; would...

Oracle PL/SQL User Function The User function returns the user_id from the current Oracle session. The User Function syntax: Select user From dual; Example Select user From dual; TEST...

Oracle PL/SQL Upper Function The Upper function converts all letters in the specified string to uppercase. The Upper Function syntax: upper( string ) Example select upper('Learn Oracle Lesson') from dual; LEARN ORACLE LESSON select upper('oracle 10g') from dual; ORACLE 10G...

Oracle PL/SQL Uid Function The Uid function returns the id number for a user who is currently logged in database. The Uid Function syntax: Select Uid From dual; Example Select Uid From dual; 106...