查看某个视图某列的含义,不用百度
来源:互联网 发布:易语言抄袭vb 编辑:程序博客网 时间:2024/06/05 02:50
查看某个视图某列的含义,不用百度
SQL> set line 80
SQL> desc dict_columns
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLE_NAME VARCHAR2(30)
COLUMN_NAME VARCHAR2(30)
COMMENTS VARCHAR2(4000)
SQL> set line 200
SQL> select * from dict_columns where table_name='DBA_TABLES' and column_name='CACHE';
TABLE_NAME COLUMN_NAME COMMENTS
------------------------------ ------------------------------ --------------------------------------------------
DBA_TABLES CACHE Whether the table is to be cached in the buffer ca
che
查询某个表的所有列的含义:
SQL> select * from dict_columns where table_name ='ALL_SNAPSHOTS';
TABLE_NAME COLUMN_NAME COMMENTS
------------------------------ ------------------------------ ----------------------------------------------------------------------------------------------------
ALL_SNAPSHOTS OWNER Owner of the snapshot
ALL_SNAPSHOTS NAME The view used by users and applications for viewing the snapshot
ALL_SNAPSHOTS TABLE_NAME Table the snapshot is stored in -- has an extra column for the master rowid
ALL_SNAPSHOTS MASTER_VIEW View of the master table, owned by the snapshot owner, used for refreshes
ALL_SNAPSHOTS MASTER_OWNER Owner of the master table
ALL_SNAPSHOTS MASTER Name of the master table that this snapshot is a copy of
ALL_SNAPSHOTS MASTER_LINK Database link name to the master site
ALL_SNAPSHOTS CAN_USE_LOG If NO, this snapshot is complex and will never use a log
ALL_SNAPSHOTS UPDATABLE If NO, the snapshot is read only. Look up REPLICATION
ALL_SNAPSHOTS REFRESH_METHOD The values used to drive a fast refresh of the snapshot
ALL_SNAPSHOTS LAST_REFRESH SYSDATE from the master site at the time of the last refresh
TABLE_NAME COLUMN_NAME COMMENTS
------------------------------ ------------------------------ ----------------------------------------------------------------------------------------------------
ALL_SNAPSHOTS ERROR The error returned last time an automatic refresh was attempted
ALL_SNAPSHOTS FR_OPERATIONS
ALL_SNAPSHOTS CR_OPERATIONS
ALL_SNAPSHOTS TYPE The type of refresh (complete,fast,force) for all automatic refreshes
ALL_SNAPSHOTS NEXT The date function used to compute next refresh dates
ALL_SNAPSHOTS START_WITH The date function used to compute next refresh dates
ALL_SNAPSHOTS REFRESH_GROUP All snapshots in a given refresh group get refreshed in the same transaction
ALL_SNAPSHOTS UPDATE_TRIG The name of the trigger which fills the UPDATE_LOG
ALL_SNAPSHOTS UPDATE_LOG The table which logs changes made to an updatable snapshots
ALL_SNAPSHOTS QUERY The original query that this snapshot is an instantiation of
ALL_SNAPSHOTS MASTER_ROLLBACK_SEG Rollback segment to use at the master site
TABLE_NAME COLUMN_NAME COMMENTS
------------------------------ ------------------------------ ----------------------------------------------------------------------------------------------------
ALL_SNAPSHOTS STATUS The status of the contents of the snapshot
ALL_SNAPSHOTS REFRESH_MODE This indicates how and when the snapshot will be refreshed
ALL_SNAPSHOTS PREBUILT If YES, this snapshot uses a prebuilt table as the base table
25 rows selected.
- 查看某个视图某列的含义,不用百度
- sql server 2008查看所有的表,视图,列
- 利用user_updatable_columns视图来查看视图中可以更新的列
- 关于DBA_USERS视图中ACCOUNT_STATUS 列的各种取值的含义说明
- v$archived_log视图中,有关时间的几列的含义
- v$archived_log视图中,有关时间的几列的含义
- 将某个视图开放给某个用户查看
- 视图+视图定义+创建视图+视图的表结构+创建视图的语句+查看视图哪些列是可以进行DML操作
- Oracle DataGuard中的v$database动态性能视图switchover_status列的含义
- 百度搜索参数的含义
- HANA查看某个表在哪些视图中用到了
- 查看某个表的大小
- 查看某个表的索引
- 查看某个Session的统计数据
- 列转行的一视图
- 视图列的设计艺术
- 查找某个用户下的表,某个用户下某个表的列,及列类型
- 做不用过度依赖于百度的seo
- public static Map<String,List<BusFlight>> device_busFlight = new HashMap<String,List<BusFlight>>();
- 1011. A+B和C (15)
- Problem 6 Sum square difference (数学)
- 一些有用的unity3d 、webgl网址
- 产品经理(十张图帮你读懂产品经理)
- 查看某个视图某列的含义,不用百度
- Android视频播放之ViewPager+VideoView
- React Native Android 初次试用遇到的各种坑
- Jnetpcap 官方样例 (1)- 捕获数据包
- Linux命令-whereis与which(查找文件)
- 定义的View生成图片文件
- 关于tomcat出现闪退的问题
- 插入排序算法代码
- iOS 图片轮播