Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is column type 13 ?

thrupassFeb 16 2018 — edited Feb 16 2018

Hi, Experts

Env

=========

Oracle 11.2.0.4

        select dump(end_interval_time+0)

              ,dump(end_interval_time) 

          from  dba_hist_snapshot

          where rownum < 2; 

DUMP(END_INTERVAL_TIME+0)     DUMP(END_INTERVAL_TIME)

-----------------------------------------------   --------------------------------------------------------------------

Typ=13 Len=8: 7,226,2,9,5,0,17,0      Typ=180 Len=11: 120,118,2,9,6,1,18,48,224,53,0

Typ=182 is timestamp

Typ=13 ... What is it ?

https://docs.oracle.com/cd/E11882_01/server.112/e41085/sqlqr06002.htm#SQLQR959

There is no explanation for 13 data type in oracle manual.

What is it ?

Thanks in advance

This post has been answered by L. Fernigrini on Feb 16 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2018
Added on Feb 16 2018
3 comments
2,509 views