Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query all_objects table and subtract object_name

SQL> SQL> SQL> select substr(object_name,1,2)   2    from all_objects t1   3   where rownum = 1   4  / SU -- IC SQL> SQL>