Printable View
I am trying to display three spaces on sqlplus screen and it is not displaying in case 1 and it is displaying in case2. What is the reason for not displaying in case 1.
Windows NT Oracle 81
CASE : 1
-----------
1 declare
2 a varchar2(3) := ' ';
3 begin
4 dbms_output.put_line(a||'testing');
5* end;
SQL> /
testing
PL/SQL procedure successfully completed.
CASE : 2
-----------
1 declare
2 a varchar2(3) := ' ';
3 begin
4 dbms_output.put_line('testing'||a||'testing');
5* end;
SQL> /
testing testing
I can just say this is something peculiar to SQL*PLUS. If you run the same command in TOAD and read the DBMS output, it had the 3 spaces. Sorry to have not been more use, but the information may help you.
disagree, if you initialize variable with one space, only one space show in screen.
But it is not showing not even single space in case 1 mentioned above.
Durga,
As I said and I agree with you, in SQL*Plus, you definately don't see a space, maybe it is a version problem, I am running 8.1.6, maybe Marcio is running a different version or not running SQL*Plus.