query all_objects table and subtract object_name : all_objects « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. all_objects

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>

   
  

Related examples in the same category