Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    153

    Unanswered: Developer Report 6.0 format

    In Developer Report 6.0 I would like to print a data like bellow :

    REGISTER (field of the table, varchar2(5) )
    ------------
    041
    053
    287
    079
    ..
    ..
    ..

    If I do not want to use SUBSTR in select statement, then is there any other way to get format like above.

    Thanks

    JD

  2. #2
    Join Date
    Jan 2004
    Posts
    492

    Re: Developer Report 6.0 format

    Originally posted by jayanta_deb
    In Developer Report 6.0 I would like to print a data like bellow :

    REGISTER (field of the table, varchar2(5) )
    ------------
    041
    053
    287
    079
    ..
    ..
    ..

    If I do not want to use SUBSTR in select statement, then is there any other way to get format like above.

    Thanks

    JD

    If you always want the first 3 digits, why not use SUBSTR? And what is after the first 3 digits that you dont want to exclude?
    Last edited by ss659; 02-04-04 at 10:23.

Posting Permissions

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