Definitely!
ops$jeffh@dev817> create table xyz (x varchar2(20));
Table created.
Elapsed: 00:00:00.07
ops$jeffh@dev817> insert into xyz (x ) values ('abc ');
1 row created.
Elapsed: 00:00:00.02
ops$jeffh@dev817> insert into xyz (x ) values ('def ');
1 row created.
Elapsed: 00:00:00.01
ops$jeffh@dev817> commit;
Commit complete.
Elapsed: 00:00:00.01
ops$jeffh@dev817> select '|' || x || '|' x
2 from xyz;
X
----------------------
|abc |
|def |
Elapsed: 00:00:00.01
ops$jeffh@dev817> spool off
Michael Peppler wrote:
>Are you *sure* that you get 'test ' back???
>
