-
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
-
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
