[B! plsql] kimura_m_29ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kimura_m_29 id:kimura_m_29

plsqlã«é–¢ã™ã‚‹kimura_m_29ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ã‚³ãƒ¡ãƒ³ãƒˆã‚’æ›¸ãã™ãŽã‚‹ã¨PLï¼SQLãŒé…ããªã‚‹ï¼Ÿ - builder by ZDNet Japan
ã‚¨ãƒƒã‚¸å¸‚å ´ã®æ´»æ€§åŒ–ã¸ é«˜ã¾ã‚‹IoTã‚’ä¸å¿ƒã¨ã—ãŸã‚¨ãƒƒã‚¸åˆ†é‡Žã¸ã®æœŸå¾… OSSæ´»ç”¨ãŒæ–°ã—ã„æ™‚ä»£ã®ãƒ“ã‚¸ãƒã‚¹ã‚’æ‹“ã æœ¬å½“ã®ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ã§ãã¦ã„ã¾ã™ã‹ï¼Ÿ ãƒ‡ãƒ¼ã‚¿ãƒ‰ãƒªãƒ–ãƒ³ãŒã‚ãŸã‚Šã¾ãˆã¨è¨€ã‚ã‚Œã‚‹ä»Šã‚ã‚‰ãŸã‚ã¦è€ƒãˆãŸã„ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ã®ã‚ã‚Šã‹ãŸ å‹ã¤ãŸã‚ã®ã‚¯ãƒ©ã‚¦ãƒ‰æ´»ç”¨è¡“ New Value on Azure ãƒ“ã‚¸ãƒã‚¹ã‚’æ¬¡ã®ã‚¹ãƒ†ãƒ¼ã‚¸ã¸ï¼ ãƒªãƒ¢ãƒ¼ãƒˆãƒ¯ãƒ¼ã‚¯ã‚’æˆåŠŸã•ã›ã‚‹æ–¹æ³• å¿…é ˆã¨ãªã‚‹ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚’ã©ã†å¼·åŒ–ã™ã‚‹ã‹ å¿…è¦ãªå¯¾ç–5ã¤ã‚’ç´¹ä»‹ ãƒ‡ãƒ¼ã‚¿ãƒ‰ãƒªãƒ–ãƒ³ã«è¶³ã‚Šãªã„ã‚‚ã® DOMO Japan å·å´Žæ°ã«èžã ãƒ‡ãƒ¼ã‚¿æ´»ç”¨èƒ½åŠ›ã®å‘ä¸Šã«å¿…è¦ãªã“ã¨ ãƒ“ã‚¸ãƒã‚¹ã®ãŸã‚ã®ãƒ‡ãƒ¼ã‚¿åŸºç›¤æ§‹ç¯‰ DXæ™‚ä»£ã®ä¼æ¥æˆé•·ã¯ãƒ‡ãƒ¼ã‚¿æ´»ç”¨ãŒéµ æ–°ãŸãªå±•é–‹ã‚’å¾ŒæŠ¼ã—ã™ã‚‹SQL Serveræ´»ç”¨ æ¥½å¤©ã‚¨ã‚³ã‚·ã‚¹ãƒ†ãƒ ã¨ã®ã‚·ãƒŠã‚¸ãƒ¼ã‚’å‰µå‡º ã‚¹ã‚¿ã‚¸ã‚¢ãƒ ã‚„çµŒæ¸ˆåœã‚’ç”Ÿã‹ã—ãŸå®Ÿè¨¼å®Ÿé¨“ã‚‚ æ¥½å¤©ãƒ¢ãƒã‚¤ãƒ«æµ5Gå…±å‰µãƒ—ãƒã‚°ãƒ©ãƒ ã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¢ã‚ãªã„ï¼ ã‚µã‚¤ãƒãƒ¼ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ãƒˆã«èžãé«˜å¯ç”¨æ€§ã®å®Ÿç¾ ãã“ã«
kimura_m_29 2008/02/24
æ¤œè¨¼è¨˜äº‹ã€‚çµè«–ï¼šã€Žã†ã‚ã•ã¯ã†ãã§ã‚ã£ãŸã¨è€ƒãˆã¦ã‚ˆã„ã ã‚ã†ã€‚ã€

plsql
ãƒªãƒ³ã‚¯
ï¼¯ï¼²ï¼¡ï¼£ï¼¬ï¼¥ï¼ã‚ªãƒ©ã‚¯ãƒ«ï¼°ï¼¬ï¼ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆã‚«ãƒ¼ã‚½ãƒ«ï¼‰
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ã€€ãƒªãƒ³ã‚¯ ï¼¤ï¼¢ã‹ã‚‰ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’ã€å‹•çš„SQLã§ã‚«ãƒ¼ã‚½ãƒ«ã‚’ä½¿ç”¨ã—ã¦è¤‡æ•°ä»¶å–å¾—ã—ã¾ã™ã€‚ ä¾‹ï¼‘ï¼‰ã€€è¡¨ã€Œempã€ã‚’å‹•çš„SQLã§ã‚«ãƒ¼ã‚½ãƒ«ã‚’ä½¿ç”¨ã—ã¦æ¤œç´¢ã—ã¾ã™ã€‚ declare -- ã‚«ãƒ¼ã‚½ãƒ«å¤‰æ•°ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆå®šç¾© type emp_cur_type is ref cursor; -- ã‚«ãƒ¼ã‚½ãƒ«å¤‰æ•°å®šç¾© emp_sur emp_cur_type; v_dept_id emp.dept_id%type; wk_emp_id emp.emp_id%type; wk_dept_id emp.dept_id%type; wk_name emp.name%type; begin v_dept_id := 'D01'; -- ã‚«ãƒ¼ã‚½ãƒ«å¤‰æ•°ã‚ªãƒ¼ãƒ—ãƒ³ã€‚ã“ã“ã§ã€ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã«å‹•çš„ã«å¤‰æ›´ã•ã‚Œã‚‹ -- æ¤œç´¢æ¡ä»¶ã€Œdept_idã€ã‚’æŒ‡å®šã—ã¦ã„ã¾ã™ã€‚ open emp_sur for 'select emp_id,de
kimura_m_29 2007/08/12
ã€Žå‹•çš„SQLã§ã‚«ãƒ¼ã‚½ãƒ«ã‚’ä½¿ç”¨ã—ã¦ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¤‡æ•°SELECTã™ã‚‹ï¼ˆCURSORï¼‰ã€ã‚ªãƒ¼ãƒ—ãƒ³æ™‚ã«selectæ–‡ãƒ»ãƒã‚¤ãƒ³ãƒ‰å¤‰æ•°ã«ä»£å…¥ã™ã‚‹å¤‰æ•°ï¼ˆå‹•çš„ã«å¤‰æ›´å¯ï¼‰ã‚’å®šç¾©ã€€ãƒ«ãƒ¼ãƒ—å†…ã§ãƒ•ã‚§ãƒƒãƒã€€é…åˆ—åž‹ã«ã½ã‚“ã½ã‚“å…¥ã‚Œã‚‰ã‚Œã‚‹

plsql
ãƒªãƒ³ã‚¯
OTN Japan - 404 Error
URLãŒä¸‹è¨˜ã®é€šã‚Šå¤‰æ›´ã«ãªã‚Šã¾ã—ãŸã€‚ ãŠæ‰‹æ•°ã§ã™ãŒãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ãªã©ã®å¤‰æ›´ã‚’ãŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚ 10ç§’å¾Œã€è‡ªå‹•çš„ã«ã‚¸ãƒ£ãƒ³ãƒ—ã—ã¾ã™ã®ã§ã—ã°ã‚‰ããŠå¾…ã¡ãã ã•ã„ã€‚ â€»ã‚¸ãƒ£ãƒ³ãƒ—ã—ãªã„å ´åˆã¯ã€ä¸‹è¨˜ã®URLã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ http://www.oracle.com/tech network/jp/index.html
kimura_m_29 2007/08/12
plsql

tips
ãƒªãƒ³ã‚¯
DBMS_OUTPUT ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracleã‚’ãƒžã‚¹ã‚¿ãƒ¼ã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
DBMS_OUTPUT ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ä½¿ç”¨ PL/SQL ã«ãŠã„ã¦ DBMS_OUTPUT ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¯ãƒ‡ãƒãƒƒã‚°ç›®çš„ãªã©ã§æ¨™æº–å‡ºåŠ›ã«ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’è¡¨ç¤ºã™ã‚‹ãŸã‚ã®ãŠãã‚‰ãå”¯ä¸€ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§é–‹ç™ºä½œæ¥ä¸ã«ã¯åˆ©ç”¨çŽ‡ãƒŠãƒ³ãƒãƒ¼ãƒ¯ãƒ³ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã‚ã‚‹ã€‚ãã®å¤šãã¯é–‹ç™ºãƒ•ã‚§ãƒ¼ã‚ºãŒçµ‚äº†ã™ã‚‹ã¨å‘¼ã³å‡ºã—ã®ã‚ªãƒ¼ãƒãƒ˜ãƒƒãƒ‰ã‚’ãªãã™ç‚ºã«ã‚³ãƒ¡ãƒ³ãƒˆåŒ–ã•ã‚Œã‚‹ã‹ç„¡åŠ¹åŒ–ã•ã‚Œã‚‹ã€‚ ä½¿ç”¨æ–¹æ³•ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ç°¡å˜ã§ã‚ã‚‹ã€‚ BEGIN FOR i in 1..7 LOOP FOR j IN 1..9 LOOP DBMS_OUTPUT.PUT('-'); END LOOP; DBMS_OUTPUT.PUT('+'); END LOOP; DBMS_OUTPUT.NEW_LINE; DBMS_OUTPUT.PUT_LINE('12345678901234567890'); END; / å®Ÿè¡Œçµæžœ ---------+---------+------
kimura_m_29 2007/08/12
ã€ŽDBMS_OUTPUT ä½¿ç”¨æ™‚ã®æ³¨æ„ã€ã™ããƒãƒƒãƒ•ã‚¡è¶…éŽã§ã‚¨ãƒ©ãƒ¼ã«ãªã‚‹

plsql
ãƒªãƒ³ã‚¯
Oracle PL/SQL ç·¨16 - ãƒ‡ãƒãƒƒã‚°ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸è¡¨ç¤ºã€dbms_output.put_line - SAK Streets
Oracle PL/SQL ç·¨16 - ãƒ‡ãƒãƒƒã‚°ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸è¡¨ç¤ºã€dbms_output.put_line â– DBMS_OUTPUT ãƒ»DBMS_OUTPUT ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¯ã€SQL*Plus ã«ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ PL/SQL ãƒ—ãƒãƒƒã‚¯ã‚„ã‚¹ãƒˆã‚¢ãƒ‰ã®ãƒ‡ãƒãƒƒã‚°ã«ä½¿ç”¨ã™ã‚‹ã¨ä¾¿åˆ©ã§ã™ã€‚ ä½†ã—ã€å‡¦ç†çµŒéŽã‚’ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«ç›£è¦–ã™ã‚‹ã‚ˆã†ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸å‡ºåŠ›ã«ã¯ä½¿ç”¨ã§ ãã¾ã›ã‚“ã€‚å‡ºåŠ›ãƒãƒƒãƒ•ã‚¡ã®è¡¨ç¤ºã¯ã€PL/SQL ãŒçµ‚äº†ã—ãŸæ®µéšŽã§ã¾ã¨ã‚ã¦è¡Œã‚ ã‚Œã¾ã™ã€‚é€”ä¸ã§å³æ™‚è¡¨ç¤ºã™ã‚‹å‘½ä»¤ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ â– enable ãƒ»put_line ç‰ã‚’æœ‰åŠ¹ã«ã—ã¾ã™ã€‚(æ—¢å®šå€¤ã¯ enable ã§ã™ã€‚) SQL*Plus ã§ set serveroutput on ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã—ã¦ã„ãªã„å ´åˆã€ãƒãƒƒãƒ• ã‚¡ã«ã¯å‡ºåŠ›ã•ã‚Œã¾ã™ãŒã€è¡¨ç¤ºã¯ã•ã‚Œã¾ã›ã‚“ã€‚ dbms_output.enable(size); |_ ãƒãƒƒãƒ•ã‚¡ã‚µã‚¤ã‚º çœç•¥å€¤ã¯ 2000
kimura_m_29 2007/08/12
set serveroutput on ã‚³ãƒžãƒ³ãƒ‰ã‚ã™ã‚Œãªã„ã‚ˆã†ã«ã™ã‚‹

plsql

sql*plus
ãƒªãƒ³ã‚¯
ayumu-baby.com
This domain may be for sale!
kimura_m_29 2007/08/05
ã‚³ãƒ¬ã‚¯ã‚·ãƒ§ãƒ³ãƒ¡ã‚½ãƒƒãƒ‰ä¸€è¦§

plsql
ãƒªãƒ³ã‚¯
åŒºåˆ†ã®å…ˆé è¡Œã¯ï¼Ÿï½œã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢é–‹ç™ºéƒ¨ï¼ˆã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ»ã‚·ã‚¹ãƒ†ãƒ è¨è¨ˆã€€æ ªå¼ä¼šç¤¾ã‚¢ã‚¤ãƒãƒ™ãƒƒã‚¯ã‚¹ï½œæ±äº¬éƒ½æ–°å®¿åŒºï¼‰
SQLã§ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹å ´åˆã«ã€ ã€Œâ–²â–²ã®åŒºåˆ†ã®å…ˆé ã§ã¯æ˜Žç´°ã®é …ç›®ã‚’å¤‰ãˆãŸã„ã€ ã¨ã„ã†å ´é¢ã£ã¦ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ ç°¡å˜ã«å‡ºæ¥ãã†ã ã‘ã©ï½¥ï½¥ï½¥ã•ã¦ã€ã©ã†ã—ã‚ˆã†ã€‚ SQLã§ï¼Ÿã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ï¼Ÿã€Œã‚ˆã—ã€PL/SQLã§ã‚„ã£ã¦ã—ã¾ãŠã†ã€‚ã€ ãã‚“ãªæ™‚ã¯é †ä½ç‰ã‚’ä»˜ã‘ã‚‹å ´åˆã«ä½¿ç”¨ã™ã‚‹ã€€ROW_NUMBERã€€ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ãã—ã¦ã€€PARTITION BYã€€ã§åŒºåˆ‡ã‚Šã¾ã™ã€‚ ä½¿ç”¨ä¾‹ã¨ã—ã¦ã¯ä»¥ä¸‹ã®ã‚ˆã«ãªã‚Šã¾ã™ã€‚ ROW_NUMBER() OVER (PARTITION BY â–²â–² ORDER BY â—â—) â€»ã€€â–²â–²ãƒ»â—â—ã¯é …ç›® ä¸Šè¨˜ã§ã¯ã€â—â—ã§ä¸¦ã³æ›¿ãˆ1ã‹ã‚‰é †ã«é€£ç•ªã‚’æŒ¯ã€ â–²â–²ãŒå¤‰ã‚ã£ãŸã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ã¾ãŸ1ã‹ã‚‰é€£ç•ªã‚’æŒ¯ã‚Šã¾ã™ã€‚ ã“ã‚Œã§ã€ã©ã®æ˜Žç´°ãŒåŒºåˆ†ã®ä½•ç•ªç›®ã®æ˜Žç´°ã‹ãŒåˆ¤åˆ¥ã§ãã¾ã™ã€‚ ã¨ã„ã†ã“ã¨ã¯ã“ã‚ŒãŒ1ã®å ´åˆã¯å…ˆé ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ã‚ã¨ã¯åˆ¤åˆ¥å¼ã§åˆ¤åˆ¥ã—ã¦ã‚„ã‚Œã°ã‚ˆã„ã‚ã‘ã§ã™ãŒï½¥ï½¥ï½¥ã—ã‹ãƒ¼ã—ã€ 8iä»¥é™ã§ä¸€å¿œä½¿ç”¨
kimura_m_29 2007/08/05
order byã—ã¦ã‹ã‚‰rownumã€ã‚’1è¡Œã§ã§ãã‚‹ROW_NUMBER()ã®ä½¿ã„æ–¹ã€€çµæžœã‚»ãƒƒãƒˆã®ä½•ç•ªç›®ã®è¡Œã€ã¨ã„ã†æŒ‡å®šãŒã§ãã‚‹

plsql
ãƒªãƒ³ã‚¯
ã‚¹ãƒˆã‚¢ãƒ‰ã‚’SQL*PLUSã§å®Ÿè¡Œã—ãŸã„ã€‚ - Oracle è§£æ±ºæ¸ˆã¿| ã€OKWAVEã€‘
å›°ã£ã¦ã¾ã™ 2006-10-31 09:28:35 è³ªå•No.2508527 é–²è¦§æ•°693 ã‚ã‚ŠãŒã¨ã†æ•°2 æ°—ã«ãªã‚‹æ•°1 å›žç”æ•°1 ã‚³ãƒ¡ãƒ³ãƒˆæ•°0 ã“ã‚“ã«ã¡ã‚ã€‚ ã„ã¾ORACLE10gã®PLSQLã§ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ã‚¸ãƒ£ã‚’ä½œæˆã—ã¦ã„ã¾ã™ã€‚ CREATE OR REPLACE PROCEDURE procXXXXXXXX ( oCNT1 OUT NUMBER , oCNT2 OUT NUMBER , nRET OUT NUMBER ) IS ï½ž ã¨ã„ã†ã‚‚ã®ã§ã™ãŒï¼Œã“ã‚Œã‚’SQL*PLUSã§ãƒ†ã‚¹ãƒˆã¨ã—ã¦å®Ÿè¡Œã—ãŸã„ã®ã§ã™ãŒï¼Œå¤‰æ•°å®šç¾©ãªã©ã©ã†ã™ã‚Œã°è‰¯ã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ æ•™ãˆã¦ãã ã•ã„ã€‚ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚
kimura_m_29 2007/08/05
SQL*PLUSä¸Šã§ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’å®Ÿè¡Œã™ã‚‹æ–¹æ³•ã€€å¼•æ•°ã¨ã—ã¦æ¸¡ã™å¤‰æ•°ã‚’å…ˆã«å®£è¨€ã—ã¦ãŠãã€€å¤‰æ•°ã¯å¤‰æ•°åã®å‰ã«ã€Ž:ã€ã‚’ä»˜ã‘ã‚‹ã“ã¨

plsql
ãƒªãƒ³ã‚¯
ä½ç½®è¡¨è¨˜æ³•ã¨åå‰è¡¨è¨˜æ³• - ã‚ªãƒ©ã‚¯ãƒ«ãƒ»Oracle PL/SQL å…¥é–€
ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®å®Ÿè¡Œï¼ˆä½ç½®è¡¨è¨˜æ³•ã¨åå‰è¡¨è¨˜æ³•ï¼‰ PL/SQL ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ã® ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã€ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã€ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ ãªã©ã®ã‚µãƒ–ãƒ—ãƒã‚°ãƒ©ãƒ ã®å‘¼ã³å‡ºã—ã«ã¯ä½ç½®è¡¨è¨˜æ³•ã€åå‰è¡¨è¨˜æ³•ã€ ãŠã‚ˆã³ã€ä¸¡æ–¹ã‚’ä½µç”¨ã—ãŸãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®è¡¨è¨˜ã‚’ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ ä½ç½®è¡¨è¨˜æ³• (Positional Notation) å¤šãã®é–‹ç™ºè¨€èªžã§ä½ç½®è¡¨è¨˜æ³•ãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚ ã»ã¨ã‚“ã©ã® ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã‚„ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã®å‘¼ã³å‡ºã— ã§ã¯ä½ç½®è¡¨è¨˜æ³•ãŒé©ã—ã¦ã„ã‚‹ã¨æ€ã‚ã‚Œã‚‹ã€‚ â€» Oracle 10g ã¾ã§ã¯ SQL ã®å‘¼ã³å‡ºã—ã¯ä½ç½®è¡¨è¨˜æ³•ã®ã¿ã«é™å®šã•ã‚Œã¦ã„ãŸãŒ Oracle 11g ã‹ã‚‰ã¯ SQL ã®å‘¼ã³å‡ºã—ã«ã‚‚ä½ç½®è¡¨è¨˜æ³•ãŠã‚ˆã³ä¸¡æ–¹ã‚’ä½µç”¨ã—ãŸæ··åˆè¡¨è¨˜ã‚‚å¯èƒ½ã€‚ ä½ç½®è¡¨è¨˜æ³•ã«ã‚ˆã‚‹è¨˜è¿°ä¾‹ PRODUCT(P_NUM1 IN NUMBER,P_NUM2 IN NUMBER) ã‚’å‘¼ã³å‡ºã™ä¾‹ x := PRODUCT(1,2) åå‰è¡¨
kimura_m_29 2007/08/05
PL/SQLå†…ã§ã‚µãƒ–ãƒ—ãƒã‚°ãƒ©ãƒ ï¼ˆãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã¨ã‹ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨ã‹ï¼‰ã‚’å‘¼ã³å‡ºã™æ–¹æ³•

plsql
ãƒªãƒ³ã‚¯
1