create or replace function v_emp(v_str number :=null)
return number
AS
v_value number(20);
BEGIN
select id into v_value from emp where id=v_str;
return v_value;
commit;
END;
å¦å¤ï¼ä½ è¿ä¸ªå½æ°æ²¡ä»ä¹æä¹åï¼è¾å
¥ä¸ä¸ªv_strçåæ°ï¼è¿åå¼ç»äºv_valueï¼è¿æ¯è¿ä¸ªidå¼ã
æä¸ä¼æå½æ°ãæidè¿ä¸ªå¼ï¼æå°±ç¨è¿ä¸ªç´æ¥è¿åidè¿ä¸ªå¼è¡ä¸ï¼
create or replace function v_emp(v_str number :=null)
return number
AS
v_value number(20);
BEGIN
select id into v_value from emp where id=v_str;
return v_value;
END;
æè¿ä¸ªå½æ°ï¼å°±æ¯ä¸ºäºè·åidè¿ä¸ªå¼ï¼ç¶åæåç»å®åæä½
emp表å 容è¿åå段åæªå¾
追é®plsql左侧çæ ï¼æ¾å°functionï¼æ¾å°v_empï¼ä½ ççä¸è¾¹å¸¦ä¸å¸¦ä¸ä¸ªçº¢å❌
追é®æ²¡éï¼æè¿ä¸ªå建å½æ°çè¿ç¨ï¼æ¯å¯¹çåï¼å¨plsqlä¸ä¸åæ£å¸¸ï¼æå°ç³»ç»ä¸è°ç¨è¿ä¸ªå½æ°å°±ä¸è¡äºï¼å°±æ¥æ æããã555ããã
追çè°ç¨æ¹å¼æ¯ä»ä¹ï¼åä¸æ¥çç
追é®Select Substr(æ°ç¼ç , 1, Instr(æ°ç¼ç , ',') - 1) As ä¸çº§ç , Substr(æ°ç¼ç , Instr(æ°ç¼ç , ',') + 1) As æ¬çº§ç ,Length(Substr(æ°ç¼ç , Instr(æ°ç¼ç , ',') + 1)) As æ¬çº§é¿ From (Select f_è¯çåç±»ç®å½_Newcode('åé-åç±»ç®å½ID',0) As æ°ç¼ç From Dual)
追ççç§ä¿¡ï¼qä¸è¯´ï¼é®æ¥é®å»å¥½è´¹å²