Hello,
Database: Oracle 11g r2
1* create table t ( t varchar2(30))
SQL> /
Table created.
SQL> insert into t values('
2 Answer: a
3 ');
1 row created.
SQL> select * from t;
T
------------------------------
Answer: a
1* select rownum, ltrim(rtrim(trim(t))) t from t
SQL> /
ROWNUM T
---------- ------------------------------
1
Answer: a
I want trim off the blank in the column when selecting the record.
Any help would be greatly appreciated.
Is there anything like to replace
Thanks,