C:\my.sql:
CREATE OR REPLACE FUNCTION F_Week
return varchar2 is
s_WeekDay varchar2(20);
begin
select to_char(sysdate,'day') into s_weekday from dual;
return (s_WeekDay);
end f_Week;
/sqlplus:
sql:>@c:\mysql
CREATE OR REPLACE FUNCTION F_Week
return varchar2 is
s_WeekDay varchar2(20);
begin
select to_char(sysdate,'day') into s_weekday from dual;
return (s_WeekDay);
end f_Week;
/sqlplus:
sql:>@c:\mysql
然后在sqlplus 里面@1.txt就ok了