select lower( table_name ) : LOWER « Char Functions « Oracle PL / SQL

1. Oracle PL / SQL
2. Char Functions
3. LOWER

select lower( table_name )

  
SQL>
SQL> select lower( table_name )
  2  from user_tables
  3  where rownum < 50;
LOWER(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