Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    92

    Unanswered: concatenating with oracle output

    Hi All,

    i have a question regarding the oracle database.
    i have a table say table1

    select a,b,c from table1;

    i have d=10 and e=5

    i have to append the values of d and e to the output of the above query

    the output might look like this; a b c 10 5

    can anyone please suggest me how do I do it in oracle

    thanks
    mark

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    try:
    PHP Code:
    Select a,b,c10 d5 e
      From table1



    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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