반응형
Notice
Recent Posts
Recent Comments
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
31 |
Tags
- RabbitMQ
- Docker Compose
- Airflow
- spring boot
- Spring Open Feign
- docker
- WebLogic
- spring boot redis
- weblogic 10
- QueryDSL
- Netty
- spring cloud
- docker compose mysql
- redis
- grafana
- vue.js
- docker-compose
- argo cd
- KAFKA
- Redis Sentinel
- Hibernate
- netflix oss
- Selenium
- JPA
- cassandra
- mybatis
- jmeter
- MySQL
- coalesce
- ChannelPipeline
Archives
- Today
- Total
IT.FARMER
Oracle standard... table column comment, table comment 본문
반응형
밑줄긋고, 빨간색으로 표시된 표식 주목, TAB T, USER_TAB_COMMENTS TC, user_TAB_COLUMNS C, USER_COL_COMMENTS CC
SELECT
T.TNAME AS TABLE_NAME,
TC.COMMENTS AS TABLE_COMMENTS,
C.COLUMN_NAME AS COLUMN_NAME,
C.DATA_TYPE AS DATA_TYPE,
CC.COMMENTS AS COLUMN_COMMENTS
FROM TAB T, USER_TAB_COMMENTS TC, user_TAB_COLUMNS C, USER_COL_COMMENTS CC
WHERE T.TNAME = TC.TABLE_NAME
AND T.TNAME = C.TABLE_NAME
AND T.TNAME = CC.TABLE_NAME
AND C.COLUMN_NAME = CC.COLUMN_NAME
반응형
'DataBase > oracle' 카테고리의 다른 글
oracle 10g 이상 WM_CONCAT (여러 row 를 한컬럼에) (0) | 2011.08.30 |
---|---|
Oracle 가로데이터 세로정렬 (0) | 2011.08.02 |
Oracle - DB link (0) | 2011.04.14 |
oracle table space create and user creation (0) | 2011.04.12 |
Oracle User Creation And Authority[유저생성 및 권한] (0) | 2011.02.22 |