gpt4 book ai didi

oracle12c - Oracle 12c中SYS.ALL_TAB_COLUMNS和SYS.ALL_TAB_COLS之间的区别

转载 作者:行者123 更新时间:2023-12-01 09:24:53 25 4
gpt4 key购买 nike

Oracle 12c中的ALL_TAB_COLUMNSALL_TAB_COLS系统表有什么区别?在我的数据库中,ALL_TAB_COLUMNS的行比ALL_TAB_COLS的行少。

最佳答案

From the Oracle manual for ALL_TAB_COLS

This view differs from "ALL_TAB_COLUMNS" in that system-generated hidden columns and invisible columns, which are user-generated hidden columns, are not filtered out.



From the Oracle manual for ALL_TAB_COLUMNS

This view filters out system-generated hidden columns and invisible columns, which are user-generated hidden columns. The ALL_TAB_COLS view does not filter out hidden columns and invisible columns

关于oracle12c - Oracle 12c中SYS.ALL_TAB_COLUMNS和SYS.ALL_TAB_COLS之间的区别,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/26790333/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com