USER_VIEW_COLUMNS USER_VIEWS V$VERSION I/O统计视图和I/O延迟分布视图 触发器 开发包 开发存储过程 对象类型和对象 插件 跨机并行查询 闪回 分区表 大小写不敏感 存储过程中使用holdable cursor 实时物化视图 逻辑复制槽故障转移(Logical Replication Slot Failover) Global Cache Global Plan Cache PartitionedTabl...
The ALL_TAB_COLS view does not filter out system-generated hidden columns. Related Views DBA_TAB_COLUMNS describes the columns of all tables, views, and clusters in the database. USER_TAB_COLUMNS describes the columns of the tables, views, and clusters owned by the current user. This ...
The ALL_TAB_COLUMNS view provides information on all columns in all user-defined tables and views. NameTypeDescription owner CHARACTER VARYING User name of the owner of the table or view in which the column resides. schema_name CHARACTER VARYING Name of the schema in which the table or view...
e.g., this works fine: create table foo ( bar number(19,6) ) ; create view baz as select bar from foo ; select * from all_tab_columns where table_name in ('FOO', 'BAZ') ; OWNER,TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_TYPE_MOD,DATA_TYPE_OWNER,DATA_LENGTH,DATA_PRECISION...
USER_VIEW_COLUMNS USER_VIEWS V$VERSION I/O统计视图和I/O延迟分布视图 触发器 开发包 开发存储过程 对象类型和对象 插件 跨机并行查询 闪回 分区表 大小写不敏感 存储过程中使用holdable cursor 实时物化视图 逻辑复制槽故障转移(Logical Replication Slot Failover) Global Cache Global Plan Cache PartitionedTabl...
USER_VIEW_COLUMNS USER_VIEWS V$VERSION I/O统计视图和I/O延迟分布视图 触发器 开发包 开发存储过程 对象类型和对象 插件 跨机并行查询 闪回 分区表 大小写不敏感 存储过程中使用holdable cursor 实时物化视图 逻辑复制槽故障转移(Logical Replication Slot Failover) Global Cache Global Plan Cache PartitionedTabl...