Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    42

    Unanswered: Concatenation question...

    Oracle 8.1.7


    I have a query which returns two columns, basically a userAction column and a userName column. For some of the rows the userName column is NULL. Is there a way to concatenate a text string of "SystemUser" where the userName fields is empty?

    Thanks...

  2. #2
    Join Date
    Jul 2002
    Posts
    29

    Re: Concatenation question...

    Originally posted by errodr
    Oracle 8.1.7


    I have a query which returns two columns, basically a userAction column and a userName column. For some of the rows the userName column is NULL. Is there a way to concatenate a text string of "SystemUser" where the userName fields is empty?

    Thanks...
    SELECT ...., NVL(userName, 'SystemUser')
    FROM ...

    -- rajXesh
    All you need in this life is ignorance and confidence, and then success is sure.
    -- Mark Twain (1835 - 1910)

Posting Permissions

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