I want to find the length of a numeric datatype field in my table. How can I find it?

    Requires Free Membership to View

    Login

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

This was first published in January 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top