search

Home >Database >Mysql Tutorial >oracle用sql查询描述表结构及字段和说明

oracle用sql查询描述表结构及字段和说明

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 14:57:592567browse

oracle用sql查询描述表结构及字段和说明 Oracle SELECT DISTINCT AAA.COLUMN_NAME,AAA.DATA_TYPE,AAA.DATA_LENGTH,AAA.NULLABLE,BBB.COMMENTS FROM ALL_TAB_COLUMNS AAA,USER_COL_COMMENTS BBB WHERE AAA.COLUMN_NAME=BBB.COLUMN_NAMEAND AAA.TABLE_NAME='SY_

oracle用sql查询描述表结构及字段和说明

Oracle oracle用sql查询描述表结构及字段和说明 
SELECT DISTINCT AAA.COLUMN_NAME,AAA.DATA_TYPE,AAA.DATA_LENGTH,AAA.NULLABLE,BBB.COMMENTS 
	FROM ALL_TAB_COLUMNS AAA,USER_COL_COMMENTS BBB 
	WHERE AAA.COLUMN_NAME=BBB.COLUMN_NAME
	AND AAA.TABLE_NAME='SY_USER_JOB';
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：oracle树形查询，oracle树形模糊查询Next article：定时添加，删除Mysql分区

Related articles

See more