Home » SQL & PL/SQL » SQL & PL/SQL » Re: Use result from function in a Anonymous Block
Re: Use result from function in a Anonymous Block [message #43] Mon, 07 January 2002 16:09
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
save script below in a file and run at sqlprompt.

set feed off
set serveroutput on
set define on
prompt enter something
accept n
prompt you entered &&n
declare
i number;
begin
i := fkt;
IF i = 0
THEN
dbms_output.put_line('Result = 0.');
ELSE
dbms_output.put_line('Result = 1.');
END IF;


end;
/

prompt enter one more number
accept r
prompt you entered : &&r
Previous Topic: EditPlus
Next Topic: delete previous data n load new
Goto Forum:
  


Current Time: Thu Mar 28 07:11:07 CDT 2024