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> --

Related examples in the same category

1.	Initcap: changes the first (initial) letter of a word (string) or series of words into uppercase
2.	INITCAP() returns the character string passed into it with the first letter of each word capitalized
3.	Simple demo for INITAP: sets the first character in each word to uppercase and the rest to lowercase
4.	INITCAP: capital the first letter in a word
5.	select initcap('THESE WORDS will be INITcapped')
6.	INITCAP a sentence

select initcap( table_name ) from user_tables : INITCAP « Char Functions « Oracle PL / SQL

Related examples in the same category