Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unanswered: list output alig left

    Hi out there,
    I have a statement
    select t.name, sum(d.bytes/1024) from v$datafile d, v$tablespace t where t.ts# = d.ts# group by t.name;

    The different numbers I get as a result are in the middle of the spoolfile, and I want to have it align left, that the numbers start at the first place of the text row. Can you help me?
    Regards
    Eckhard

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    select t.name, to_char(sum(d.bytes/1024)) "Sum Of Bytes" from v$datafile d, v$tablespace t
    where t.ts# = d.ts# group by t.name;

    HTH
    Gregg

  3. #3
    Join Date
    Mar 2004
    Posts
    2

    thanx alot

    Thanx a lot,
    you helped me very very much
    regards
    eckhard

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •