tag:blogger.com,1999:blog-8884584404576003487.post921542644668604875..comments2024-02-29T09:43:12.251-05:00Comments on ORACLENERD: INTEGER = NUMBER(38)oraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8884584404576003487.post-57034518957599089752009-08-04T11:47:16.663-04:002009-08-04T11:47:16.663-04:00@Chet
behaviour looks same on 10.2.0.4 as well :...@Chet <br />behaviour looks same on 10.2.0.4 as well :) Interesting finding. <br /><br />SQL> select dbms_metadata.get_ddl( object_type, object_name, owner )<br /> 2 from all_objects where object_name='T' ;<br /><br />DBMS_METADATA.GET_DDL(OBJECT_TYPE,OBJECT_NAME,OWNER)<br />------------------------------------------------------------------------<br />-------------------------------------------------<br /><br /> CREATE TABLE "EYDBA"."T"<br /> ( "X" NUMBER(*,0)<br /> ) ....Coskan Gundogarhttps://www.blogger.com/profile/11570869033287689498noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-44084315692443540432009-08-04T07:53:58.126-04:002009-08-04T07:53:58.126-04:00@coskan
From 11.1.0.6
SQL> SELECT * FROM v$ve...@coskan<br /><br /><b>From 11.1.0.6</b><br /><br />SQL> SELECT * FROM v$version;<br /><br />BANNER<br />--------------------------------------------------------------------------------<br />Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production<br />PL/SQL Release 11.1.0.6.0 - Production<br />CORE 11.1.0.6.0 Production<br />TNS for Linux: Version 11.1.0.6.0 - Production<br />NLSRTL Version 11.1.0.6.0 - Production<br /><br /><br />SQL> SELECT dbms_metadata.get_ddl( object_type, object_name, owner ) l<br /> 2 FROM all_objects<br /> 3 WHERE object_name = 'T';<br /><br />L<br />--------------------------------------------------------------------------------<br /><br /> CREATE TABLE "CJUSTICE"."T"<br /> ( "X" NUMBER(38,0)<br /> ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING<br /> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645<br /> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)<br /> TABLESPACE "USERS"oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-46822710928175480362009-08-04T07:20:00.547-04:002009-08-04T07:20:00.547-04:00@coskan
I suppose version and stuff would have be...@coskan<br /><br />I suppose version and stuff would have been important huh? ;)<br /><br /><b>From 10.2.0.1</b>:<br /><br />CJUSTICE@TESTING>SELECT * FROM v$version;<br /><br />BANNER<br />----------------------------------------------------------------<br />Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod<br />PL/SQL Release 10.2.0.1.0 - Production<br />CORE 10.2.0.1.0 Production<br />TNS for 32-bit Windows: Version 10.2.0.1.0 - Production<br />NLSRTL Version 10.2.0.1.0 - Production<br /><br />CJUSTICE@TESTING>SELECT dbms_metadata.get_ddl( object_type, object_name, owner )<br /> 2 FROM all_objects<br /> 3 WHERE object_name = 'T';<br /><br />DBMS_METADATA.GET_DDL(OBJECT_TYPE,OBJECT_NAME,OWNER)<br />--------------------------------------------------------------------------------<br /><br /> CREATE TABLE "CJUSTICE"."T"<br /> ( "X" NUMBER(*,0)<br /> ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING<br /> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645<br /> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)<br /> TABLESPACE "USERS"<br /><br /><b>From 10.2.0.3</b>:<br />CJUSTICE@ORASTAGE>SELECT * FROM V$VERSION;<br /><br />BANNER<br />----------------------------------------------------------------<br />Oracle Database 10g Release 10.2.0.3.0 - 64bit Production<br />PL/SQL Release 10.2.0.3.0 - Production<br />CORE 10.2.0.3.0 Production<br />TNS for Linux: Version 10.2.0.3.0 - Production<br />NLSRTL Version 10.2.0.3.0 - Production<br /><br />CJUSTICE@ORASTAGE>CREATE TABLE T ( X INTEGER );<br /><br />Table created.<br /><br />Elapsed: 00:00:00.04<br />CJUSTICE@ORASTAGE>SELECT dbms_metadata.get_ddl( object_type, object_name, owner ) l<br /> 2 FROM all_objects<br /> 3 WHERE object_name = 'T';<br /><br />L<br />--------------------------------------------------------------------------------<br /><br /> CREATE TABLE "CJUSTICE"."T"<br /> ( "X" NUMBER(*,0)<br /> ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING<br /> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645<br /> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)<br /> TABLESPACE "USERS"oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-90320841019037171042009-08-04T03:49:12.355-04:002009-08-04T03:49:12.355-04:00@Chet I dont know why it is 38 but I dont get the ...@Chet I dont know why it is 38 but I dont get the same result for table definition in 11G Can you also send the output of DBMS_METADATA.GET_DDL<br /><br />SQL> CREATE TABLE t<br /> 2 (<br /> 3 x INTEGER<br /> 4 );<br /><br />Table created.<br /><br />SQL> desc t;<br /> Name Null? Type<br /> ------------------------------- -------- ----------------------------<br /> 1 X NUMBER(38)<br /><br />SQL> select dbms_metadata.get_ddl( object_type, object_name, owner )<br /> 2 from all_objects where object_name='T' ;<br /><br />DBMS_METADATA.GET_DDL(OBJECT_TYPE,OBJECT_NAME,OWNER)<br />---------------------------------------------------------------------------------<br />-------------------------------------------------<br /><br /> CREATE TABLE "HR"."T"<br /> ( "X" NUMBER(38,0)<br /> ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING<br /> STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645<br /> PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)<br /> TABLESPACE "USERS"<br /><br /><br /><br /><br />SQL> /<br /><br />DATA_TYPE DAT DATA_LENGTH DATA_PRECISION DATA_SCALE DEFAULT_LENGTH<br />---------- --- ----------- -------------- ---------- --------------<br />NUMBER 22 38 0Coskan Gundogarhttps://www.blogger.com/profile/11570869033287689498noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-88794279579834789192009-08-03T21:16:00.142-04:002009-08-03T21:16:00.142-04:00@joel
Thanks for the link. Unfortunately I no lo...@joel<br /><br />Thanks for the link. Unfortunately I no longer have metalink access. I'll see if someone can pull it up for me though.<br /><br />chetoraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.com