Re: hopefully easy SQL question

You could try a refcursor:

variable rc_myprint

begin

    ... your code ...

    if mycondition then

        open :rc_myprint for select cola,colb,colc from mytab;

    else

        open :rc_myprint for select colb,colc from mytab;

    end if;

end;

/
ttitle etc...

print rc_myprint

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!