Results 1 to 7 of 7

Thread: Oracle Report

  1. #1
    Join Date
    Jan 2004
    Posts
    153

    Unanswered: Oracle Report

    Hi All,

    A report which display three field's information ( First Name, Middle Name and Last Name ) in three like bellow :


    Suraj
    Kumar
    Prasad

    Now my query is, while displaying a name which consist only First and Last name the middle part is comming blank like bellow :

    Zachary

    Herness

    But I want to print this like :

    Zachry
    Herness

    Any one please help me what I have to do for that ?


    Thanks

    JD

  2. #2
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    Hi

    Use DECODE FUNCTION to Ignore the MiddleName according to the DECODE RESULT

    DECODE(MIDDLENAME,'',0)

    If DECODE RETURNS 0 Then Ignore that particular FIELD.

  3. #3
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    Hi

    If the MIDDLENAME contains NULL value u may use NVL Function.

    try it & let me know!

  4. #4
    Join Date
    Jan 2004
    Posts
    153

    Re: Oracle Report

    Thanks, I got the solution.

  5. #5
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    HI

    how let me know?

  6. #6
    Join Date
    Jan 2004
    Posts
    153

    Re: Oracle Report

    You need to write a format trigger for the middle name field :

    if :m_name is null then

    return(false);
    end if;
    return(true);

  7. #7
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    thanx

Posting Permissions

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