ããŒã¿ç®¡çãšåŠçã«ãããAIã®é©åœãçŸå®ã®ãã®ãšãªã£ãŠããŸãããChatGPTã®ãããªå é²çãªãã¯ãããžãŒãšPL/SQLã®èåã¯ãŸã äžè¬çã§ã¯ãããŸããããã®ããŒãã§ã¯ãChatGPTãšPL/SQLãçµ±åããŠããžãã¹ããã»ã¹ãèªååããããŒã¿æäœãå¹çåããæ¹æ³ã玹ä»ããŸããå¹æçãªããŒã¿ããŒã¹æäœã®èªååããã»ãã¥ãªãã£ç¶æãŸã§ãPL/SQLã掻çšããChatGPTã®å®è£ äŸãšèŠç¹ãæèŠããªãããããžãã¹ããŒãœã³ãçŽé¢ãã課é¡ã®è§£æ±ºçãèå¯ããŸãã
1. ChatGPTãšPL/SQLã®åºæ¬
ããã°ã©ãã³ã°ãšããŒã¿ããŒã¹ç®¡çã¯ä»æ¥ã®ãã¯ãããžãŒå¯ãã äžçã§äžå¯æ¬ ãªã¹ãã«ã»ãããšãªã£ãŠããŸãããã®èšäºã§ã¯ã人工ç¥èœã®åéã§æ³šç®ãããChatGPTãšãããŒã¿ããŒã¹èšèªã§ããPL/SQLã«ã€ããŠæãäžããŠãããŸãã
ChatGPTã¯ãè€éãªäŒè©±ãšå¯Ÿè©±ãå¯èœãªAIã§ãå¹ åºãããŒãã«ããã質åã«å¯ŸããŠäººéã®ãããªã¬ã¹ãã³ã¹ãæäŸããŸããäžæ¹ãPL/SQLã¯OracleããŒã¿ããŒã¹ã§äœ¿çšããã匷åãªããã°ã©ãã³ã°æ¡åŒµèšèªã§ãããã®äºã€ãçµã¿åãããã°ãããŒã¿ããŒã¹é§ååã®ã¢ããªã±ãŒã·ã§ã³ãšå¯Ÿè©±ãããã«é²åããŸãã
è·æ¥ã®å¹ ãåºãããšåæã«ãããžãã¹ã®åé¡è§£æ±ºã«ã圹ç«ã€ãã®ã¹ãã«ã»ããã¯ãéçºè ãããŒã¿ããŒã¹ç®¡çè ã«ãšã£ãŠæ¥µããŠäŸ¡å€ããããŸãã
1.1 ChatGPTã®æŠèŠãšæè¡çç¹åŸŽ
ChatGPTã¯OpenAIã«ãã£ãŠéçºããããæå 端ã®èªç¶èšèªåŠçã¢ãã«ã§ãããã®ã¢ãã«ã¯ã深局åŠç¿ãå©çšããŠå€§éã®ããã¹ãããŒã¿ããèšèªãã¿ãŒã³ãåŠã³ããããå ã«èªç¶ã§æµãããããªããã¹ããçæããèœåãæã£ãŠããŸãã
ChatGPTã¯ããŠãŒã¶ãå ¥åããããã³ããã«å¿ããŠã質åã«åçããããããã¹ããäœæããããã³ãŒãã®ãµã³ãã«ãçæãããããããšãã§ããŸãããŸããè±å¯ãªã³ã³ããã¹ããç解ãããã³ãã€ã³ãã§é¢é£æ§ã®ããæ å ±ãæäŸããèœåã«ãåªããŠããŸãã
ããã«ãChatGPTã¯ã€ã³ã¿ã©ã¯ãã£ããªæ©èœãåããŠãããé£ç¶ããäŒè©±ã®æµãã®äžã§äžè²«æ§ãä¿ã¡ãªããæ å ±ãæäŸããããšãã§ããŸããããã«ããããŠãŒã¶ãŒã¯ããæ·±ã察話ãè€éãªåé¡ã«å¯Ÿãããœãªã¥ãŒã·ã§ã³ãæ¢ãããšãã§ããŸãã
1.2 PL/SQLã®åºç€ç¥è
PL/SQLã¯ãOracle Corporationã«ãã£ãŠéçºãããããã·ãŒãžã£ã«èšèªã§ããSQLã«ããã°ã©ãã³ã°ã®æ§é ãè¿œå ããããšã§ãããŒã¿ããŒã¹ã®æäœããã©ã³ã¶ã¯ã·ã§ã³ã®å¶åŸ¡ãäŸå€åŠçãªã©ãå¹ççã«è¡ãããšãå¯èœã«ããŸãã
PL/SQLã¯SQLã§ã§ããããšã¯äœã§ãè¡ããäžã«ãå€æ°ã®å®£èšãæ¡ä»¶åå²ãã«ãŒãåŠçãªã©ãããã°ã©ãã³ã°èšèªãšããŠã®æ©èœãå ããããšãã§ããŸããããã«ãããOracleããŒã¿ããŒã¹äžã§é«åºŠãªããžãã¹ããžãã¯ãå®è£ ããããšãå¯èœã«ãªããŸãã
ãŸããPL/SQL㯔ãããã¯æ§é ”èšèªã§ãããããå¯èªæ§ãé«ãã管çãããããã§ããã¹ãã¢ãããã·ãŒãžã£ãããªã¬ãŒãé¢æ°ãªã©ãäœæããåå©çšæ§ãšããã©ãŒãã³ã¹ã®åäžã«ãå¯äžããŸãã
1.3 ChatGPTãšPL/SQLã®çžäºäœçš
ChatGPTãšPL/SQLã®çµã¿åããã«ãã£ãŠãããŒã¿ããŒã¹é§åã®ã¢ããªã±ãŒã·ã§ã³ãå€§å¹ ã«åŒ·åãããŸããPL/SQLã«ããããŒã¿ã®ååŸãšåŠçã¯ãChatGPTãæäŸã§ããèªç¶ãªãŠãŒã¶ãŒã€ã³ã¿ãŒãã§ãŒã¹ãéããŠãããçŽæçãªãã®ã«å€å®¹ããå¯èœæ§ãç§ããŠããŸãã
ç¹ã«ãChatGPTãçæããäŒè©±åŒã®ã€ã³ã¿ãŒãã§ãŒã¹ããPL/SQLãéããŠçŽæ¥ããŒã¿ããŒã¹ã«ã¯ãšãªãçºè¡ããããšã§ããšã³ããŠãŒã¶ãŒã®ããŒã¿ããŒã¹äœéšãç°¡çŽ åãã匷åããããŠãŒã¶ãŒãµããŒããã€ã³ã¿ã©ã¯ãã£ããªããŒã¿åæãå¯èœã«ããŸãã
ããã«ãChatGPTã¯PL/SQLããŒã¿ããŒã¹ããã·ãŒãžã£ãåœæ°ã®çæãæ¯æŽããéçºéçšãé«éåããããšãã§ããŸããããã«ãã£ãŠãéçºè ã¯ããè€éãªã¿ã¹ã¯ã«çŠç¹ãåœãŠãããšãã§ããããã«ãªããŸãã
1.4 PL/SQLã䜿ã£ãããŒã¿ç®¡çã®éèŠæ§
PL/SQLã¯ãããŒã¿ã®æŽåæ§ãšã»ãã¥ãªãã£ãå®ããªãããè€æ°ã®ããŒã¿ããŒã¹æäœãå¹ççã«åŠçããããã«èšèšãããŠããŸããããŒã¿ç®¡çã«ãããŠPL/SQLã䜿ãããšã¯ããšã³ã¿ãŒãã©ã€ãºã¢ããªã±ãŒã·ã§ã³ã®ã¹ã±ãŒã©ããªãã£ãšä¿¡é Œæ§ãé«ããããšãšçŽçµããŠããŸãã
ãã©ã³ã¶ã¯ã·ã§ãã«åŠçããšã©ãŒãã³ããªã³ã°ãããŒã¿ã®äžè²«æ§ãä¿ã€ããã®è€éãªããžãã¹ã«ãŒã«ã®å®è£ ãªã©ã¯ãPL/SQLãå©çšããããšã§ããå¹ççãã€å®å šã«è¡ããŸããããã¯ããµãŒãã¹ã®å質ãä¿ã¡ãªããããžãã¹ãæ¡å€§ããäžã§äžå¯æ¬ ãªèŠçŽ ã§ãã
ãŸããPL/SQLã®é«åºŠãªæ©èœã掻çšããããšã§ãããã°ããŒã¿ã®åæãã¬ããŒãã®çæãšãã£ããããæŽç·ŽãããããŒã¿æäœãè¡ãããšãã§ããŸããããŒã¿ããªãã³ãªææ決å®ãä¿é²ãããããPL/SQLã®æ·±ãç解ãšé©åãªå©çšã¯å¿ é ã§ãã
2. PL/SQLã§ChatGPTã掻çšããå©ç¹
PL/SQLã䜿çšããããšã§ãããŒã¿ããŒã¹ç®¡çã·ã¹ãã ã«ãããå€ãã®äœæ¥ãå¹çåã§ããŸããç¹ã«ãOracle Databaseãªã©ã§ãã䜿ããããã®èšèªã¯ãChatGPTã®ãããªå é²çãªAIæè¡ãšçµã¿åãããããšã§ããã®å¹æãæ倧éã«åŒãåºãããšãå¯èœã§ãã以äžã«ãPL/SQLãšChatGPTã䜵çšããããšã§åŸãããäž»èŠãªå©ç¹ã玹ä»ããŸãã
2.1 ããŒã¿ããŒã¹æäœã®èªåå
ChatGPTæè¡ãPL/SQLã¹ã¯ãªããã«çµ±åããããšã§ãããŒã¿ããŒã¹ã®æ¥ã ã®éçšãå€§å¹ ã«ç°¡çŽ åãããŸããPL/SQLã¯ãã®æ§é äžãç¹°ãè¿ãçºçããè€éãªã¯ãšãªãããã·ãŒãžã£ãèªååããã®ã«éåžžã«é©ããŠããŸãã
ChatGPTãšçµã¿åããããšããŠãŒã¶ãŒã®è³ªåãèŠæã«åºã¥ããŠåçã«SQLã¯ãšãªãçæããããšãå¯èœã«ãªããŸãããã®çžä¹å¹æã«ãããããŒã¿ããŒã¹ç®¡çè ãéçºè ã¯ã«ãŒãã³ã¯ãŒã¯ãã解æŸãããããæŠç¥çãªæ¥åã«å°å¿µã§ããããã«ãªããŸãã
ãŸããChatGPTã¯èªç¶èšèªåŠçã掻çšããŠãããæ¥åžžèšèªã§ããŒã¿ããŒã¹ã«åãåãããã§ãããããéæè¡è ã§ãç°¡åã«ããŒã¿ããŒã¹ãæäœã§ããããã«ãªãã®ã¯å€§ããªå©ç¹ã§ãã
2.2 é«åºŠãªããŒã¿åŠçãšã¬ããŒãã£ã³ã°
PL/SQLã¯è€éãªããŒã¿åæããããåŠçãã¬ããŒãçæãšãã£ãæ©èœãå®è£ ããã®ã«åœ¹ç«ã¡ãŸããChatGPTã®å°å ¥ã«ããããããã®ããã»ã¹ãæŽã«é²åããŸãã
ãŠãŒã¶ãŒãå ·äœçãªè³ªåãæãããããšãChatGPTãPL/SQLããã·ãŒãžã£ã䜿çšããŠå¿ èŠãªããŒã¿ãéèšããç解ãããã圢ã§æäŸããããšãå¯èœã§ãããã®ãããªå³ææ§ãšç²ŸåºŠã¯ãé«å質ãªææ決å®æ¯æŽã«çŽçµããŸãã
ããã«ãPL/SQLã§å®çŸ©ãããé¢æ°ãããã·ãŒãžã£ãChatGPTãšçµã¿åãããããšã§ãããè€éãªããŒã¿ã»ããã«å¯ŸããŠãé«éãã€æè»ãªã¬ããŒãã£ã³ã°ãè¡ããããã«ãªããããžãã¹åæã®é åã§ã®å¿çšç¯å²ãæ Œæ®µã«åºãããŸãã
2.3 ãã£ãããããæ©èœã®çµã¿èŸŒã¿
ChatGPTãPL/SQLãšçµã¿åãããããšã§ããã£ããããããšããŠã®æ©èœãå®è£ ããããšãå¯èœã§ãããã®ãã£ãããããã¯ããŠãŒã¶ãŒãšã®ã€ã³ã¿ã©ã¯ã·ã§ã³ãéããŠããŒã¿ããŒã¹ã®ã¯ãšãªãå®è¡ãããã®çµæããªã¢ã«ã¿ã€ã ã«æäŸã§ããŸãã
ãŠãŒã¶ãŒãèªç¶èšèªã§åãåãããè¡ãªã£ãå ŽåãChatGPTããã®å 容ã解éããé©åãªPL/SQLã³ãã³ããçæããŠå®è¡ããŸãããã®æµãã¯ãŠãŒã¶ãŒãšã¯ã¹ããªãšã³ã¹ãåäžãããã ãã§ãªããã¢ããªã±ãŒã·ã§ã³ã®ã¢ã¯ã»ã¹æ§ãé«ããããšã«ãç¹ãããŸãã
çµç¹å ã§ã®åãåãããã顧客ãµããŒããžã®å¿çšã«ãããæéããªãœãŒã¹ã®å€§å¹ ãªç¯çŽã«è²¢ç®ããäºäŸãçŸããŠããŸãããããããã£ãããããã¯24æé365æ¥çšŒåããããšãå¯èœãªãããåžžã«å¿çãæäŸã§ãããšããå©ç¹ããããŸãã
2.4 å¹çæ§ãšçç£æ§ã®åäž
PL/SQLã䜿çšããããšã§ãããã°ã©ã äžã§ç¹°ãè¿ãçºçããåŠçãå¹çããæ±ãããšãã§ããŸããå ããŠãChatGPTã®èªç¶èšèªåŠçèœåã掻çšããããšã§ãéçºè ãçµäºãŠãŒã¶ãŒãçŽé¢ãã課é¡ãè¿ éã«è§£æ±ºããããšãå¯èœã«ãªããŸãã
ãšã©ãŒãåé¡ã®ãã©ãã«ã·ã¥ãŒãã£ã³ã°ã«ãããŠãChatGPTã¯åé¡ã®å¯ŸåŠæ¹æ³ã代æ¿æ¡ã®ææ¡ãããã«ã¯åŠç¿æ©èœã«ããäºé²çãŸã§ãå¹ åºãæ¯æŽãè¡ãããšãã§ããã®ã§ãã
PL/SQLãšChatGPTãçµã¿åãããããšã«ãããäŒæ¥ãéçºè ã¯å質ã®é«ã補åããµãŒãã¹ããããéããããå°ãªããªãœãŒã¹ã§æäŸããããšãã§ããããã«ãªããŸãããã®é£æºã¯ãå¹ççãªãœãããŠã§ã¢éçºããã»ã¹ãšé«ã顧客æºè¶³åºŠãããããã§ãããã
3. ChatGPTãšPL/SQLã®é£æºæ¹æ³
ChatGPTãšPL/SQLãçµã¿åãããã·ã¹ãã ã¯ãå€ãã®ããžãã¹ã¢ããªã±ãŒã·ã§ã³ã§äŸ¿å©ãªè§£æ±ºçãæäŸããŸããããã§ã¯ãChatGPTã®èªç¶èšèªåŠçèœåãšPL/SQLã®ããŒã¿ããŒã¹ç®¡çæ©èœãšãé£æºãããããŒã¿é§ååã®äŒè©±åã€ã³ã¿ãŒãã§ãŒã¹ãæ§ç¯ããæé ã解説ããŸãã
ãã®é£æºã«ã¯APIã䜿çšããããŒã¿ã®ååŸããã£ãããããã®å¿çæ©æ§ã®èšèšãPL/SQLã®ã¹ãã¢ãããã·ãŒãžã£ã掻çšããå šäœã®ã»ãã¥ãªãã£ãä¿æããããã®ãã¹ããã©ã¯ãã£ã¹ã«çŠç¹ãåœãŠãŠãããŸãã
å ·äœçãªã¹ããããšããŠããŠãåŠã¶ããšã§ãå¹ççãªã·ã¹ãã ãèšèšãããŠãŒã¶ãŒã®ã¯ãšãªã«å¯ŸããŠãªã¢ã«ã¿ã€ã ã§ç²ŸåºŠã®é«ãããŒã¿ãæäŸããèœåã身ã«ã€ããããšãã§ããŸãã
3.1 APIçµç±ã§ã®ããŒã¿ååŸ
APIãå©çšããããŒã¿ååŸã¯ãChatGPTãšPL/SQLã®é£æºã«ãããŠäžæ žãšãªãããã»ã¹ã§ããAPIã¯ãChatGPTãPL/SQLããŒã¿ããŒã¹ãšå¯Ÿè©±ããå¿ èŠãªæ å ±ãååŸããããã®æ¡æ©ãšãªããŸãã
APIãéããŠããŒã¿ãååŸããã«ã¯ããŸãå®å šã§å¹ççãªAPIãšã³ããã€ã³ãã®èšèšãæ±ããããŸãããã®ãšã³ããã€ã³ãã¯ãChatGPTãåãåãããè¡ããããŒã¿ããŒã¹ããæ å ±ãåŒãåºãããã«å©çšããŸãã
ãšã³ããã€ã³ãã¯ãé©åãªèªèšŒãšèªå¯ã®ã¡ã«ããºã ãåããäžæ£ã¢ã¯ã»ã¹ãããŒã¿æŒããã®ãªã¹ã¯ãæå°éã«æãã€ã€ãå¹ççãªããŒã¿ãã§ãããä¿èšŒããå¿ èŠããããŸãã
3.2 ãã£ããããããšããŠã®å¿çæ©æ§ã®èšèš
ChatGPTããã£ããããããšããŠæŽ»çšããéã®å¿çæ©æ§ã¯ããŠãŒã¶ãŒã®å ¥åã«å¯ŸããŠé©åãªå¿çãçæããããã«äžå¯æ¬ ã§ããPL/SQLããŒã¿ããŒã¹ããååŸããããŒã¿ãåºã«ããŠãChatGPTãæçãªæ å ±ãæäŸã§ããããã«èšèšãããã¹ãã§ãã
å¿çã®èšèšã«ã¯ããŠãŒã¶ãŒã®è³ªåã«å¯Ÿããæå³ãæ£ç¢ºã«ç解ããæãé¢é£æ§ã®é«ãæ å ±ãéžæããããã®ããžãã¯ãå«ãŸããŸãããã®ããããŠãŒã¶ãŒã®å ¥åãåæããé©åãªã¯ãšãªãçæããæ©èœãçµã¿èŸŒãå¿ èŠããããŸãã
ãŸããã¬ã¹ãã³ã¹ããŠãŒã¶ãŒã«ãšã£ãŠç解ãããã圢åŒã§ããããšãéèŠã§ãããã®çºãå¿çã®ãã©ãŒããããè¡šçŸæ¹æ³ãèæ ®ã«å ¥ããªããã°ãªããŸããã
3.3 PL/SQLã¹ãã¢ãããã·ãŒãžã£ã®æŽ»çš
PL/SQLã¹ãã¢ãããã·ãŒãžã£ã¯ãå®çŸ©æžã¿ã®è€éãªã¯ãšãªãããŒã¿æäœãå®è¡ããããã®åŒ·åãªããŒã«ã§ãããããé©åã«ChatGPTã«çµ±åããããšã§ãå®å šãã€å¹ççãªããŒã¿åŠçãå¯èœã«ãªããŸãã
ã¹ãã¢ãããã·ãŒãžã£ã®äœ¿çšã¯ãã³ãŒãã®åå©çšæ§ãé«ãããšå ±ã«ãããŒã¿ããŒã¹ãžã®ç¡çšãªã¢ã¯ã»ã¹ãäœæžããã·ã¹ãã ã®ããã©ãŒãã³ã¹ãåäžãããŸãããã®ããããã£ãããããçµç±ã§ã®ãŠãŒã¶ãŒã¯ãšãªã«å¿ããé©åãªããã·ãŒãžã£ã®ããªã¬ãŒãéèŠã§ãã
ããã«ãã¹ãã¢ãããã·ãŒãžã£ã¯ä¿å®ç®¡çã容æã§ãããå¿ èŠã«å¿ããŠæ¹è¯ãæ¡åŒµãè¡ãããããå°æ¥ã®ã·ã¹ãã å€æŽã«ãæè»ã«å¯Ÿå¿ããããšãã§ããŸãã
3.4 ã»ãã¥ãªãã£ä¿æã®ããã®ãã¹ããã©ã¯ãã£ã¹
ãã£ãããããã·ã¹ãã ã®ã»ãã¥ãªãã£ã¯ããŠãŒã¶ãŒã®ä¿¡é Œãšã·ã¹ãã ã®ä¿¡é Œæ§ãä¿ã€äžã§æ¥µããŠéèŠã§ãããã®ãããã»ãã¥ãªãã£ã®ãã¹ããã©ã¯ãã£ã¹ã«åŸã£ãŠãã·ã¹ãã ãèšèšããéçšããå¿ èŠããããŸãã
ããŒã¿ã®æå·åããšã³ããã¥ãšã³ãã®ã»ãã¥ãªãã£å¯Ÿçãã¢ã¯ã»ã¹ã³ã³ãããŒã«ã®åŒ·åãªã©ãPL/SQLãšãã£ãããããã®é£çµãã€ã³ãã§ããAPIã«ãããã»ãã¥ãªãã£å¯Ÿçãäžå¯æ¬ ã§ããå®å šãªAPIã«ãããäžæ£ã¢ã¯ã»ã¹ãããŒã¿æŒæŽ©ãé²ããå®å¿ããŠãŠãŒã¶ãŒãã·ã¹ãã ãå©çšã§ããŸãã
ãŸããå®æçãªã»ãã¥ãªãã£ç£æ»ãšè匱æ§ãã¹ããè¡ããæœåšçãªã»ãã¥ãªãã£ãªã¹ã¯ãžã®å¯Ÿçãè¬ããããšãéèŠã§ããããã«ãããã·ã¹ãã ãåžžã«æé«ã®ã»ãã¥ãªãã£ç¶æ ã«ä¿ãããŸãã
4. å®éã®ã³ãŒãäŸãšãã¥ãŒããªã¢ã«
4.1 ç°¡åãªChatGPTçµ±åã®å®è£
ChatGPTãããªãã®ã¢ããªã±ãŒã·ã§ã³ã«çµ±åããããšã¯é©ãã»ã©ã·ã³ãã«ã§ãããŸããé©åãªAPIãšã³ããã€ã³ãã«ã¢ã¯ã»ã¹ããŠãå¿ èŠãªèªèšŒãååŸããããšããå§ããŸããããåºæ¬çãªPOSTãªã¯ãšã¹ãã§ChatGPTã«ããã¹ãããŒã¿ãéä¿¡ããã¬ã¹ãã³ã¹ãåãåãã³ãŒããæžãããšãéèŠã§ãã
APIããŒãååŸåŸãã»ãã¥ã¢ãªæ¥ç¶ã確ç«ããã¬ã¹ãã³ã¹ãé©åã«åŠçããããã®ãšã©ãŒãã³ããªã³ã°ãå®è£ ããã ããããã£ãããããããšäº€æµããéã®ãŠãŒã¶ãŒã®å ¥åãåŠçãããµã³ãã«ã³ãŒããçšæããŸãã
ãã¹ãç°å¢ã§åŸ¹åºçã«è©Šè¡ããæ¬çªç°å¢ãžç§»è¡ããåã«ãã¬ã€ãã³ã·ãŒãAPIã®å¶éã«æ³šæãæãããšã¯äžå¯æ¬ ã§ããããŒã¿ãã©ã€ãã·ãŒãä¿è·ãããããHTTPSãããã³ã«ã䜿çšããŠéä¿¡ãæå·åããäºãå¿ããã«ã
4.2 PL/SQLãçšããè€éãªã¯ãšãªåŠç
PL/SQLã¯é«åºŠãªããŒã¿æäœãå¯èœã«ããããŒã«ã§ãããè€éãªã¯ãšãªåŠçã«æé©ã§ããè€æ°ã®ããŒãã«ããããŒã¿ãçµåããæ¡ä»¶ã«å¿ããŠæ å ±ãæœåºããã¹ãã¢ãããã·ãŒãžã£ãé¢æ°ãäœæããããšã§ãã¢ããªã±ãŒã·ã§ã³ã®ããã©ãŒãã³ã¹ãåäžãããŸãããã
ãããåŠçããã©ã³ã¶ã¯ã·ã§ã³å¶åŸ¡ãäŸå€åŠçã®ã¡ã«ããºã ã掻çšããããšã§ãå ç¢ãªããŒã¿ããŒã¹æäœãå®çŸã§ããŸãããããã®PL/SQLæ©èœãé§äœ¿ããŠãããžãã¹ããžãã¯ãããŒã¿ããŒã¹ã¬ãã«ã§å¹ççã«åŠçããŸãããã
ã¯ãšãªã®æé©åãã€ã³ããã¯ã¹äœæããããŠçµ±èšæ å ±ã®æŽæ°ãªã©ã¯ãè€éãªããŒã¿æäœãå¿ èŠãªã¢ããªã±ãŒã·ã§ã³ã®æ§èœãç¶æããäžã§äžå¯æ¬ ã§ããè¥å€§åããã¹ãã¢ãããã·ãŒãžã£ãããå°ãããåå©çšå¯èœãªã¢ãžã¥ãŒã«ã«åå²ããããšãå¿ããªãã§ãã ããã
4.3 ãŠãŒã¶ãŒã€ã³ã¿ã©ã¯ã·ã§ã³ã®ããã®ã³ãŒãã£ã³ã°æè¡
ãŠãŒã¶ãŒãã¬ã³ããªãŒãªã€ã³ã¿ãŒãã§ãŒã¹ãæ§ç¯ããããã§ããŠãŒã¶ãŒã€ã³ã¿ã©ã¯ã·ã§ã³ã¯éåžžã«éèŠãªèŠçŽ ã§ããPL/SQLã䜿ã£ãŠUIã®ããã¯ãšã³ãããžãã¯ãèšè¿°ããå Žåãã·ã³ãã«ãã€çŽæçãªãŠãŒã¶ãŒãšã¯ã¹ããªãšã³ã¹ãæäŸããããšãéèŠã§ãã
ãã©ãŒã ã®ããªããŒã·ã§ã³ãã»ãã·ã§ã³ç®¡çãAJAXãçšããåçã³ã³ãã³ãã®æŽæ°ãªã©ããŠãŒã¶ãŒãšã®å¯Ÿè©±ãã¹ã ãŒãºã«ããããã«ã¯ããã€ãã®æè¡ãå¿ èŠã§ãããšã³ããŠãŒã¶ãŒãçŽé¢ããã§ãããã·ããªãªãæ³å®ããæè»ã«åŠçã§ãããããªã³ãŒããæžãããšãå¿ãããŸãããã
ãŠãŒã¶ãŒã®æäœå±¥æŽãããŒã¿ããŒã¹ã«ä¿åããããšã§ãã«ã¹ã¿ãã€ãºãããäœéšãæäŸã§ããŸããããã«ãã¡ãã»ãŒãžã³ã°ãéç¥ã·ã¹ãã ãPL/SQLã§å®è£ ããããšã§ãã¢ããªã±ãŒã·ã§ã³ã®å¯Ÿè©±æ§ãé«ããããšãå¯èœã§ãã
4.4 ãããã°ãšæé©åã®ãã¯ããã¯
ã³ãŒãã®ãããã°ã¯ãéçºããã»ã¹ã®äžã§ãç¹ã«éèŠãªã¹ãããã§ããPL/SQLã§ã¯ãDBMS_OUTPUTããã±ãŒãžãEXCEPTIONãããã¯ã䜿ã£ããšã©ãŒãã³ããªã³ã°ããããã°äœæ¥ã容æã«ããŸãã
ããã©ãŒãã³ã¹ç£èŠããŒã«ãEXPLAIN PLANãçšããŠãã¯ãšãªã®å®è¡èšç»ã詳现ã«åæããããšã§ãããã«ããã¯ãç¹å®ããSQLæãæé©åããããšãã§ããŸããããã«ããããã¡ã€ãªã³ã°ããŒã«ãçšããŠå®è¡æéãé·ãã³ãŒããèŠã€ãåºããå¹çåã®ããã®æ¹åçãè¬ããŸãããã
æçµçãªãããã¯ãã®å質ãé«ããããã«ã¯ãã¬ã®ã¥ã©ãŒãªã³ãŒãã¬ãã¥ãŒãšãªãã¡ã¯ã¿ãªã³ã°ãæ¬ ãããŸãããã¯ãªãŒã³ã§ç¶æ管çããããã³ãŒãããŒã¹ãä¿ã€ããã«ãããŒã ã¡ã³ããŒéã§ç¥èŠãå ±æãåãããšã倧åã§ãã
5. ChatGPTãšPL/SQLçµ±åã®ãã©ãã«ã·ã¥ãŒãã£ã³ã°
ChatGPTãšPL/SQLã®çµ±åã¯ãåçãã€ã€ã³ã¿ã©ã¯ãã£ããªããŒã¿ããŒã¹é§ååã¢ããªã±ãŒã·ã§ã³ã®éçºã«æ¬ ãããŸããããã®åŒ·åãªçµã¿åããã¯ãéçºè ãè€éãªã¯ãšãªã容æã«æ§ç¯ãããã£ããããããšããŠã®ChatGPTã®èœåããã«ã«æŽ»çšããããšãå¯èœã«ããŸãããããããã®ããã»ã¹ã§ã¯å¹Ÿã€ãã®åé¡ãçºçããå¯èœæ§ãããããããã®è§£æ±ºã«ã¯é©åãªç¥èãšã¢ãããŒããå¿ èŠã§ãã
ãã®èšäºã§ã¯ãPL/SQLãšChatGPTã®çµ±åã«ãããŠå ±éãã幟ã€ãã®åé¡ãšãã®è§£æ±ºçãããã©ãŒãã³ã¹ã®æé©åãã»ãã¥ãªãã£ã®ç¢ºä¿ããããŠå¹æçãªã¡ã³ããã³ã¹æŠç¥ã«ã€ããŠã玹ä»ããŸãããã®æ å ±ããããªãã®ã¢ããªã±ãŒã·ã§ã³ãã¹ã ãŒãºã«éçšãç¶ããããã®å©ããšãªãããšãé¡ã£ãŠããŸãã
ããã§ã¯ãChatGPTãšPL/SQLçµ±åã®éã«çŽé¢ããå¯èœæ§ã®ããããã€ãã®åé¡ãšãã®è§£æ±ºçã«ã€ããŠèŠãŠãããŸãããã
5.1 äžè¬çãªãšã©ãŒãšãã®å¯ŸåŠæ³
çµ±åæã«ééããå¯èœæ§ã®ããæãäžè¬çãªãšã©ãŒã¯ãæ¥ç¶ã®å€±æãã¹ã¯ãªããã®ã·ã³ã¿ãã¯ã¹ãšã©ãŒããããŠäžé©åãªããŒã¿åã®å©çšã§ãããããã®åé¡ã¯ãæå³ããåäœãåŸãããªãåå ãšãªããŸãã
æ¥ç¶ãšã©ãŒã®å ŽåãããŒã¿ããŒã¹ãªã¹ããŒã®ç¶æ ããããã¯ãŒã¯ã®èšå®ã確èªããå¿ èŠã«å¿ããŠåæ§æããããšãéèŠã§ãããŸããOracle Net Servicesã®æ§æãã¡ã€ã«ã§ããtnsnames.oraãé©åã«èšå®ãããŠããããåžžã«ãã§ãã¯ããå¿ èŠããããŸãã
ã·ã³ã¿ãã¯ã¹ãšã©ãŒã«é¢ããŠã¯ãPL/SQLã®ã³ãŒãã泚ææ·±ãã¬ãã¥ãŒããå ±éã®ã·ã³ã¿ãã¯ã¹ã¬ã€ãã©ã€ã³ã«åŸã£ãŠãããã©ããã確èªããããšã倧åã§ãããã£ãŒãããã¯ããšã©ãŒã¡ãã»ãŒãžã¯ãç¹å®ã®åé¡ã®ç¹å®ã«åœ¹ç«ã€éèŠãªæããããæäŸããŸãã
5.2 ããã©ãŒãã³ã¹ã®åé¡è§£æ±º
ChatGPTãšPL/SQLçµ±åã¢ããªã±ãŒã·ã§ã³ã®ããã©ãŒãã³ã¹ã¯ãããŒã¿ããŒã¹ã®å¿çæ§ã«å€§ããäŸåããŠããŸããããã©ãŒãã³ã¹ã®äœäžã¯ãããã€ã³ããã¯ã¹ã®æ¬ åŠããéå¹çãªã¯ãšãªèšèšã«èµ·å ããŸãã
ãã®åé¡ã«å¯ŸåŠããæåã®ã¹ãããã¯ãé 延ãåŒãèµ·ãããŠããã¯ãšãªãç¹å®ããããšã§ãããªããã£ãã€ã¶ã®çµ±èšãéããEXPLAIN PLANãSQLãã¬ãŒã¹ãªã©ã®ããŒã«ã䜿çšããŠã¯ãšãªã®å®è¡èšç»ãåæããããšã§ãåé¡ã®æ ¹æ¬ãæãäžããããšãã§ããŸãã
次ã«ãã€ã³ããã¯ã¹ã®è¿œå ãSQLæã®ãªãã¡ã¯ã¿ãªã³ã°ããããã¯Oracleã®ããã©ãŒãã³ã¹ãã¥ãŒãã³ã°æ©èœãçšããŠã¯ãšãªãæé©åããããšãã§ããŸããå¹æçãªãã£ãã·ã¥æŠç¥ã®å°å ¥ããããã©ãŒãã³ã¹åäžã®ããã®éèŠãªæ段ã§ãã
5.3 ã»ãã¥ãªãã£æžå¿µãžã®å¯Ÿå¿
ChatGPTãšPL/SQLã®çµ±åã«ãããã»ãã¥ãªãã£ã¯éåžžã«éèŠã§ããSQLã€ã³ãžã§ã¯ã·ã§ã³æ»æãå§ããšããæ§ã ãªè åšããããŒã¿ããŒã¹ãä¿è·ããããã«ã¯ãå åºãªã»ãã¥ãªãã£å¯Ÿçãè¬ããå¿ èŠããããŸãã
ããªãã¢ãã¹ããŒãã¡ã³ãã®äœ¿çšã¯ãSQLã€ã³ãžã§ã¯ã·ã§ã³æ»æã®ãªã¹ã¯ã軜æžããããã®æãç°¡åã§å¹æçãªææ³ã®äžã€ã§ããããã«ãã£ãŠããŠãŒã¶ããã®å ¥åãé©åã«ãµãã¿ã€ãºãããããŒã¿ããŒã¹ãæªæããæäœããä¿è·ãããŸãã
å ããŠãããŒã¿ããŒã¹æ¥ç¶æã®é©åãªæš©éèšå®ããå®æçãªã»ãã¥ãªãã£ã¢ããããŒãã®é©çšãäžå¯æ¬ ã§ããããã«ãããã·ã¹ãã ã®ã»ãã¥ãªãã£ãç¶æãããæ°ããªè åšãããé²åŸ¡ããããšãã§ããŸãã
5.4 ã¡ã³ããã³ã¹ãšã¢ããããŒãæŠç¥
ã¢ããªã±ãŒã·ã§ã³ãææ°ã®ç¶æ ã«ä¿ã¡ãæœåšçãªãã©ãã«ããé¿ããããã«ã¯ãé©åãªã¡ã³ããã³ã¹ãšã¢ããããŒãæŠç¥ãå¿ èŠã§ããå®æçãªç£èŠããããã®é©çšããããŠã·ã¹ãã ã®ã¢ããããŒãã¯ããã®æç¶å¯èœæ§ãä¿èšŒããŸãã
PL/SQLããã±ãŒãžãé¢æ°ã®å®æçãªã¬ãã¥ãŒãšãªãã¡ã¯ã¿ãªã³ã°ããŸããããã©ãŒãã³ã¹ã®äžè²«æ§ãä¿ã€äžã§åœ¹ç«ã¡ãŸããå€ããªã£ãã³ãŒãã®åé€ããææ°ã®ãã©ã¯ãã£ã¹ãžã®ã³ãŒãã®æŽæ°äœæ¥ãå«ãŸããŸãã
ãŸããChatGPTé¢é£ã®APIããã®ä»ã®çµ±åãã€ã³ãã«æ°ããæ©èœãè¿œå ãããããšããããŸãããã®ãããªå€åã«æè»ã«å¯Ÿå¿ããã·ã¹ãã ãæé©åããããã«ã¯ãå®æçãªç¶æ ãã§ãã¯ãšã¢ããããŒããã©ã³ãéèŠã§ãã
6. å°æ¥ã®å±æãšã€ã³ãµã€ã
6.1 人工ç¥èœãšããŒã¿ããŒã¹æè¡ã®èå
人工ç¥èœïŒAIïŒãšããŒã¿ããŒã¹æè¡ã®çµåã¯ãæå¯ã®ããžãã¹ç°å¢ã«ãããŠé©æ°çãªå€åããããããŠããŸããPL/SQLãå«ãããŒã¿ããŒã¹èšèªã¯ãAIã¢ã«ãŽãªãºã ã®å©ããåããŠèªååãããããŒã¿æäœãåææ©èœãããã«é²åãããããšãæåŸ ãããŠããŸãããã®èåã¯ãè€éãªåãåããããªã¢ã«ã¿ã€ã ã®ããŒã¿åæ ãå®çŸããããšã«å¯äžããŠããŸãã
çŸä»£ã®äŒæ¥ã¯ãããå€ãã®ããŒã¿ãé«éã«åŠçããé©åãªæ å ±ãå³åº§ã«æœåºããèœåãå¿ èŠãšãããŠããŸããæ å ±æè¡ïŒITïŒå°é家ã¯ããããã®èŠä»¶ã«å¿ããããã«ã人工ç¥èœã掻çšããŠPL/SQLã®å¹çãæ¹åããä»çµã¿ãæ§ç¯ããŠããŸããããªãã¡ãPL/SQLããã°ã©ãã³ã°èšèªã匷åããAIã¢ã·ã¹ã¿ã³ãããããŒã¿ããŒã¹ã®æ§èœãé«ããéµãšãªãã§ãããã
ãã®ããã«ãAIãšããŒã¿ããŒã¹æè¡ã®çµåã¯ãå¹çæ§ãä¿¡é Œæ§ãã¹ã±ãŒã©ããªãã£ã«å¯Ÿããæ°ããªåºæºãäœãåºããšãšãã«ãå°æ¥çãªçºå±ã«åãã匷åºãªåºç€ãç¯ããŠããŸããããã«ãããPL/SQLãçšããããŒã¿ããŒã¹ããã°ã©ãã³ã°ã¯ãæŽãªã粟床ãšã¹ããŒãã§ããŒã¿ãåŠçããéãæãã§ãããã
6.2 ChatGPTã®é²åã«äŒŽãPL/SQLã®åœ¹å²
ChatGPTã®ãããªå é²çãªèªç¶èšèªåŠçããŒã«ã¯ã人éåæ§ã®äŒè©±èœåãšç¥èããŒã¹ã掻çšãããŠãŒã¶ãŒã«ä»£ãã£ãŠè€éãªããŒã¿ããŒã¹æäœãéè¡ããèœåãæã€ããã«é²åããŠããŸããPL/SQLã¯ãããããããŒã«ã®ããã¯ãšã³ãã§åäœããããã·ãŒãžã£ãããªã¬ãŒãå®çŸ©ããããã®éµãšãªãèšèªã§ãã
ããŒã¿ããŒã¹ããã°ã©ãã¯ãChatGPTã掻çšããããšã§ãPL/SQLã¹ã¯ãªãããããå¹æçã«ç®¡çããæé©åããããšãã§ããŸããChatGPTã«ãã£ãŠãPL/SQLã³ãŒãã®çæãããã°ããŸãã¯ã³ãŒãæ¹è¯ã®ææ¡ãè¡ãããããšãçãããããŸãããã€ãŸããChatGPTã¯PL/SQLéçºè ã®éèŠãªã¢ã·ã¹ã¿ã³ããšãªãå¯èœæ§ããããŸãã
ãããã®èªååããŒã«ã®é²åã¯ãPL/SQLã®åœ¹å²ãåå®çŸ©ããããŒã¿ããŒã¹ç®¡çã®å¹çåãšããæ°ããå°å¹³ãåãéããŸããéçºè ã®ã¬ãã«ã¢ãããšã¿ã¹ã¯ã®èªååã¯ãå€§å¹ ãªæéç¯çŽã«ã€ãªãããããã«ãã£ãŠäŒæ¥ã¯ããæŠç¥çãªæ¥åã«ãªãœãŒã¹ãæ¯ãåããããšãå¯èœã«ãªãã§ãããã
6.3 åæãšææ決å®ã匷åããããã®æŠç¥
åæèœåã®åäžãšè¿ éãªææ決å®ã¯ãã³ã³ããã£ãã£ããªããžãã¹ãè¡ãäžã§äžå¯æ¬ ã§ããPL/SQLã¯ãé«åºŠãªããŒã¿åæãšåŠçããµããŒãããããã«äžå¯æ¬ ãªããŒã«ã§ããããã®æ©èœã¯ChatGPTã«ãã£ãŠããã«åŒ·åãããŸããChatGPTã®çµã¿èŸŒã¿ã¢ã«ãŽãªãºã ã¯ãPL/SQLãä»ããããŒã¿ã®ãã¿ãŒã³èªèãäºæž¬åæãè£å©ãããã粟å¯ãªããžãã¹ã€ã³ãµã€ããæäŸããŸãã
ããŒã¿ããªãã³ãªæ±ºå®ããµããŒãããããã«ãPL/SQLéçºè ã¯ã¯ãšãªæé©åãããŒã¿éçŽãããã©ãŒãã³ã¹ãã¥ãŒãã³ã°ãšãã£ãæè¡ã«ç²ŸéããŠããå¿ èŠããããŸãããããã®ã¹ãã«ã«å ããChatGPTã䜿ã£ã察話ååæãå°å ¥ãããããšã§ãè€éãªããŒã¿ã»ããã«è¿ éã«ã¢ã¯ã»ã¹ããæå³ã®ããæŽå¯ãå°ãåºãããšãå¯èœã«ãªããŸãã
ãã®ãããªæŠç¥ã¯ãçµç¹ããªã¢ã«ã¿ã€ã ã§ããŒã¿ã解æããããéãæ£ç¢ºãªææ決å®ãäžãåãäžããŸãããããŸã§ã«ãªããPL/SQLãšChatGPTã®çµ±åã¯æ å ±ãåã«å€ããäžã§æ¬ ãããªãæŠç¥ãšãªã£ãŠããŸãã
6.4 æ¥çã®ãã¬ã³ããšChatGPTã®æªæ¥
æè¡çã®ãã¬ã³ãã¯åžžã«é²åããŠãããChatGPTãä»ã®AIãã£ããããããœãªã¥ãŒã·ã§ã³ã¯æ³šç®ãããååšãšãªã£ãŠããŸãããããã®ããŒã«ãæ¥çå šäœã®ããŒã¿ç®¡çã顧客ãµãŒãã¹ã®ããæ¹ãæ ¹åºããå€ããŠããããšã¯ç¢ºå®ã§ããããã«äŒŽããPL/SQLã®ãããªããŒã¿ããŒã¹é¢é£èšèªã¯ãã·ã¹ãã ã®çµ±åãéçšé¢ã§æŽãªãé²åãéããå¿ èŠãåºãŠããŸãã
ChatGPTãæäŸããè±å¯ãªAPIãšçµã¿åãããŠäœ¿çšãããããšã§ãPL/SQLã®ã¢ãããŒãã¯ãããã€ãããã¯ãã€é©æ°çãªãã®ã«å€ãããŸããèªååãããããŒã¿åæããããŒãœãã©ã€ãºããããŠãŒã¶ãŒãšã¯ã¹ããªãšã³ã¹ã®æäŸãŸã§ãChatGPTãšPL/SQLã¯ããã¯ãããžãŒã®åããã«æŽ»çšããŠæ°ããªããžãã¹äŸ¡å€ãåµåºããŸãã
æªæ¥ã«åããŠãChatGPTã®èªç¶èšèªç解èœåãšPL/SQLã®å å®ãªããŒã¿ããŒã¹ç®¡çèœåããé©æ°çãªãœãªã¥ãŒã·ã§ã³ãçã¿åºãç¶ããããšã§ããããããã«ããããããã®ãã¯ãããžãŒã¯äºãã«è£å®ãåããªããã絶ããæé·ãç¶ããããžã¿ã«çµæžãæ¯ããéµãšãªããŸãã