Hi
The answer is 1...
see the follo..
SQL>CREATE TABLE PRAS(C1 VARCHAR2(5));
Table created.
SQL> INSERT INTO PRAS VALUES(' ');
1 row created.
SQL> SELECT * FROM PRAS;
C1
-----
SQL> SELECT LENGTH(C1) FROM PRAS;
LENGTH(C1)
----------
1
hOPE THIS WILL HELP U...
Pras




Reply With Quote