function BeforeReport return boolean is
begiN
  
    IF :P_DEPT=10 THEN
    	:lp_DEPTNO:='WHERE DEPTNO=10';
    ELSIF :P_DEPT =20 THEN
    	:LP_DEPTNO:='WHERE DEPTNO=20';
    ELSE
    	:LP_DEPTNO:=NULL;
    	END IF;
  
  return (TRUE);
end;

order by 8 asc

select * 
from emp
where job = 'CLERK'
where deptno = 10         --> should be "and", not "where"
order by 8 asc

select * from emp &lp_DEPTNO

FUNCTION [color=red]Cf_empnoformula [/color]
RETURN NUMBER 
IS 
  v_empno NUMBER; 
BEGIN 
    :CP_ENAME := NULL; 

    SELECT mgr, 
           ename 
    INTO   v_empno, :CP_ENAME 
    FROM   emp 
    WHERE  empno = :EMPNO; 

    RETURN( v_empno ); 
EXCEPTION 
  WHEN no_data_found THEN 
             RETURN NULL; 
END; 

FUNCTION F_3formattrigger 
RETURN BOOLEAN 
IS 
BEGIN 
    -- Automatically Generated from Reports Builder. 
    /*if (:CP_ENAME = 'KING') 
    then 
      srw.set_text_color('r50g0b0'); 
    end if; */ 
    IF :CP_ENAME = 'CLARK' THEN 
      RETURN ( TRUE ); 
    ELSE 
      RETURN( FALSE ); 
    END IF; 
END; 

select * from emp &lp_DEPTNO 

select * from emp &lp_DEPTNO 

select * from emp==> order by 8 asc.

select * from emp &lp_DEPTNO 

select * from emp==> order by 8 asc.

select * from emp 10 order by 8 asc.

select * from emp==> 20 order by 8 asc.

function BeforeReport return boolean is
begiN
  
    IF :P_DEPT=10 THEN
    	:lp_DEPTNO:='WHERE DEPTNO=10';
    ELSIF :P_DEPT =20 THEN
    	:LP_DEPTNO:='WHERE DEPTNO=20';
    ELSE
    	:LP_DEPTNO:=NULL;
    	END IF;
  
  return (TRUE);
end;

function CF_EMPNOFormula return Number iS
V_EMPNO NUMBER;
begin
		:CP_ENAME:=NULL;
  
  SELECT MGR,ENAME 
  INTO  V_EMPNO,:CP_ENAME
  FROM EMP WHERE EMPNO=:EMPNO;
  RETURN(V_EMPNO);
EXCEPTION
	WHEN NO_DATA_FOUND THEN RETURN NULL;  
end;

function F_3FormatTrigger return boolean is
begin

  -- Automatically Generated from Reports Builder.
  /*if (:CP_ENAME = 'KING')
  then
    srw.set_text_color('r50g0b0');
  end if; */
  
  IF :CP_ENAME='CLARK' THEN
   return (TRUE);
  ELSE
  	RETURN(FALSE);
  	END IF;
end;

IF :P_DEPT=10 THEN
    	 :lp_DEPTNO:='WHERE DEPTNO=10'; -->[b]This one[/b]
      else
         ...
         ....