-
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
Thanks
-
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.
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
http://www.directory.com.br
-
But it is not showing not even single space in case 1 mentioned above.
Thanks
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|