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;
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