Re: datatype storage questions

In article <3psnlm$3ip_at_hpaneqb4.an.hp.com> markv_at_news.an.hp.com (Mark Vantzelfde) writes:
>1. Can someone confirm that 7 bytes is the amount of storage for
> the date datatype? Is there a way to look in the database to
> get some firsthand confirmation?
>
>2. What does the value from select avg(lengthb(col)), where col
> is of type numeric or date, reveal? Is the value returned
> the avg storage in bytes or the average display length or
> something altogether meaningless?

1. Ref: "ORACLE 7 SERVER ADMINISTRATOR'S GUIDE" The storage of a DATE field is 7 bytes.
2. Ref: "ORACLE 7 SERVER SQL LANGUAGE REFERENCE MANUAL" LENGTH (char) is length in Characters. LENGTHB (char) is length in Bytes. Note: If using a single byte system (and who in N.A. isn't) LENGTHB is the same as LENGTH. To answer your question, it's display length.

James Richard (JRICHARD_at_TUNS.CA)
"No Assembler Required!" Received on Wed May 24 1995 - 00:00:00 CEST