Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

Select initcap( table_name ) from user_tables

SQL> SQL> select initcap( table_name )   2  from user_tables   3  where rownum < 50; INITCAP(TABLE_NAME) ------------------------------ Mytable_Session Done Emp_Changes Aq$_Emp_Changes_S Aq$_Emp_Changes_T Aq$_Emp_Changes_H Compile_Schema_Tmp Temp_Emp Upper_Ename Sys_Iot_Over_16251 Aq$_Emp_Changes_G Aq$_Emp_Changes_I Dept_And_Emp Emp_Reg Sess_Event Sql_Area_Tmp 16 rows selected. SQL> SQL> --