需要将日期转换下字符串就可以输出了已写入文件 afiedt.buf 1 create or replace procedure getCurrnetDate(outdate out varchar2) 2 as 3 begin 4 select to_char(current_date) into outdate from dual; 5 commit; 6* end; SQL> /过程已创建。SQL> var test varchar2(50); SQL> exec getCurrnetDate(:test)PL/SQL 过程已成功完成。SQL> print test;TEST -------------------------------------------------------------------------------- 25-7月 -06
用pl/sql developer吧,
新建test script就行
2 as
3 begin
4 select to_char(current_date) into outdate from dual;
5 commit;
6* end;
SQL> /过程已创建。SQL> var test varchar2(50);
SQL> exec getCurrnetDate(:test)PL/SQL 过程已成功完成。SQL> print test;TEST
--------------------------------------------------------------------------------
25-7月 -06
SQL> exec getCurrnetDate(:currentDate);PL/SQL procedure successfully completed
currentDate
---------
2006-7-25 13:26:18