Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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