oracle 数据库

  • d9_300457
    了解作者
  • 8.8MB
    文件大小
  • rar
    文件格式
  • 0
    收藏次数
  • VIP专享
    资源类型
  • 0
    下载次数
  • 2022-04-23 05:10
    上传日期
oracle 数据库 oracle 数据库 oracle 数据库 oracle 数据库
Oracle For Software Testing.rar
  • 02
  • sql_lab2.doc
    27KB
  • 02.ppt
    4.3MB
  • 04
  • 04.ppt
    2.2MB
  • Ora92ErrMsg.chm
    1.4MB
  • 01
  • Sql_Lab1.doc
    137KB
  • 01.pptx
    1.5MB
  • 03.ppt
    1.2MB
  • end.ppt
    486.5KB
内容介绍
<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta charset="utf-8"> <meta name="generator" content="pdf2htmlEX"> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"> <link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css"> <link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css"> <link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/6279c755517cd20ea4e158af/raw.css"> <script src="https://static.pudn.com/base/js/compatibility.min.js"></script> <script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script> <script> try{ pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({}); }catch(e){} </script> <title></title> </head> <body> <div id="sidebar" style="display: none"> <div id="outline"> </div> </div> <div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/6279c755517cd20ea4e158af/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">DQL <span class="ff2">&#22522;&#26412;&#35757;&#32451;</span></div><div class="t m0 x2 h4 y3 ff3 fs1 fc0 sc0 ls0 ws0">SQL<span class="_ _0"> </span><span class="ff2 sc1">&#23454;&#36341;&#25351;&#23548;</span></div><div class="t m0 x3 h5 y4 ff3 fs1 fc0 sc0 ls0 ws0">2010-3-22</div><div class="t m0 x4 h6 y5 ff1 fs2 fc0 sc0 ls0 ws0">========================<span class="_ _1"></span>========================<span class="_ _1"></span>======================</div><div class="t m0 x4 h4 y6 ff2 fs1 fc0 sc1 ls0 ws0">&#23454;&#36341;&#30446;&#26631;&#65306;</div><div class="t m0 x5 h7 y7 ff4 fs3 fc0 sc0 ls0 ws0">&#61550;<span class="_ _2"> </span><span class="ff2">&#25484;&#25569;<span class="_ _3"> </span><span class="ff1">DQL</span></span></div><div class="t m0 x5 h7 y8 ff4 fs3 fc0 sc0 ls0 ws0">&#61550;<span class="_ _2"> </span><span class="ff2">&#20102;&#35299;&#24120;&#29992;&#20989;&#25968;</span></div><div class="t m0 x5 h7 y9 ff4 fs3 fc0 sc0 ls0 ws0">&#61550;<span class="_ _2"> </span><span class="ff2">&#29087;&#24713;<span class="_ _3"> </span><span class="ff1">ORACLE10<span class="_ _3"> </span></span>&#20307;&#31995;&#26550;&#26500;</span></div><div class="t m0 x4 h6 ya ff1 fs2 fc0 sc0 ls0 ws0">========================<span class="_ _1"></span>========================<span class="_ _1"></span>======================</div><div class="t m0 x4 h8 yb ff5 fs4 fc0 sc0 ls0 ws0">1.1<span class="_"> </span><span class="ff2 fs5 sc1">&#20934;&#22791;&#24037;&#20316;&#65306;</span></div><div class="t m0 x4 h9 yc ff2 fs2 fc0 sc0 ls0 ws0">&#21551;&#21160;&#22914;&#19979;&#20004;&#20010;&#26381;&#21153;&#65306;</div><div class="t m0 x4 h8 yd ff5 fs4 fc0 sc0 ls0 ws0">1.2<span class="_"> </span><span class="ff2 fs5 sc1">&#21551;&#21160;<span class="ff3 sc0"> </span></span>SQL*Plus </div><div class="t m1 x6 ha yd ff2 fs6 fc0 sc1 ls0 ws0">&#65292;&#28608;&#27963;</div><div class="t m0 x7 hb yd ff5 fs4 fc0 sc0 ls0 ws0">SCOTT</div><div class="t m0 x4 h8 ye ff2 fs5 fc0 sc1 ls0 ws0">&#20197;<span class="_ _3"> </span><span class="ff3 sc0">SYS<span class="_ _4"> </span></span>&#25110;<span class="_ _3"> </span><span class="ff3 sc0">SYSTEM<span class="_ _4"> </span></span>&#30331;&#38470;</div><div class="t m0 x4 h8 yf ff2 fs5 fc0 sc0 ls0 ws0">&#26597;&#30475;&#25152;&#26377;&#29992;&#25143;&#21517;&#23383;</div><div class="t m0 x4 hc y10 ff1 fs5 fc0 sc0 ls0 ws0">select username from all_users;</div><div class="t m0 x4 h8 y11 ff2 fs5 fc0 sc0 ls0 ws0">&#26597;&#30475;&#25152;&#26377;&#29992;&#25143;&#21517;&#23383;&#21450;&#29366;&#24577;</div><div class="t m0 x4 hc y12 ff1 fs5 fc0 sc0 ls0 ws0">select username account_status from dba_users;</div><div class="t m0 x4 h8 y13 ff2 fs5 fc0 sc0 ls0 ws0">&#26597;&#30475;&#26576;&#20010;&#29992;&#25143;&#30340;&#29366;&#24577;</div><div class="t m0 x4 hc y14 ff1 fs5 fc0 sc0 ls0 ws0">select username account_status from dba_users where username='SCOTT&#8216;</div><div class="t m0 x4 h8 y15 ff2 fs5 fc0 sc0 ls0 ws0">&#20462;&#25913;<span class="_ _3"> </span><span class="ff1">SCOTT<span class="_ _4"> </span></span>&#30340;&#29366;&#24577;</div><div class="t m0 x4 hc y16 ff1 fs5 fc0 sc0 ls0 ws0">alter user scott account unlock</div><div class="t m0 x4 h8 y17 ff2 fs5 fc0 sc0 ls0 ws0">&#22240;&#20026;&#22914;&#26524;&#19981;&#20462;&#25913;&#23494;&#30721;&#30340;&#35805;&#26159;&#19981;&#20801;&#35768;&#35775;&#38382;<span class="ff1"> </span></div><div class="t m0 x4 hc y18 ff1 fs5 fc0 sc0 ls0 ws0">alter user scott identified by tiger</div><div class="t m0 x4 h8 y19 ff2 fs5 fc0 sc0 ls0 ws0">&#36864;&#20986;<span class="ff1">:</span><span class="fs3">&#22312;<span class="ff1"> SQL </span>&#25552;&#31034;&#31526;&#19979;&#38190;&#20837;<span class="ff1"> Exit </span></span></div><div class="t m0 x4 h8 y1a ff2 fs5 fc0 sc0 ls0 ws0">&#20197;<span class="_ _3"> </span><span class="ff1">scott<span class="_ _4"> </span></span>&#30331;&#38470;</div><div class="t m0 x4 hd y1b ff5 fs4 fc0 sc0 ls0 ws0">1.3<span class="_"> </span><span class="ff2 sc1">&#20174;&#34920;&#20013;&#26597;&#30475;&#25968;&#25454;</span></div><div class="t m0 x5 h7 y1c ff2 fs3 fc0 sc0 ls0 ws0">&#36755;&#20837;&#34920;&#20013;&#30340;&#25968;&#25454;&#21487;&#36890;&#36807;&#20351;&#29992;<span class="ff1"> <span class="ff3">SELECT</span> </span>&#35821;&#21477;&#36827;&#34892;&#26597;&#30475;&#12290;</div><div class="t m0 x8 he y1d ff1 fs3 fc0 sc0 ls0 ws0">1</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div> </body> </html>
评论
    相关推荐
    • Oracle 数据库
      全面介Oracle数据库
    • oracle数据库
      帮助学习的数据库文档,特别是大型数据库,真的是一个不错的选择
    • oracle 数据库oracle 数据库
      oracle 数据库oracle 数据库oracle 数据库oracle 数据库oracle 数据库oracle 数据库oracle 数据库
    • Oracle数据库
      它是有关于Oracle数据库的实验报告方面的内容,内容很详细!值得大家参考!
    • oracle 数据库
      oracle 数据库软件,用于实现数据库的设计
    • oracle数据库
      oracle数据库
    • oracle 数据库
      oracle 数据库oracle
    • oracle数据库
      oracle数据库祥讲,从oracle基本数据库查询到高级查询视频加源码。
    • ORACLE数据库 ORACLE数据库
      ORACLE数据库ORACLE数据库ORACLE数据库ORACLE数据库ORACLE数据库ORACLE数据库ORACLE数据库ORACLE数据库
    • SIM800C_MQTT.rar
      使用SIM800C模块,使用MQTT协议,连接中国移动onenet平台,能实现数据的订阅、发布、存储等