Oracle中文基础PPT
资源内容介绍
Oracle中文基础PPT 虽然是10g，但是学习Oracle，10g版本没问题 Less01_DB_Architecture_MB3.ppt Less02_Installation_MB3.ppt Less03_DB_DBCA_MB3.ppt Less04_Instance_TB3.ppt Less05_Storage_TB3.ppt Less06_Users_MB3.ppt Less07_Schema_TB3.ppt Less08_Data_TB3.ppt Less09_Undo_TB3.ppt Less10_Security_MB3.ppt Less11_Network_MB3.ppt Less12_ProactiveM_MB3.ppt Less13_Performance_TB3.ppt Less14_BR_Concepts_MB3.ppt Less15_Backups_TB3.ppt Less16_R <link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/base.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89595424/raw.css" rel="stylesheet"/><div id="sidebar" style="display: none"><div id="outline"></div></div><div class="pf w0 h0" data-page-no="1" id="pf1"><div class="pc pc1 w0 h0"><img alt="" class="bi x0 y0 w1 h1" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89595424/bg1.jpg"/><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">7</div><div class="t m0 x2 h3 y2 ff2 fs1 fc1 sc0 ls0 ws0">版权所有<span class="ff3"> © 2006</span>，<span class="ff3">Oracle</span>。保留所有权利。<span class="ff3"> </span></div><div class="t m0 x3 h4 y3 ff2 fs2 fc1 sc0 ls0 ws0">管理方案对象<span class="ff4"> </span></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div><div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89595424/bg2.jpg"><div class="t m0 x2 h3 y2 ff2 fs1 fc1 sc0 ls0 ws0">版权所有<span class="ff3"> © 2006</span>，<span class="ff3">Oracle</span>。保留所有权利。<span class="ff3"> </span></div><div class="t m0 x4 h4 y4 ff2 fs2 fc1 sc0 ls0 ws0">课程目标<span class="ff4"> </span></div><div class="t m0 x5 h5 y5 ff2 fs3 fc1 sc0 ls0 ws0">学完本课后，应能完成以下工作：<span class="ff4"> </span></div><div class="t m0 x6 h5 y6 ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">定义方案对象和数据类型<span class="ff4"> </span></span></div><div class="t m0 x6 h5 y7 ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">创建和修改表<span class="ff4"> </span></span></div><div class="t m0 x6 h5 y8 ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">定义约束条件<span class="ff4"> </span></span></div><div class="t m0 x6 h5 y9 ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">查看表列和表内容<span class="ff4"> </span></span></div><div class="t m0 x6 h5 ya ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">创建索引<span class="ff4"> </span></span></div><div class="t m0 x6 h5 yb ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">创建视图<span class="ff4"> </span></span></div><div class="t m0 x6 h5 yc ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">创建序列<span class="ff4"> </span></span></div><div class="t m0 x6 h5 yd ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">说明临时表的用法<span class="ff4"> </span></span></div><div class="t m0 x6 h5 ye ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">使用数据字典<span class="ff4"> </span></span></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div><div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89595424/bg3.jpg"><div class="t m0 x2 h3 y2 ff2 fs1 fc1 sc0 ls0 ws0">版权所有<span class="ff3"> © 2006</span>，<span class="ff3">Oracle</span>。保留所有权利。<span class="ff3"> </span></div><div class="t m0 x7 h4 y4 ff2 fs2 fc1 sc0 ls0 ws0">什么是方案</div><div class="t m0 x8 h6 yf ff5 fs5 fc1 sc0 ls0 ws0">HR<span class="ff4"> <span class="ff2">方案</span></span> </div><div class="t m0 x9 h6 y10 ff5 fs5 fc1 sc0 ls0 ws0">HR<span class="ff4"> <span class="ff2">用户</span></span> </div><div class="t m0 xa h6 y11 ff2 fs5 fc1 sc0 ls0 ws0">拥有 </div><div class="t m0 xb h7 y12 ff4 fs6 fc3 sc0 ls0 ws0">><span class="_ _1"> </span><span class="ff2">方案</span></div><div class="t m0 xc h7 y13 ff2 fs6 fc1 sc0 ls0 ws0">约束条件<span class="fc3"> </span></div><div class="t m0 xc h7 y14 ff2 fs6 fc1 sc0 ls0 ws0">索引 </div><div class="t m0 xc h7 y15 ff2 fs6 fc1 sc0 ls0 ws0">视图 </div><div class="t m0 xc h7 y16 ff2 fs6 fc1 sc0 ls0 ws0">序列 </div><div class="t m0 xc h7 y17 ff2 fs6 fc1 sc0 ls0 ws0">临时表 </div><div class="t m0 xc h7 y18 ff2 fs6 fc1 sc0 ls0 ws0">数据字典<span class="ff4"> </span></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div><div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89595424/bg4.jpg"><div class="t m0 x2 h3 y2 ff2 fs1 fc1 sc0 ls0 ws0">版权所有<span class="ff3"> © 2006</span>，<span class="ff3">Oracle</span>。保留所有权利。<span class="ff3"> </span></div><div class="t m0 xd h4 y4 ff2 fs2 fc1 sc0 ls0 ws0">访问方案对象<span class="ff4"> </span></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div><div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89595424/bg5.jpg"><div class="t m0 x2 h3 y2 ff2 fs1 fc1 sc0 ls0 ws0">版权所有<span class="ff3"> © 2006</span>，<span class="ff3">Oracle</span>。保留所有权利。<span class="ff3"> </span></div><div class="t m0 xe h4 y4 ff2 fs2 fc1 sc0 ls0 ws0">命名数据库对象<span class="ff4"> </span></div><div class="t m0 xf h5 y19 ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">名称长度必须为<span class="ff4"> 1 </span>至<span class="ff4"> 30 </span>个字节，但以下情况例外：<span class="ff4"> </span></span></div><div class="t m0 x10 h8 y1a ff4 fs7 fc2 sc0 ls0 ws0">–<span class="_ _2"> </span><span class="ff2 fs8 fc1">数据库名称限制为<span class="ff4"> 8 </span>个字节。<span class="ff4"> </span></span></div><div class="t m0 x10 h8 y1b ff4 fs7 fc2 sc0 ls0 ws0">–<span class="_ _2"> </span><span class="ff2 fs8 fc1">数据库链接名最长可为<span class="ff4"> 128 </span>个字节。<span class="ff4"> </span></span></div><div class="t m0 xf h5 y1c ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">不带引号的名称不能是<span class="ff4"> Oracle </span>保留字。<span class="ff4"> </span></span></div><div class="t m0 xf h5 y1d ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">不带引号的名称必须以数据库字符集中的字母字符开头</span></div><div class="t m0 x9 h5 y1e ff2 fs3 fc1 sc0 ls0 ws0">。<span class="ff4"> </span></div><div class="t m0 xf h5 y1f ff4 fs4 fc2 sc0 ls0 ws0">•<span class="_ _0"> </span><span class="ff2 fs3 fc1">不建议使用带引号的名称。<span class="ff4"> </span></span></div></div><div class="pi" data-data='{"ctm":[1.333333,0.000000,0.000000,1.333333,0.000000,0.000000]}'></div></div>