DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Space Display on screen

  1. #1
    Join Date
    Sep 2000
    Posts
    77
    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

  2. #2
    Join Date
    Oct 2000
    Posts
    90
    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.

  3. #3
    Join Date
    Dec 2000
    Location
    Brazil / São Paulo
    Posts
    97
    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

  4. #4
    Join Date
    Sep 2000
    Posts
    77
    But it is not showing not even single space in case 1 mentioned above.
    Thanks

  5. #5
    Join Date
    Oct 2000
    Posts
    90
    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
  •  


Click Here to Expand Forum to Full Width