Oracle record 和 object type 区别及选用

迷南。 2022-04-01 14:49 237阅读 0赞

[https://stackoverflow.com/questions/10848277/difference-between-object-and-record-type][https_stackoverflow.com_questions_10848277_difference-between-object-and-record-type]

# [Difference between object and record type][https_stackoverflow.com_questions_10848277_difference-between-object-and-record-type] #

[Ask Question][] 22 5

I am just curious whats the difference between object and record type in oracle, More specifically between the below declarations

create type emp2_oty is object 
    (
     empno  number,
     ename  varchar2(20),
     deptno number
    );
    
    create type emp2_nt is table of emp2_oty;

and

type emp2_oty is record
    (
     empno  number,
     ename  varchar2(20),
     deptno number
    );
    
    create type emp2_nt is table of emp2_oty;

Please elaborate.

[oracle][]

[share][][improve this question][]

[edited Jul 3 '13 at 21:23][edited_Jul 3 _13 at 21_23]

[![r7Nij.jpg_s_32_g_1][]][r7Nij.jpg_s_32_g_1 1]

[Doug Porter][r7Nij.jpg_s_32_g_1 1]

6,75843253

asked Jun 1 '12 at 10:06

[![62ae4481ea2228b76ebfec3585752697_s_32_d_identicon_r_PG][]][62ae4481ea2228b76ebfec3585752697_s_32_d_identicon_r_PG 1]

[redsoxlost][62ae4481ea2228b76ebfec3585752697_s_32_d_identicon_r_PG 1]

60331123

*  1
    
    basically, record is a pl/sql type, and object types are UDTs that can exist outside pl/sql. Which one you choose depends on your needs really. – [tbone][] [Jun 1 '12 at 11:30][Jun 1 _12 at 11_30]
 *  Objects also have methods, while records only have fields; but the SQL vs. PL/SQL is more relevant here. – [Alex Poole][] [Jun 1 '12 at 11:44][Jun 1 _12 at 11_44]

add a comment

## 2 Answers ##

[active][][oldest][][votes][]

The OBJECT type can be stored in the database and can be used in both SQL and PL/SQL

[share][share 1][improve this answer][]

answered Jun 1 '12 at 10:11

[![48f3b9e42cd9e2fe39c7ec78e5119349_s_32_d_identicon_r_PG][]][48f3b9e42cd9e2fe39c7ec78e5119349_s_32_d_identicon_r_PG 1]

[Jeffrey Vandenborne][48f3b9e42cd9e2fe39c7ec78e5119349_s_32_d_identicon_r_PG 1]

275417

add a comment

*  record:
    
        Cannot be stored in the database.
           Cannot be recursively referenced.
           Cannot have logic defined as part of their definition.
 *  object:
    
        Can be stored as a database table column or as an entire row.
           Can be recursively referenced using the SELF parameter.
           Can have logic defined as part of their definition using member methods.

记录：

无法存储在数据库中。

不能递归引用。

不能将逻辑定义为其定义的一部分。

对象：

可以存储为数据库表列或整行。

可以使用self参数递归引用。

可以使用成员方法将逻辑定义为其定义的一部分。

[share][share 2][improve this answer][improve this answer 1]

answered Nov 6 '12 at 17:57

[![ced3ea29cb4308dcff311fe0b0f14a1d_s_32_d_identicon_r_PG][]][ced3ea29cb4308dcff311fe0b0f14a1d_s_32_d_identicon_r_PG 1]

[venu][ced3ea29cb4308dcff311fe0b0f14a1d_s_32_d_identicon_r_PG 1]

32134

[https://stackoverflow.com/questions/10848277/difference-between-object-and-record-type][https_stackoverflow.com_questions_10848277_difference-between-object-and-record-type]

[http://www.itpub.net/thread-1882302-1-1.html][http_www.itpub.net_thread-1882302-1-1.html]

<table> 
 <tbody> 
  <tr> 
   <td style="background-color:#5d7790;vertical-align:top;"> <h1 style="margin-left:0px;"><strong>关于oracle中record与object的疑惑&nbsp;</strong></h1> <span style="color:#999999;"><a href="http://www.itpub.net/thread-1882302-1-1.html" rel="nofollow">[复制链接]</a></span></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;width:160px;"><a rel="nofollow"></a> <p><a href="http://www.itpub.net/home.php?mod=space&amp;uid=26567865" rel="nofollow">weijunbo83</a></p> <p><a href="http://www.itpub.net/home.php?mod=space&amp;uid=26567865" rel="nofollow"><img alt="" src="http://img.account.itpub.net/head/026/56/78/65.jpg?x-oss-process=style/m" width="120"></a></p> <p>论坛徽章:</p> <p>1</p> <p><img alt="ITPUB 11周年纪念徽章 日期:2012-10-10 13:11:14" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/11zn11_small.png"></p> </td> 
   <td style="background-color:#dfdfdf;vertical-align:top;"> <p>电梯直达<a rel="nofollow"><img alt="跳转到指定楼层" src="http://www.itpub.net/template/itpub/image/fj_btn.png"></a></p> <strong><a href="http://www.itpub.net/thread-1882302-1-1.html" rel="nofollow"><em>1</em>#</a></strong> <p><img alt="" src="http://www.itpub.net/static/image/common/online_member.gif" width="16">&nbsp;<em>发表于 2014-8-7 10:58</em>&nbsp;<span style="color:#cccccc;">|</span>&nbsp;<a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=1882302&amp;page=1&amp;authorid=26567865" rel="nofollow">只看该作者</a>&nbsp;<img alt="回帖奖励" src="http://www.itpub.net/template/itpub/image/arw_r.gif"></p> 
    <table> 
     <tbody> 
      <tr> 
       <td><em>本帖最后由 weijunbo83 于 2014-8-7 10:59 编辑</em><br><br> 我的数据库版本是<a href="http://www.itpub.net/tree/index_1/" rel="nofollow">Oracle</a>&nbsp;Database 10g Enterprise Edition Release 10.2.0.1.0, 在scott用户下执行如下语句，用于将删除的记录数据保存在nasted table中，使用record可以成功，没问题 
        <table> 
         <tbody> 
          <tr> 
           <td style="border-color:#e3edf5;">DECLARE&nbsp;&nbsp;<br> &nbsp; &nbsp;TYPE emp_rec_type IS RECORD&nbsp;&nbsp;<br> &nbsp; &nbsp;(&nbsp;&nbsp;<br> &nbsp; &nbsp;&nbsp; &nbsp;empno&nbsp; &nbsp;&nbsp; &nbsp;emp.empno%TYPE&nbsp;&nbsp;<br> &nbsp; &nbsp;&nbsp;&nbsp;,ename&nbsp; &nbsp;&nbsp; &nbsp;emp.ename%TYPE&nbsp;&nbsp;<br> &nbsp; &nbsp;&nbsp;&nbsp;,hiredate&nbsp; &nbsp;emp.hiredate%TYPE&nbsp;&nbsp;<br> &nbsp; &nbsp;);&nbsp;&nbsp;<br> &nbsp; &nbsp;TYPE nested_emp_type IS TABLE OF emp_rec_type;&nbsp;&nbsp;<br> &nbsp; &nbsp;emp_tab&nbsp; &nbsp;nested_emp_type;&nbsp;&nbsp;<br> BEGIN&nbsp;&nbsp;<br> &nbsp; &nbsp;DELETE FROM emp&nbsp;&nbsp;<br> &nbsp; &nbsp;WHERE&nbsp;&nbsp;deptno = 20&nbsp;&nbsp;<br> &nbsp; &nbsp;RETURNING empno, ename, hiredate&nbsp; &nbsp;&nbsp;&nbsp;--&gt;使用returning 返回这几个列&nbsp; &nbsp;<br> &nbsp; &nbsp;BULK&nbsp; &nbsp;COLLECT INTO emp_tab;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;--&gt;将前面返回的列的数据批量插入到集合变量&nbsp; &nbsp;&nbsp;&nbsp;<br> end;</td> 
          </tr> 
         </tbody> 
        </table><br><br> 但是，如果我这里将record改为使用object就会出现问题，提示:&nbsp;<br> ora-00947:not enough values;代码如下： 
        <table> 
         <tbody> 
          <tr> 
           <td style="border-color:#e3edf5;">create or replace type emp_rec_type IS object<br> &nbsp; &nbsp;(<br> &nbsp; &nbsp;&nbsp; &nbsp;empno&nbsp; &nbsp;&nbsp; &nbsp;NUMBER(4)<br> &nbsp; &nbsp;&nbsp;&nbsp;,ename&nbsp; &nbsp;&nbsp; &nbsp;VARCHAR2(10)<br> &nbsp; &nbsp;&nbsp;&nbsp;,hiredate&nbsp; &nbsp;DATE<br> &nbsp; &nbsp;);&nbsp;<br><br> -------------------------------------------------------<br> DECLARE&nbsp;&nbsp;<br> &nbsp; &nbsp;TYPE nested_emp_type IS TABLE OF emp_rec_type;&nbsp;&nbsp;<br> &nbsp; &nbsp;emp_tab&nbsp; &nbsp;nested_emp_type;&nbsp;&nbsp;<br> BEGIN&nbsp;&nbsp;<br> &nbsp; &nbsp;DELETE FROM emp&nbsp;&nbsp;<br> &nbsp; &nbsp;WHERE&nbsp;&nbsp;deptno = 20&nbsp;&nbsp;<br> &nbsp; &nbsp;RETURNING empno, ename, hiredate&nbsp; &nbsp;&nbsp;&nbsp;--&gt;使用returning 返回这几个列&nbsp; &nbsp;<br> &nbsp; &nbsp;BULK&nbsp; &nbsp;COLLECT INTO emp_tab;&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;--&gt;将前面返回的列的数据批量插入到集合变量&nbsp; &nbsp;&nbsp;&nbsp;<br> end;</td> 
          </tr> 
         </tbody> 
        </table><br><br> 一时搞不清楚原因，通过搜索资料未果，请大牛帮我解惑；这个和数据库版本有关系吗？</td> 
      </tr> 
     </tbody> 
    </table><p><a href="http://www.itpub.net/misc.php?mod=tag&amp;id=52" rel="nofollow">Oracle</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=1883" rel="nofollow">record</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=702" rel="nofollow">object</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=92" rel="nofollow">数据库</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=3667" rel="nofollow">版本</a></p> </td> 
  </tr> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;"> 
    <ul style="margin-left:0px;"> 
     <li><a rel="nofollow">相关帖子</a></li> 
     <li>本版精华</li> 
     <li>热门专题</li> 
    </ul> 
    <ul style="margin-left:0px;"> 
     <li><a href="http://www.itpub.net/thread-2066539-1-1.html" rel="nofollow">《HBase从入门到精通》海量数据时代必修课程，助你快速解决大数据平台随机读写难题</a></li> 
     <li><a href="http://www.itpub.net/thread-2072827-1-1.html" rel="nofollow">【大话IT】身怀数据库优化绝技，如何进行oracle性能诊断？</a></li> 
     <li><a href="http://www.itpub.net/thread-2082777-1-1.html" rel="nofollow">OCMU2017活动：DBA职业发展之路</a></li> 
     <li><a href="http://www.itpub.net/thread-2084204-1-1.html" rel="nofollow">【大话IT】程序员职业危机？人到中年还是CTO的悲哀？</a></li> 
     <li><a href="http://www.itpub.net/thread-2084477-1-1.html" rel="nofollow">【名人堂】专访去哪儿网数据库总监：数据库运维经验谈</a></li> 
     <li><a href="http://www.itpub.net/thread-2084954-1-1.html" rel="nofollow">2017 Oracle RWP 性能之旅，北京站再度来袭</a></li> 
     <li><a href="http://www.itpub.net/thread-2086363-1-1.html" rel="nofollow">《Oracle 12c特性解读-容器数据库和灾备》金牌客座讲师主讲，进阶高级DBA必修</a></li> 
     <li><a href="http://www.itpub.net/thread-2086737-1-1.html" rel="nofollow">【大话IT】以“数据”的名义竞技，国产数据库如何突围？</a></li> 
     <li><a href="http://www.itpub.net/thread-2086757-1-1.html" rel="nofollow">【大话IT】《人民的名义》引深思，畅谈通信时代的安全问题</a></li> 
    </ul></td> 
  </tr> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;width:160px;">&nbsp;</td> 
   <td style="background-color:#dfdfdf;vertical-align:top;"> <p style="margin-left:0px;"><a rel="nofollow">使用道具</a>&nbsp;举报</p> <em><a href="http://www.itpub.net/forum.php?mod=post&amp;action=reply&amp;fid=3&amp;tid=1882302&amp;reppost=22532700&amp;extra=page%3D1&amp;page=1" rel="nofollow">回复</a></em></td> 
  </tr> 
  <tr> 
   <td style="background-color:#ffffff;vertical-align:top;width:160px;">&nbsp;</td> 
   <td style="background-color:#ffffff;vertical-align:top;">&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="background-color:#f1f1f1;vertical-align:top;width:160px;"> <p><a href="http://www.itpub.net/home.php?mod=space&amp;uid=27041417" rel="nofollow">Naldonado</a></p> <p><a href="http://www.itpub.net/home.php?mod=space&amp;uid=27041417" rel="nofollow"><img alt="" src="http://img.account.itpub.net/head/027/04/14/17.jpg?x-oss-process=style/m" width="120"></a></p> <p>论坛徽章:</p> <p>168</p> <p><img alt="SQL数据库编程大师 日期:2016-01-13 10:30:43" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sqlbiancheng_small.gif"><img alt="SQL极客 日期:2013-12-09 14:13:35" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/jike-small.gif"><img alt="SQL大赛参与纪念 日期:2013-12-06 14:03:45" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sqlcanyu_small.gif"><img alt="最佳人气徽章 日期:2015-03-19 09:44:03" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/zuijiarenqi-small.gif"><img alt="现任管理团队成员 日期:2015-08-26 02:10:00" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_15_small.gif"><img alt="秀才 日期:2015-07-28 09:12:12" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/xiucai-small.gif"><img alt="举人 日期:2015-07-13 15:30:15" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/juren-small.gif"><img alt="进士 日期:2015-07-28 09:12:58" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/jinshi-small.gif"><img alt="探花 日期:2015-07-28 09:12:58" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/tanhua-small.gif"><img alt="榜眼 日期:2015-08-18 09:48:03" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/bangyan-small.gif"></p> </td> 
   <td style="background-color:#f1f1f1;vertical-align:top;"><strong><a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=findpost&amp;ptid=1882302&amp;pid=22532919" rel="nofollow"><em>2</em>#</a></strong> <p><img alt="" src="http://www.itpub.net/static/image/common/online_member.gif" width="16">&nbsp;<em>发表于 2014-8-7 12:14</em>&nbsp;<span style="color:#cccccc;">|</span>&nbsp;<a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=1882302&amp;page=1&amp;authorid=27041417" rel="nofollow">只看该作者</a></p> 
    <table> 
     <tbody> 
      <tr> 
       <td>这样当然不行，object的类型，你要RETURNING emp_rec_type(empno, ename, hiredate)</td> 
      </tr> 
     </tbody> 
    </table></td> 
  </tr> 
  <tr> 
   <td style="background-color:#f1f1f1;vertical-align:top;">&nbsp;</td> 
  </tr> 
  <tr> 
   <td style="background-color:#f1f1f1;vertical-align:top;width:160px;">&nbsp;</td> 
   <td style="background-color:#f1f1f1;vertical-align:top;"> <p style="margin-left:0px;"><a rel="nofollow">使用道具</a>&nbsp;举报</p> <em><a href="http://www.itpub.net/forum.php?mod=post&amp;action=reply&amp;fid=3&amp;tid=1882302&amp;repquote=22532919&amp;extra=page%3D1&amp;page=1" rel="nofollow">回复</a></em></td> 
  </tr> 
  <tr> 
   <td style="background-color:#ffffff;vertical-align:top;width:160px;">&nbsp;</td> 
   <td style="background-color:#ffffff;vertical-align:top;">&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

[http://www.itpub.net/thread-1882302-1-1.html][http_www.itpub.net_thread-1882302-1-1.html]

[http://www.itpub.net/thread-1265785-1-1.html][http_www.itpub.net_thread-1265785-1-1.html]

<table> 
 <tbody> 
  <tr> 
   <td style="background-color:#5d7790;vertical-align:top;"> <h1 style="margin-left:0px;"><strong>请教create object 和type XXX is record有什么区别呢&nbsp;</strong></h1> <span style="color:#999999;"><a href="http://www.itpub.net/thread-1265785-1-1.html" rel="nofollow">[复制链接]</a></span></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;width:160px;"> <p><a href="http://www.itpub.net/home.php?mod=space&amp;uid=11021685" rel="nofollow">autumn_leaf</a></p> <p><a href="http://www.itpub.net/home.php?mod=space&amp;uid=11021685" rel="nofollow"><img alt="" src="http://img.account.itpub.net/head/011/02/16/85.jpg?x-oss-process=style/m" width="120"></a></p> <p>论坛徽章:</p> <p>5</p> <p><img alt="ITPUB新首页上线纪念徽章 日期:2007-10-20 08:38:44" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/home_small.gif"><img alt="数据库板块每日发贴之星 日期:2007-12-10 01:03:50" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_7_small.gif"><img alt="ITPUB8周年纪念徽章 日期:2009-09-27 10:21:21" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/8pub_small2.gif"><img alt="鲜花蛋 日期:2012-03-24 10:51:55" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/cd5s.gif"><img alt="灰彻蛋 日期:2012-03-24 19:58:31" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/cd7s.gif"></p> </td> 
   <td style="background-color:#dfdfdf;vertical-align:top;"> <p>电梯直达<a rel="nofollow"><img alt="跳转到指定楼层" src="http://www.itpub.net/template/itpub/image/fj_btn.png"></a></p> <strong><a href="http://www.itpub.net/thread-1265785-1-1.html" rel="nofollow"><em>1</em>#</a></strong> <p><img alt="" src="http://www.itpub.net/static/image/common/online_member.gif" width="16">&nbsp;<em>发表于 2010-1-29 20:22</em>&nbsp;<span style="color:#cccccc;">|</span>&nbsp;<a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=1265785&amp;page=1&amp;authorid=11021685" rel="nofollow">只看该作者</a>&nbsp;<img alt="回帖奖励" src="http://www.itpub.net/template/itpub/image/arw_r.gif"></p> 
    <table> 
     <tbody> 
      <tr> 
       <td>请教create object 和type XXX is record有什么区别呢</td> 
      </tr> 
     </tbody> 
    </table><p><a href="http://www.itpub.net/misc.php?mod=tag&amp;id=226" rel="nofollow">create</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=702" rel="nofollow">object</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=8049" rel="nofollow">type</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=1883" rel="nofollow">record</a></p> </td> 
  </tr> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;"> 
    <ul style="margin-left:0px;"> 
     <li>相关帖子</li> 
     <li>本版精华</li> 
     <li><a rel="nofollow">热门专题</a></li> 
    </ul> 
    <ul style="margin-left:0px;"> 
     <li><a href="http://www.itpub.net/zhuanti/1098/oracle10gshujukukehuduanxiazai_1098383.shtml" rel="nofollow">ORACLE客户端下载</a></li> 
    </ul></td> 
  </tr> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;width:160px;">&nbsp;</td> 
   <td style="background-color:#dfdfdf;vertical-align:top;"> <p style="margin-left:0px;"><a rel="nofollow">使用道具</a>&nbsp;举报</p> <em><a href="http://www.itpub.net/forum.php?mod=post&amp;action=reply&amp;fid=3&amp;tid=1265785&amp;reppost=15166134&amp;extra=page%3D1&amp;page=1" rel="nofollow">回复</a></em></td> 
  </tr> 
  <tr> 
   <td style="background-color:#ffffff;vertical-align:top;width:160px;">&nbsp;</td> 
   <td style="background-color:#ffffff;vertical-align:top;">&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="background-color:#f1f1f1;vertical-align:top;width:160px;"> <p><a href="http://www.itpub.net/home.php?mod=space&amp;uid=86208" rel="nofollow">newkid</a></p> <p><a href="http://www.itpub.net/home.php?mod=space&amp;uid=86208" rel="nofollow"><img alt="" src="http://img.account.itpub.net/head/000/08/62/08.jpg?x-oss-process=style/m" width="120"></a></p> <p>论坛徽章:</p> <p>530</p> <p><img alt="奥运会纪念徽章:垒球 日期:2008-09-15 01:28:12" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/y32.gif"><img alt="生肖徽章2007版:鸡 日期:2008-11-17 23:40:58" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-10small.gif"><img alt="生肖徽章2007版:马 日期:2008-11-18 05:09:48" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-07small.gif"><img alt="数据库板块每日发贴之星 日期:2008-11-29 01:01:02" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_7_small.gif"><img alt="数据库板块每日发贴之星 日期:2008-12-05 01:01:03" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_7_small.gif"><img alt="生肖徽章2007版:虎 日期:2008-12-10 07:47:46" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-03small.gif"><img alt="2009新春纪念徽章 日期:2009-01-04 14:52:28" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2009_niu_small.gif"><img alt="数据库板块每日发贴之星 日期:2009-02-08 01:01:03" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_7_small.gif"><img alt="生肖徽章2007版:蛇 日期:2009-03-09 22:18:53" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/sx2007-06small.gif"><img alt="2009日食纪念 日期:2009-07-22 09:30:00" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/Total_Solar_Eclipse_small.gif"></p> </td> 
   <td style="background-color:#f1f1f1;vertical-align:top;"><strong><a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=findpost&amp;ptid=1265785&amp;pid=15166477" rel="nofollow"><em>2</em>#</a></strong> <p><img alt="" src="http://www.itpub.net/static/image/common/online_member.gif" width="16">&nbsp;<em>发表于 2010-1-29 22:23</em>&nbsp;<span style="color:#cccccc;">|</span>&nbsp;<a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=1265785&amp;page=1&amp;authorid=86208" rel="nofollow">只看该作者</a></p> 
    <table> 
     <tbody> 
      <tr> 
       <td>record 只能够用在PL/SQL中，OBJECT 可以用于SQL, 还可带成员函数;<br> record变量声明后可以直接使用，OBJECT还要执行初始化函数。</td> 
      </tr> 
     </tbody> 
    </table></td> 
  </tr> 
  <tr> 
   <td style="background-color:#f1f1f1;vertical-align:top;">&nbsp;</td> 
  </tr> 
  <tr> 
   <td style="background-color:#f1f1f1;vertical-align:top;width:160px;">&nbsp;</td> 
   <td style="background-color:#f1f1f1;vertical-align:top;"> <p style="margin-left:0px;"><a rel="nofollow">使用道具</a>&nbsp;举报</p> <em><a href="http://www.itpub.net/forum.php?mod=post&amp;action=reply&amp;fid=3&amp;tid=1265785&amp;repquote=15166477&amp;extra=page%3D1&amp;page=1" rel="nofollow">回复</a></em></td> 
  </tr> 
  <tr> 
   <td style="background-color:#ffffff;vertical-align:top;width:160px;">&nbsp;</td> 
   <td style="background-color:#ffffff;vertical-align:top;">&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;width:160px;"> <p><a href="http://www.itpub.net/home.php?mod=space&amp;uid=8458" rel="nofollow">guostong</a></p> <p><a href="http://www.itpub.net/home.php?mod=space&amp;uid=8458" rel="nofollow"><img alt="" src="http://img.account.itpub.net/head/000/00/84/58.jpg?x-oss-process=style/m" width="120"></a></p> <p>论坛徽章:</p> <p>38</p> <p><img alt="授权会员 日期:2005-10-30 17:05:33" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_14_small.gif"><img alt="2012新春纪念徽章 日期:2012-02-13 15:12:09" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2012fuzhang-small.gif"><img alt="现任管理团队成员 日期:2011-11-07 09:46:59" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_15_small.gif"><img alt="ITPUB十周年纪念徽章 日期:2011-11-01 16:19:41" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/10years_small.gif"><img alt="ITPUB9周年纪念徽章 日期:2010-10-08 09:31:21" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/zc2010small.gif"><img alt="版主3段 日期:2012-05-15 15:24:11" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/grade3-small.gif"><img alt="2009新春纪念徽章 日期:2009-01-04 14:52:28" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2009_niu_small.gif"><img alt="2010新春纪念徽章 日期:2010-03-01 11:06:20" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2010_hu_small.gif"><img alt="2009日食纪念 日期:2009-07-22 09:30:00" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/Total_Solar_Eclipse_small.gif"><img alt="祖国60周年纪念徽章 日期:2009-10-09 08:28:00" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/60_NationalDay_small1.gif"></p> </td> 
   <td style="background-color:#dfdfdf;vertical-align:top;"><strong><a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=findpost&amp;ptid=1265785&amp;pid=15166482" rel="nofollow"><em>3</em>#</a></strong> <p><img alt="" src="http://www.itpub.net/static/image/common/online_member.gif" width="16">&nbsp;<em>发表于 2010-1-29 22:24</em>&nbsp;<span style="color:#cccccc;">|</span>&nbsp;<a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=1265785&amp;page=1&amp;authorid=8458" rel="nofollow">只看该作者</a></p> 
    <table> 
     <tbody> 
      <tr> 
       <td><a href="http://www.itpub.net/thread-1157164-1-1.html" rel="nofollow">http://www.itpub.net/thread-1157164-1-1.html</a></td> 
      </tr> 
     </tbody> 
    </table></td> 
  </tr> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;">&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

[http://www.itpub.net/thread-1265785-1-1.html][http_www.itpub.net_thread-1265785-1-1.html]

[http://www.itpub.net/thread-1157164-1-1.html][http_www.itpub.net_thread-1157164-1-1.html]

<table> 
 <tbody> 
  <tr> 
   <td style="background-color:#5d7790;vertical-align:top;"> <h1 style="margin-left:0px;"><strong>bject和records&nbsp;</strong></h1> <span style="color:#999999;"><a href="http://www.itpub.net/thread-1157164-1-1.html" rel="nofollow">[复制链接]</a></span></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;width:160px;"><span style="color:#444444;"></span> <p><span style="color:#444444;"><a href="http://www.itpub.net/home.php?mod=space&amp;uid=16209030" rel="nofollow">zjj1002</a></span></p> <p><span style="color:#444444;"><a href="http://www.itpub.net/home.php?mod=space&amp;uid=16209030" rel="nofollow"><img alt="" src="http://img.account.itpub.net/head/016/20/90/30.jpg?x-oss-process=style/m" width="120"></a></span></p> <p><span style="color:#444444;">论坛徽章:</span></p> <p><span style="color:#444444;">1</span></p> <p><span style="color:#444444;"><img alt="2011新春纪念徽章 日期:2011-02-18 11:42:49" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/2010fu_small.gif"></span></p> </td> 
   <td style="background-color:#dfdfdf;vertical-align:top;"> <p><span style="color:#444444;">电梯直达<a rel="nofollow"><img alt="跳转到指定楼层" src="http://www.itpub.net/template/itpub/image/fj_btn.png"></a></span></p> <span style="color:#444444;"><strong><a href="http://www.itpub.net/thread-1157164-1-1.html" rel="nofollow"><em>1</em>#</a></strong></span> <p><span style="color:#444444;"><img alt="" src="http://www.itpub.net/static/image/common/online_member.gif" width="16">&nbsp;<em>发表于 2009-4-27 11:46</em>&nbsp;<span style="color:#cccccc;">|</span>&nbsp;<a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=1157164&amp;page=1&amp;authorid=16209030" rel="nofollow">只看该作者</a>&nbsp;<img alt="回帖奖励" src="http://www.itpub.net/template/itpub/image/arw_r.gif"></span></p> 
    <table> 
     <tbody> 
      <tr> 
       <td><span style="color:#444444;">如题，create type zjj as object (n number);<br> type zjj is record(.....);<br> 这2句有什么区别啊？<br> 另外有create table zjj1 of zjj;这种用法吗？<br> 书上看来的，不懂<br> 希望各位大大能给我解个疑，谢谢！~</span></td> 
      </tr> 
     </tbody> 
    </table><p><span style="color:#444444;"><a href="http://www.itpub.net/misc.php?mod=tag&amp;id=702" rel="nofollow">object</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=2679" rel="nofollow">records</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=226" rel="nofollow">create</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=8049" rel="nofollow">type</a>,&nbsp;<a href="http://www.itpub.net/misc.php?mod=tag&amp;id=225" rel="nofollow">number</a></span></p> </td> 
  </tr> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;"> 
    <ul style="margin-left:0px;"> 
     <li><span style="color:#444444;"><a rel="nofollow">相关帖子</a></span></li> 
     <li><span style="color:#444444;">本版精华</span></li> 
     <li><span style="color:#444444;">热门专题</span></li> 
    </ul> 
    <ul style="margin-left:0px;"> 
     <li><span style="color:#444444;"><a href="http://www.itpub.net/thread-1899559-1-1.html" rel="nofollow">【讨论】为什么插入6000多行数据要3个小时 求大神 ！</a></span></li> 
     <li><span style="color:#444444;"><a href="http://www.itpub.net/thread-1901165-1-1.html" rel="nofollow">【讨论】按文件行数写多个文件（比如10条写一个文件，11-20条写第二个文件</a></span></li> 
     <li><span style="color:#444444;"><a href="http://www.itpub.net/thread-1902171-1-1.html" rel="nofollow">【讨论】 大神们看一下这个函数 哪里有问题？</a></span></li> 
     <li><span style="color:#444444;"><a href="http://www.itpub.net/thread-1904320-1-1.html" rel="nofollow">【讨论】oracle数据库不完全恢复不成功，大家帮忙看看可能是什么原因</a></span></li> 
     <li><span style="color:#444444;"><a href="http://www.itpub.net/thread-1904347-1-1.html" rel="nofollow">【讨论】递归的累计值如何用SQL写(只能用Model来实现)</a></span></li> 
     <li><span style="color:#444444;"><a href="http://www.itpub.net/thread-1905546-1-1.html" rel="nofollow">【讨论】运用自定义函数，sql非常慢，求大神帮忙优化一下！！</a></span></li> 
     <li><span style="color:#444444;"><a href="http://www.itpub.net/thread-1908174-1-1.html" rel="nofollow">【大话IT】需要判断存储过程参数的个人 高手进</a></span></li> 
     <li><span style="color:#444444;"><a href="http://www.itpub.net/thread-1911572-1-1.html" rel="nofollow">【大话IT】为什么在存储过程中是NULL的 ？？？</a></span></li> 
     <li><span style="color:#444444;"><a href="http://www.itpub.net/thread-1911707-1-1.html" rel="nofollow">【大话IT】怎么用存储过程返回一行记录（变量）</a></span></li> 
    </ul></td> 
  </tr> 
  <tr> 
   <td style="background-color:#dfdfdf;vertical-align:top;width:160px;">&nbsp;</td> 
   <td style="background-color:#dfdfdf;vertical-align:top;"> <p style="margin-left:0px;"><span style="color:#444444;"><a rel="nofollow">使用道具</a>&nbsp;举报</span></p> <span style="color:#444444;"><em><a href="http://www.itpub.net/forum.php?mod=post&amp;action=reply&amp;fid=3&amp;tid=1157164&amp;reppost=13448233&amp;extra=page%3D1&amp;page=1" rel="nofollow">回复</a></em></span></td> 
  </tr> 
  <tr> 
   <td style="background-color:#ffffff;vertical-align:top;width:160px;">&nbsp;</td> 
   <td style="background-color:#ffffff;vertical-align:top;">&nbsp;</td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="background-color:#f1f1f1;vertical-align:top;width:160px;"><span style="color:#444444;"></span> <p><span style="color:#444444;"><a href="http://www.itpub.net/home.php?mod=space&amp;uid=10706603" rel="nofollow">lee_defei</a></span></p> <p><span style="color:#444444;"><a href="http://www.itpub.net/home.php?mod=space&amp;uid=10706603" rel="nofollow"><img alt="" src="http://img.account.itpub.net/head/010/70/66/03.jpg?x-oss-process=style/m" width="120"></a></span></p> <p><span style="color:#444444;">论坛徽章:</span></p> <p><span style="color:#444444;">6</span></p> <p><span style="color:#444444;"><img alt="数据库板块每日发贴之星 日期:2009-04-29 01:01:02" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_7_small.gif"><img alt="数据库板块每日发贴之星 日期:2009-05-03 01:01:02" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_7_small.gif"><img alt="数据库板块每日发贴之星 日期:2009-05-04 01:01:02" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_7_small.gif"><img alt="数据库板块每日发贴之星 日期:2009-05-11 01:01:02" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_7_small.gif"><img alt="数据库板块每日发贴之星 日期:2009-05-17 01:01:03" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/medal_7_small.gif"><img alt="ITPUB9周年纪念徽章 日期:2010-10-08 09:31:21" src="http://www.itpub.net/source/plugin/itpub_medal/medalimgs/zc2010small.gif"></span></p> </td> 
   <td style="background-color:#f1f1f1;vertical-align:top;"><span style="color:#444444;"><strong><a href="http://www.itpub.net/forum.php?mod=redirect&amp;goto=findpost&amp;ptid=1157164&amp;pid=13460932" rel="nofollow"><em>2</em>#</a></strong></span> <p><span style="color:#444444;"><img alt="" src="http://www.itpub.net/static/image/common/online_member.gif" width="16">&nbsp;<em>发表于 2009-4-28 23:57</em>&nbsp;<span style="color:#cccccc;">|</span>&nbsp;<a href="http://www.itpub.net/forum.php?mod=viewthread&amp;tid=1157164&amp;page=1&amp;authorid=10706603" rel="nofollow">只看该作者</a></span></p> 
    <table> 
     <tbody> 
      <tr> 
       <td><span style="color:#444444;">最直接的区别是，create type zjj as object (n number);<br> 这个可以建立一个数据的类型对象，以后可以在其他地方引用，而type zjj is record仅仅是声明一种类型，只能在存储过程里面使用&nbsp;&nbsp;create table zjj1 of zjj 这个用法是有的</span></td> 
      </tr> 
     </tbody> 
    </table></td> 
  </tr> 
 </tbody> 
</table>

[http://www.itpub.net/thread-1157164-1-1.html][http_www.itpub.net_thread-1157164-1-1.html]

[https_stackoverflow.com_questions_10848277_difference-between-object-and-record-type]: https://stackoverflow.com/questions/10848277/difference-between-object-and-record-type
[Ask Question]: https://stackoverflow.com/questions/ask
[oracle]: https://stackoverflow.com/questions/tagged/oracle
[share]: https://stackoverflow.com/q/10848277
[improve this question]: https://stackoverflow.com/posts/10848277/edit
[edited_Jul 3 _13 at 21_23]: https://stackoverflow.com/posts/10848277/revisions
[r7Nij.jpg_s_32_g_1]: https://i.stack.imgur.com/r7Nij.jpg?s=32&g=1
[r7Nij.jpg_s_32_g_1 1]: https://stackoverflow.com/users/4311/doug-porter
[62ae4481ea2228b76ebfec3585752697_s_32_d_identicon_r_PG]: https://www.gravatar.com/avatar/62ae4481ea2228b76ebfec3585752697?s=32&d=identicon&r=PG
[62ae4481ea2228b76ebfec3585752697_s_32_d_identicon_r_PG 1]: https://stackoverflow.com/users/1371683/redsoxlost
[tbone]: https://stackoverflow.com/users/534120/tbone
[Jun 1 _12 at 11_30]: https://stackoverflow.com/questions/10848277/difference-between-object-and-record-type#comment14129576_10848277
[Alex Poole]: https://stackoverflow.com/users/266304/alex-poole
[Jun 1 _12 at 11_44]: https://stackoverflow.com/questions/10848277/difference-between-object-and-record-type#comment14129865_10848277
[active]: https://stackoverflow.com/questions/10848277/difference-between-object-and-record-type?answertab=active#tab-top
[oldest]: https://stackoverflow.com/questions/10848277/difference-between-object-and-record-type?answertab=oldest#tab-top
[votes]: https://stackoverflow.com/questions/10848277/difference-between-object-and-record-type?answertab=votes#tab-top
[share 1]: https://stackoverflow.com/a/10848350
[improve this answer]: https://stackoverflow.com/posts/10848350/edit
[48f3b9e42cd9e2fe39c7ec78e5119349_s_32_d_identicon_r_PG]: https://www.gravatar.com/avatar/48f3b9e42cd9e2fe39c7ec78e5119349?s=32&d=identicon&r=PG
[48f3b9e42cd9e2fe39c7ec78e5119349_s_32_d_identicon_r_PG 1]: https://stackoverflow.com/users/232966/jeffrey-vandenborne
[share 2]: https://stackoverflow.com/a/13256633
[improve this answer 1]: https://stackoverflow.com/posts/13256633/edit
[ced3ea29cb4308dcff311fe0b0f14a1d_s_32_d_identicon_r_PG]: https://www.gravatar.com/avatar/ced3ea29cb4308dcff311fe0b0f14a1d?s=32&d=identicon&r=PG
[ced3ea29cb4308dcff311fe0b0f14a1d_s_32_d_identicon_r_PG 1]: https://stackoverflow.com/users/1786200/venu
[http_www.itpub.net_thread-1882302-1-1.html]: http://www.itpub.net/thread-1882302-1-1.html
[http_www.itpub.net_thread-1265785-1-1.html]: http://www.itpub.net/thread-1265785-1-1.html
[http_www.itpub.net_thread-1157164-1-1.html]: http://www.itpub.net/thread-1157164-1-1.html