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.
The answer is 1...
see the follo..
SQL>CREATE TABLE PRAS(C1 VARCHAR2(5));
SQL> INSERT INTO PRAS VALUES(' ');
1 row created.
SQL> SELECT * FROM PRAS;
SQL> SELECT LENGTH(C1) FROM PRAS;
hOPE THIS WILL HELP U...
Click Here to Expand Forum to Full Width