Oracle-07£º±ðÃû£¬È¥ÖØ£¬×Ó²éѯ

<div class="blogpost-body" id="cnblogs_post_body">
<p> </p>
<p><span style="color:#ff0000;"><strong><span style="font-size:18px;"><strong><strong><strong><strong><strong><strong>------------ÎáÒàÎÞËû,ΨÊÖÊì¶û，Ç«±°ÈôÓÞ，ºÃѧÈô¼¢-------------</strong></strong></strong></strong></strong></strong></span></strong></span></p>
<p> </p>
<p><strong><span style="font-size:18px;">ÒÀ¾ÉÌṩÊý¾Ý¿â½Å±¾¹©²Ù×÷</span></strong></p>
<p> </p>
<div class="cnblogs_code">
  <img alt="" class="code_img_closed" id="code_img_closed_2f6f6205-4fca-40f8-8e9a-f4d8639d56e0" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-8f900a89c6347c561fdf2122f13be562.gif">
  <img alt="" class="code_img_opened" id="code_img_opened_2f6f6205-4fca-40f8-8e9a-f4d8639d56e0" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-961ddebeb323a10fe0623af514929fc1.gif">
  <div class="cnblogs_code_hide" id="cnblogs_code_open_2f6f6205-4fca-40f8-8e9a-f4d8639d56e0">
   <pre class="blockcode"><span style="color:#0000ff;">create</span> <span style="color:#0000ff;">table</span><span style="color:#000000;"> DEPT
(
  deptno </span><span style="color:#0000ff;">NUMBER</span>(<span style="color:#800000;font-weight:bold;">2</span>) <span style="color:#808080;">not</span> <span style="color:#0000ff;">null</span><span style="color:#000000;">,
  dname  </span><span style="color:#0000ff;">VARCHAR2</span>(<span style="color:#800000;font-weight:bold;">20</span><span style="color:#000000;">),
  loc    </span><span style="color:#0000ff;">VARCHAR2</span>(<span style="color:#800000;font-weight:bold;">13</span><span style="color:#000000;">)
);

  
</span><span style="color:#0000ff;">alter</span> <span style="color:#0000ff;">table</span><span style="color:#000000;"> DEPT
  </span><span style="color:#0000ff;">add</span> <span style="color:#0000ff;">constraint</span> PK_DEPT <span style="color:#0000ff;">primary</span> <span style="color:#0000ff;">key</span><span style="color:#000000;"> (DEPTNO);

</span><span style="color:#0000ff;">create</span> <span style="color:#0000ff;">table</span><span style="color:#000000;"> TEACHER
(
  tno       </span><span style="color:#0000ff;">NUMBER</span>(<span style="color:#800000;font-weight:bold;">4</span>) <span style="color:#808080;">not</span> <span style="color:#0000ff;">null</span><span style="color:#000000;">,
  tname     </span><span style="color:#0000ff;">VARCHAR2</span>(<span style="color:#800000;font-weight:bold;">30</span>) <span style="color:#808080;">not</span> <span style="color:#0000ff;">null</span><span style="color:#000000;">,
  tid       </span><span style="color:#0000ff;">CHAR</span>(<span style="color:#800000;font-weight:bold;">18</span><span style="color:#000000;">),
  gendar    </span><span style="color:#0000ff;">CHAR</span>(<span style="color:#800000;font-weight:bold;">3</span><span style="color:#000000;">),
  birthdate DATE,
  job       </span><span style="color:#0000ff;">VARCHAR2</span>(<span style="color:#800000;font-weight:bold;">20</span><span style="color:#000000;">),
  hiredate  DATE,
  sal       </span><span style="color:#0000ff;">NUMBER</span>(<span style="color:#800000;font-weight:bold;">7</span>,<span style="color:#800000;font-weight:bold;">2</span><span style="color:#000000;">),
  deptno    </span><span style="color:#0000ff;">NUMBER</span>(<span style="color:#800000;font-weight:bold;">2</span><span style="color:#000000;">),
  mgrno     </span><span style="color:#0000ff;">NUMBER</span>(<span style="color:#800000;font-weight:bold;">4</span><span style="color:#000000;">),
  comm      </span><span style="color:#0000ff;">NUMBER</span>(<span style="color:#800000;font-weight:bold;">7</span>,<span style="color:#800000;font-weight:bold;">2</span><span style="color:#000000;">)
);

</span><span style="color:#0000ff;">insert</span> <span style="color:#0000ff;">into</span><span style="color:#000000;"> DEPT (deptno, dname, loc)
</span><span style="color:#0000ff;">values</span> (<span style="color:#800000;font-weight:bold;">40</span>, <span style="color:#ff0000;">&#39;</span><span style="color:#ff0000;">ÈËÁ¦²¿</span><span style="color:#ff0000;">&#39;</span>, <span style="color:#ff0000;">&#39;</span><span style="color:#ff0000;">±±¾©º£µí</span><span style="color:#ff0000;">&#39;</span><span style="color:#000000;">);
</span><span style="color:#0000ff;">insert</span> <span style="color:#0000ff;">into</span><span style="color:#000000;"> DEPT (deptno, dname, loc)
</span><span style="color:#0000ff;">values</span> (<span style="color:#800000;font-weight:bold;">30</span>, <span style="color:#ff0000;">&#39;</span><span style="color:#ff0000;">²úÆ·²¿</span><span style="color:#ff0000;">&#39;</span>, <span style="color:#ff0000;">&#39;</span><span style="color:#ff0000;">±±¾©º£µí</span><span style="color:#ff0000;">&#39;</span><span style="color:#000000;">);
</span><span style="color:#0000ff;">insert</span> <span style="color:#0000ff;">into</span><span style="color:#000000;"> DEPT (deptno, dname, loc)
</span><span style="color:#0000ff;">values</span> (<span style="color:#800000;font-weight:bold;">20</span>, <span style="color:#ff0000;">&#39;</span><span style="color:#ff0000;">ÕÐÉú²¿</span><span style="color:#ff0000;">&#39;</span>, <span style="color:#ff0000;">&#39;</span><span style="color:#ff0000;">ÉϺ£ºçÇÅ</span><span style="color:#ff0000;">&#39;</span><span style="color:#000000;">);
</span><span style="color:#0000ff;">insert</span> <span style="col