Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Table size estimates and column sizes

Re: Table size estimates and column sizes

From: Mserban <mserban_at_aol.com>
Date: 1997/04/27
Message-ID: <19970427055001.BAA12348@ladder01.news.aol.com>#1/1 








For Question 1.: Use the VSIZE(column_name) function, as in: SELECT
VSIZE(column_name) FROM table_name. VSIZE will return the number of bytes
used internally (by ORACLE) to store the values in that column.



I hope this helps.




Michael Serbanescu


Sr. Consultant, MIACO Corporation
Received on Sun Apr 27 1997 - 00:00:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US