length of a null value

[rswamin]

hi friends

what is the out put for the following query.

select length(col1) from my_table.

where col1 is a varchar2 column of the table and contains ' '( a blank space.)
i found the answer to be null, but in an exam it is given as 1. is it correct.
can any one explain this.

regards
swaminathan

[pras]

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