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; | ||
+ | </ | ||
+ | |||
+ | ===== List indexes ===== | ||
+ | |||
+ | <code sql> | ||
+ | select index_name, table_name from user_indexes; | ||
+ | </ |
database/oracle/get-objects.txt · Last modified: 2023/07/04 19:36 by 127.0.0.1