User Tools

Site Tools


database:oracle:get-objects
no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


Last revision
database:oracle:get-objects [2018/03/04 22:29] – created odefta
Line 1: Line 1:
 +====== Get Objects From Current Schema ======
  
 +===== List tables =====
 +
 +<code sql>
 +select table_name from user_tables;
 +</code>
 +
 +===== List indexes =====
 +
 +<code sql>
 +select index_name, table_name from user_indexes;
 +</code>
database/oracle/get-objects.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1