Obsidian/Recognition/Programing/Oracle/테이블 컬럼명 조회.md

7 lines
157 B
Markdown
Raw Permalink Normal View History

2023-08-14 16:19:25 +00:00
### 전체 소문자(Alias)
select NLS_LOWER( column_name)||','
from USER_TAB_COLUMNS
where table_name = upper('mobile_csorder_master')
order by column_id