User Tools

Site Tools


database:oracle:get-objects

Differences

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

Link to this comparison view

database:oracle:get-objects [2018/03/04 22:29] (current)
odefta created
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: 2018/03/04 22:29 by odefta