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
Related Q&A from Mike Ault, Senior Oracle Consultant, Burleson Consulting
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists.continue reading
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to...continue reading
I'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.