查看: 103|回复: 0

如何有效地利用数据字典

[复制链接]
发表于 2024-11-17 11:21:31 | 显示全部楼层 |阅读模式

如何有效地利用数据字典
   ORACLE的数据字典是数据库的重要组成部分之一,它随着数据库的产生而产生, 随着数据库的变化而变化,
体现为sys用户下的一些表和视图。数据字典名称是大写的英文字符。

    数据字典里存有用户信息、用户的权限信息、所有数据对象信息、表的约束条件、统计分析数据库的视图等。
我们不能手工修改数据字典里的信息。

  很多时候,一般的ORACLE用户不知道如何有效地利用它。

  dictionary   全部数据字典表的名称和解释,它有一个同义词dict
    dict_column   全部数据字典表里字段名称和解释

    如果我们想查询跟索引有关的数据字典时,可以用下面这条SQL语句:

    SQL>select * from dictionary where instr(comments,'index')>0;

    如果我们想知道user_indexes表各字段名称的详细含义,可以用下面这条SQL语句:

    SQL>select column_name,comments from dict_columns where table_name='USER_INDEXES';

    依此类推,就可以轻松知道数据字典的详细名称和解释,不用查看ORACLE的其它文档资料了。















51sole.com/b2b/pd_442138577.htm
51sole.com/b2b/pd_442138637.htm
51sole.com/b2b/pd_442138689.htm
51sole.com/b2b/pd_442138741.htm
51sole.com/b2b/pd_442138805.htm
51sole.com/b2b/pd_442138855.htm
51sole.com/b2b/pd_442138900.htm
51sole.com/b2b/pd_442138951.htm
51sole.com/b2b/pd_442139002.htm
51sole.com/b2b/pd_442139054.htm
51sole.com/b2b/pd_442139111.htm
51sole.com/b2b/pd_442139170.htm
51sole.com/b2b/pd_442139221.htm
51sole.com/b2b/pd_442139283.htm
51sole.com/b2b/pd_442139334.htm
51sole.com/b2b/pd_442139382.htm
51sole.com/b2b/pd_442139494.htm
51sole.com/b2b/pd_442139552.htm
51sole.com/b2b/pd_442139604.htm
51sole.com/b2b/pd_442139665.htm
51sole.com/b2b/pd_442139709.htm
51sole.com/b2b/pd_442139767.htm
51sole.com/b2b/pd_442139820.htm
51sole.com/b2b/pd_442139868.htm
51sole.com/b2b/pd_442139923.htm
51sole.com/b2b/pd_442139967.htm
51sole.com/b2b/pd_442140041.htm
51sole.com/b2b/pd_442140082.htm
51sole.com/b2b/pd_442140134.htm
51sole.com/b2b/pd_442140174.htm
51sole.com/b2b/pd_442140217.htm
51sole.com/b2b/pd_442140265.htm
51sole.com/b2b/pd_442140331.htm
51sole.com/b2b/pd_442140391.htm
51sole.com/b2b/pd_442140451.htm
51sole.com/b2b/pd_442140496.htm
51sole.com/b2b/pd_442140552.htm
51sole.com/b2b/pd_442140592.htm
51sole.com/b2b/pd_442140648.htm
51sole.com/b2b/pd_442140724.htm
51sole.com/b2b/pd_442140773.htm
51sole.com/b2b/pd_442140827.htm
51sole.com/b2b/pd_442140878.htm
51sole.com/b2b/pd_442140924.htm
51sole.com/b2b/pd_442140966.htm
51sole.com/b2b/pd_442141013.htm
51sole.com/b2b/pd_442141099.htm
51sole.com/b2b/pd_442141141.htm
51sole.com/b2b/pd_442141178.htm
51sole.com/b2b/pd_442141236.htm
51sole.com/b2b/pd_442141289.htm
51sole.com/b2b/pd_442141326.htm
51sole.com/b2b/pd_442141373.htm
51sole.com/b2b/pd_442141463.htm
51sole.com/b2b/pd_442141559.htm
51sole.com/b2b/pd_442141596.htm
51sole.com/b2b/pd_442141685.htm
51sole.com/b2b/pd_442141746.htm
51sole.com/b2b/pd_442141787.htm
51sole.com/b2b/pd_442141840.htm
51sole.com/b2b/pd_442141884.htm
51sole.com/b2b/pd_442141927.htm
51sole.com/b2b/pd_442141979.htm
51sole.com/b2b/pd_442142029.htm
51sole.com/b2b/pd_442142075.htm
51sole.com/b2b/pd_442142121.htm
51sole.com/b2b/pd_442142173.htm
51sole.com/b2b/pd_442142227.htm
51sole.com/b2b/pd_442142276.htm
51sole.com/b2b/pd_442142374.htm
51sole.com/b2b/pd_442142454.htm
51sole.com/b2b/pd_442142507.htm
51sole.com/b2b/pd_442142567.htm
51sole.com/b2b/pd_442142622.htm
51sole.com/b2b/pd_442142664.htm
51sole.com/b2b/pd_442142719.htm
51sole.com/b2b/pd_442142788.htm
51sole.com/b2b/pd_442142843.htm
51sole.com/b2b/pd_442142936.htm
51sole.com/b2b/pd_442142990.htm
51sole.com/b2b/pd_442143054.htm
51sole.com/b2b/pd_442143109.htm
51sole.com/b2b/pd_442143158.htm
51sole.com/b2b/pd_442143224.htm
51sole.com/b2b/pd_442143276.htm
51sole.com/b2b/pd_442143330.htm
51sole.com/b2b/pd_442143389.htm
51sole.com/b2b/pd_442143449.htm
51sole.com/b2b/pd_442143497.htm
51sole.com/b2b/pd_442143554.htm
51sole.com/b2b/pd_442143602.htm
51sole.com/b2b/pd_442143654.htm
51sole.com/b2b/pd_442143713.htm
51sole.com/b2b/pd_442143760.htm
51sole.com/b2b/pd_442143819.htm
51sole.com/b2b/pd_442143858.htm
51sole.com/b2b/pd_442143919.htm
51sole.com/b2b/pd_442143967.htm
51sole.com/b2b/pd_442144016.htm
51sole.com/b2b/pd_442144074.htm
51sole.com/b2b/pd_442144121.htm
51sole.com/b2b/pd_442144165.htm
51sole.com/b2b/pd_442144221.htm
51sole.com/b2b/pd_442144274.htm
51sole.com/b2b/pd_442144327.htm
51sole.com/b2b/pd_442144431.htm
51sole.com/b2b/pd_442144538.htm
51sole.com/b2b/pd_442144581.htm
51sole.com/b2b/pd_442144628.htm
51sole.com/b2b/pd_442144671.htm
51sole.com/b2b/pd_442144771.htm
51sole.com/b2b/pd_442144864.htm
51sole.com/b2b/pd_442144917.htm
51sole.com/b2b/pd_442144963.htm
51sole.com/b2b/pd_442145021.htm
51sole.com/b2b/pd_442145079.htm
51sole.com/b2b/pd_442145113.htm
51sole.com/b2b/pd_442145212.htm
51sole.com/b2b/pd_442145273.htm
51sole.com/b2b/pd_442145314.htm
51sole.com/b2b/pd_442145349.htm
51sole.com/b2b/pd_442145391.htm
51sole.com/b2b/pd_442145435.htm
51sole.com/b2b/pd_442145491.htm
51sole.com/b2b/pd_442145553.htm
51sole.com/b2b/pd_442145597.htm
51sole.com/b2b/pd_442145650.htm
51sole.com/b2b/pd_442145695.htm
51sole.com/b2b/pd_442145743.htm
51sole.com/b2b/pd_442145790.htm
51sole.com/b2b/pd_442145833.htm
51sole.com/b2b/pd_442145882.htm
51sole.com/b2b/pd_442145940.htm
51sole.com/b2b/pd_442145985.htm
51sole.com/b2b/pd_442146038.htm
51sole.com/b2b/pd_442146097.htm
51sole.com/b2b/pd_442146135.htm
51sole.com/b2b/pd_442146194.htm
51sole.com/b2b/pd_442146234.htm
51sole.com/b2b/pd_442146281.htm
51sole.com/b2b/pd_442146329.htm
51sole.com/b2b/pd_442146427.htm
51sole.com/b2b/pd_442146484.htm
51sole.com/b2b/pd_442146534.htm
51sole.com/b2b/pd_442146588.htm
51sole.com/b2b/pd_442146647.htm
51sole.com/b2b/pd_442146688.htm
51sole.com/b2b/pd_442146740.htm
51sole.com/b2b/pd_442146795.htm
51sole.com/b2b/pd_442146878.htm
51sole.com/b2b/pd_442146922.htm
51sole.com/b2b/pd_442147015.htm
51sole.com/b2b/pd_442147060.htm
51sole.com/b2b/pd_442147109.htm
51sole.com/b2b/pd_442147160.htm
51sole.com/b2b/pd_442147203.htm
51sole.com/b2b/pd_442147251.htm
51sole.com/b2b/pd_442147298.htm
51sole.com/b2b/pd_442147344.htm
51sole.com/b2b/pd_442147383.htm
51sole.com/b2b/pd_442147439.htm
51sole.com/b2b/pd_442147490.htm
51sole.com/b2b/pd_442147541.htm
51sole.com/b2b/pd_442147605.htm
51sole.com/b2b/pd_442147653.htm
51sole.com/b2b/pd_442147792.htm
51sole.com/b2b/pd_442147840.htm
51sole.com/b2b/pd_442147879.htm
51sole.com/b2b/pd_442148032.htm
51sole.com/b2b/pd_442148086.htm
51sole.com/b2b/pd_442148138.htm
51sole.com/b2b/pd_442148189.htm
51sole.com/b2b/pd_442148233.htm
51sole.com/b2b/pd_442148275.htm
51sole.com/b2b/pd_442148322.htm
51sole.com/b2b/pd_442148373.htm
51sole.com/b2b/pd_442148422.htm
51sole.com/b2b/pd_442148470.htm
51sole.com/b2b/pd_442148517.htm
51sole.com/b2b/pd_442148597.htm
51sole.com/b2b/pd_442148645.htm
51sole.com/b2b/pd_442148703.htm
51sole.com/b2b/pd_442148753.htm
51sole.com/b2b/pd_442148807.htm
51sole.com/b2b/pd_442148850.htm
51sole.com/b2b/pd_442148904.htm
51sole.com/b2b/pd_442148957.htm
51sole.com/b2b/pd_442148996.htm
51sole.com/b2b/pd_442149050.htm
51sole.com/b2b/pd_442149095.htm
51sole.com/b2b/pd_442149143.htm
51sole.com/b2b/pd_442149193.htm
51sole.com/b2b/pd_442149234.htm
51sole.com/b2b/pd_442149285.htm
51sole.com/b2b/pd_442149330.htm
51sole.com/b2b/pd_442149377.htm
51sole.com/b2b/pd_442149424.htm
51sole.com/b2b/pd_442149487.htm
51sole.com/b2b/pd_442149527.htm
51sole.com/b2b/pd_442149574.htm
51sole.com/b2b/pd_442149657.htm
51sole.com/b2b/pd_442149705.htm
51sole.com/b2b/pd_442149746.htm
51sole.com/b2b/pd_442149800.htm
51sole.com/b2b/pd_442149850.htm
51sole.com/b2b/pd_442149892.htm
51sole.com/b2b/pd_442149935.htm
51sole.com/b2b/pd_442149974.htm
51sole.com/b2b/pd_442150075.htm
51sole.com/b2b/pd_442150122.htm
51sole.com/b2b/pd_442150164.htm
51sole.com/b2b/pd_442150204.htm
51sole.com/b2b/pd_442150250.htm
51sole.com/b2b/pd_442150288.htm
51sole.com/b2b/pd_442150333.htm
51sole.com/b2b/pd_442150372.htm
51sole.com/b2b/pd_442150408.htm
51sole.com/b2b/pd_442150451.htm
51sole.com/b2b/pd_442150490.htm
51sole.com/b2b/pd_442150530.htm
51sole.com/b2b/pd_442150579.htm
51sole.com/b2b/pd_442150630.htm
51sole.com/b2b/pd_442150674.htm
51sole.com/b2b/pd_442150713.htm
51sole.com/b2b/pd_442150764.htm
51sole.com/b2b/pd_442150809.htm
51sole.com/b2b/pd_442150852.htm
51sole.com/b2b/pd_442150893.htm
51sole.com/b2b/pd_442150934.htm
51sole.com/b2b/pd_442150974.htm
51sole.com/b2b/pd_442151011.htm
51sole.com/b2b/pd_442151092.htm
51sole.com/b2b/pd_442151129.htm
51sole.com/b2b/pd_442151165.htm
51sole.com/b2b/pd_442151193.htm
51sole.com/b2b/pd_442151236.htm
51sole.com/b2b/pd_442151287.htm
51sole.com/b2b/pd_442151325.htm
51sole.com/b2b/pd_442151376.htm
51sole.com/b2b/pd_442151415.htm
51sole.com/b2b/pd_442151454.htm
51sole.com/b2b/pd_442151500.htm
51sole.com/b2b/pd_442151541.htm
51sole.com/b2b/pd_442151580.htm
51sole.com/b2b/pd_442151618.htm
51sole.com/b2b/pd_442151676.htm
51sole.com/b2b/pd_442151754.htm
51sole.com/b2b/pd_442151796.htm
51sole.com/b2b/pd_442151838.htm
51sole.com/b2b/pd_442151876.htm
51sole.com/b2b/pd_442151919.htm
51sole.com/b2b/pd_442151962.htm
51sole.com/b2b/pd_442152001.htm
51sole.com/b2b/pd_442152034.htm
51sole.com/b2b/pd_442152076.htm
51sole.com/b2b/pd_442152109.htm
51sole.com/b2b/pd_442152187.htm
51sole.com/b2b/pd_442152263.htm
51sole.com/b2b/pd_442152301.htm
51sole.com/b2b/pd_442152339.htm
51sole.com/b2b/pd_442152423.htm
51sole.com/b2b/pd_442152461.htm
51sole.com/b2b/pd_442152503.htm
51sole.com/b2b/pd_442152556.htm
51sole.com/b2b/pd_442152591.htm
51sole.com/b2b/pd_442152621.htm
51sole.com/b2b/pd_442152671.htm
51sole.com/b2b/pd_442152698.htm
51sole.com/b2b/pd_442152737.htm
51sole.com/b2b/pd_442152779.htm
51sole.com/b2b/pd_442152812.htm
51sole.com/b2b/pd_442152862.htm
51sole.com/b2b/pd_442152898.htm
51sole.com/b2b/pd_442152934.htm
51sole.com/b2b/pd_442153004.htm
51sole.com/b2b/pd_442153043.htm
51sole.com/b2b/pd_442153083.htm
51sole.com/b2b/pd_442153126.htm
51sole.com/b2b/pd_442153168.htm
51sole.com/b2b/pd_442153204.htm
51sole.com/b2b/pd_442153234.htm
51sole.com/b2b/pd_442153271.htm
51sole.com/b2b/pd_442153307.htm
51sole.com/b2b/pd_442153344.htm
51sole.com/b2b/pd_442153384.htm
51sole.com/b2b/pd_442153423.htm
51sole.com/b2b/pd_442153452.htm
51sole.com/b2b/pd_442153481.htm
51sole.com/b2b/pd_442153513.htm
51sole.com/b2b/pd_442153560.htm
51sole.com/b2b/pd_442153592.htm
51sole.com/b2b/pd_442153633.htm
51sole.com/b2b/pd_442153662.htm
51sole.com/b2b/pd_442153699.htm
51sole.com/b2b/pd_442153730.htm
51sole.com/b2b/pd_442153774.htm
51sole.com/b2b/pd_442153815.htm
51sole.com/b2b/pd_442153843.htm
51sole.com/b2b/pd_442153877.htm
51sole.com/b2b/pd_442153922.htm
51sole.com/b2b/pd_442153956.htm
51sole.com/b2b/pd_442154003.htm
51sole.com/b2b/pd_442154040.htm
51sole.com/b2b/pd_442154070.htm
51sole.com/b2b/pd_442154109.htm
51sole.com/b2b/pd_442154136.htm
51sole.com/b2b/pd_442154177.htm
51sole.com/b2b/pd_442154249.htm
51sole.com/b2b/pd_442154280.htm
51sole.com/b2b/pd_442154319.htm
51sole.com/b2b/pd_442154361.htm
51sole.com/b2b/pd_442154394.htm
51sole.com/b2b/pd_442154431.htm
51sole.com/b2b/pd_442154468.htm
51sole.com/b2b/pd_442154507.htm
51sole.com/b2b/pd_442154534.htm
51sole.com/b2b/pd_442154579.htm
51sole.com/b2b/pd_442154623.htm
51sole.com/b2b/pd_442154647.htm
51sole.com/b2b/pd_442154685.htm
51sole.com/b2b/pd_442154728.htm
51sole.com/b2b/pd_442154764.htm
51sole.com/b2b/pd_442154845.htm
51sole.com/b2b/pd_442154877.htm
51sole.com/b2b/pd_442154906.htm
51sole.com/b2b/pd_442154946.htm
51sole.com/b2b/pd_442154984.htm
51sole.com/b2b/pd_442155014.htm
51sole.com/b2b/pd_442155050.htm
51sole.com/b2b/pd_442155095.htm
51sole.com/b2b/pd_442155140.htm
51sole.com/b2b/pd_442155179.htm
51sole.com/b2b/pd_442155262.htm
51sole.com/b2b/pd_442155304.htm
51sole.com/b2b/pd_442155346.htm
51sole.com/b2b/pd_442155381.htm
51sole.com/b2b/pd_442155428.htm
51sole.com/b2b/pd_442155469.htm
51sole.com/b2b/pd_442155503.htm
51sole.com/b2b/pd_442155543.htm
51sole.com/b2b/pd_442155585.htm
51sole.com/b2b/pd_442155663.htm
51sole.com/b2b/pd_442155713.htm
51sole.com/b2b/pd_442155743.htm
51sole.com/b2b/pd_442155773.htm
51sole.com/b2b/pd_442155812.htm
51sole.com/b2b/pd_442155850.htm
51sole.com/b2b/pd_442155899.htm
51sole.com/b2b/pd_442155930.htm
51sole.com/b2b/pd_442155978.htm
51sole.com/b2b/pd_442156019.htm
51sole.com/b2b/pd_442156061.htm
51sole.com/b2b/pd_442156107.htm
51sole.com/b2b/pd_442156150.htm
51sole.com/b2b/pd_442156188.htm
51sole.com/b2b/pd_442156233.htm
51sole.com/b2b/pd_442156275.htm
51sole.com/b2b/pd_442156335.htm
51sole.com/b2b/pd_442156373.htm
51sole.com/b2b/pd_442156412.htm
51sole.com/b2b/pd_442156452.htm
51sole.com/b2b/pd_442156503.htm
51sole.com/b2b/pd_442156544.htm
51sole.com/b2b/pd_442156583.htm
51sole.com/b2b/pd_442156619.htm
51sole.com/b2b/pd_442156657.htm
51sole.com/b2b/pd_442156758.htm
51sole.com/b2b/pd_442156796.htm
51sole.com/b2b/pd_442156830.htm
51sole.com/b2b/pd_442156865.htm
51sole.com/b2b/pd_442156904.htm
51sole.com/b2b/pd_442156974.htm
51sole.com/b2b/pd_442157001.htm
51sole.com/b2b/pd_442157047.htm
51sole.com/b2b/pd_442157086.htm
51sole.com/b2b/pd_442157120.htm
51sole.com/b2b/pd_442157156.htm
51sole.com/b2b/pd_442157191.htm
51sole.com/b2b/pd_442157228.htm
51sole.com/b2b/pd_442157268.htm
51sole.com/b2b/pd_442157310.htm
51sole.com/b2b/pd_442157335.htm
51sole.com/b2b/pd_442157374.htm
51sole.com/b2b/pd_442157411.htm
51sole.com/b2b/pd_442157448.htm
51sole.com/b2b/pd_442157484.htm
51sole.com/b2b/pd_442157524.htm
51sole.com/b2b/pd_442157556.htm
51sole.com/b2b/pd_442157591.htm
51sole.com/b2b/pd_442157626.htm
51sole.com/b2b/pd_442157659.htm
51sole.com/b2b/pd_442157696.htm
51sole.com/b2b/pd_442157734.htm
51sole.com/b2b/pd_442157763.htm
51sole.com/b2b/pd_442157799.htm
51sole.com/b2b/pd_442157825.htm
51sole.com/b2b/pd_442157858.htm
51sole.com/b2b/pd_442157900.htm
51sole.com/b2b/pd_442157932.htm
51sole.com/b2b/pd_442157964.htm

您需要登录后才可以回帖 登录 | 加入ZFS

本版积分规则

快速回复 返回顶部 返回列表