oracle创建函数例子

create or replace function GETEXAMINEENAMEBYID(PARAM_ID NUMBER)
return VARCHAR2
is
EXANNAME VARCHAR2(50);
begin
SELECT NAME into EXANNAME FROM EXAMINEE WHERE ID=PARAM_ID;
return EXANNAME;

end;

http://wenku.baidu.com/link?url=SH7a38lwgzYAi8YVZaT0DCNB-PubhDD7UmmkTMvag7laYneUSfwD-uyot8OWTFrtIuP1GHmVRjygQS8CYq1uEN3t82qN_BKaGCmO6jMK6gC