Finding length of numeric datatype field

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database internals How to find a dropped table? Removing carriage returns at the end of clob fields Problem with incoming parameter in dynamic SQL statement Reading WSID from back-end Making a select statement faster Select * from loc Difference between 9i and 10g OCP exams Concatenate values separated with commas How to free up more space for Oracle? Error after installation of 9i on Red Hat Linux Oracle database design and architecture How to determine your SQL database through needs analysis Breaking down the contenders in the SQL database market Diving deeper into the SQL database features The MySQL open source database in the enterprise What managers should consider when starting a database scaling project How to use V$SEGMENT_STATISTICS to find the most accessed Oracle table Can I install an Oracle client on Windows 7? How to use the Oracle Database Upgrade Assistant (DBUA) Can I specify Oracle column order in my database table? Can I have a single Oracle 11g RAC instance across multiple databases?

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary E. F. Codd  (SearchOracle.com) extent  (SearchOracle.com) flexfield  (SearchOracle.com) foreign key  (SearchOracle.com) multidimensional database  (SearchOracle.com) object-oriented database management system  (SearchOracle.com) quad tree  (SearchOracle.com) relational online analytical processing  (SearchOracle.com) row  (SearchOracle.com) splay tree  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

Here is an example; use the vsize function:

SQL> create table test (col1 number);

Table created.

SQL> insert into test values (123456789)
SQL> /

1 row created.

SQL> commit;

Commit complete.

SQL> select length(col1) from test
SQL> /

LENGTH(COL1)
------------
           9

SQL> select vsize(col1) from test;

VSIZE(COL1)
-----------
          6