Oracle 19c にテーブル一覧、VIEW一覧を確認
1.テーブル一覧を確認
SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME ;
2.VIEW一覧を確認
SELECT VIEW_NAME FROM USER_VIEWS ORDER BY VIEW_NAME ;
3.指定オーナーでカラム一覧を絞り込む
SELECT OWNER ,TABLE_NAME ,COLUMN_NAME ,COLUMN_ID FROM ALL_TAB_COLUMNS WHERE OWNER = 'RIBIWEB4'
4.指定テーブル名でカラム一覧を絞り込む
SELECT OWNER ,TABLE_NAME ,COLUMN_NAME ,COLUMN_ID FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'USER_TBL' ORDER BY COLUMN_ID