User Tools

Site Tools


database:oracle:get-objects

This is an old revision of the document!


Get Objects From Current Schema

List tables

SELECT TABLE_NAME FROM user_tables;

List indexes

SELECT index_name, TABLE_NAME FROM user_indexes;
database/oracle/get-objects.1520195357.txt.gz · Last modified: 2023/07/04 19:36 (external edit)