System Tables Views Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. System Tables Views
  4. 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>