{"id":635,"date":"2015-02-11T18:24:39","date_gmt":"2015-02-11T09:24:39","guid":{"rendered":"http:\/\/www.dbsheetclient.jp\/blog\/?p=635"},"modified":"2018-06-27T16:18:29","modified_gmt":"2018-06-27T07:18:29","slug":"%e4%be%8b%e5%a4%96%e5%87%a6%e7%90%86%e3%82%a8%e3%83%a9%e3%83%bc%e5%87%a6%e7%90%86-oracle%e7%b7%a8","status":"publish","type":"post","link":"https:\/\/www.dbsheetclient.jp\/blog\/?p=635","title":{"rendered":"\u4f8b\u5916\u51e6\u7406(\u30a8\u30e9\u30fc\u51e6\u7406) (Oracle\u7de8)"},"content":{"rendered":"

IT\u30b3\u30fc\u30c7\u30a3\u30cd\u30fc\u30bf\u306e\u30b7\u30e5\u30a6\u3067\u3059\u3002<\/p>\n

\"DSC_2080_2\"<\/a><\/p>\n

\u524d\u56de\u306b\u5f15\u304d\u7d9a\u304d\u3001\u52a0\u9808\u82b1\u5d0e\u6c34\u4e0a\u516c\u5712\u3067\u64ae\u3063\u305f\u5199\u771f\u3067\u3059\u3002\u7528\u6c34\u8def\u306b\u9ce5\u304c\u6cf3\u3044\u3067\u3044\u307e\u3057\u305f\u3002\u304a\u305d\u3089\u304f\u30ab\u30eb\u30ac\u30e2\u3060\u3068\u601d\u3044\u307e\u3059\u3002\u30b9\u30a4\u30b9\u30a4\u30fc\u3068\u6c17\u6301\u3061\u3088\u3055\u305d\u3046\u306b\u6cf3\u3044\u3067\u307e\u3057\u305f\u3002\u305f\u307e\u306b\u884c\u5217\u3092\u4f5c\u3063\u3066\u884c\u9032\u3057\u305f\u308a\u3059\u308b\u59ff\u3082\u898b\u304b\u3051\u307e\u3059\u3088\u306d\u3002<\/p>\n

\u305d\u3046\u3044\u3048\u3070\u3001\u300c\u9d28\u306e\u6c34\u6414\u304d\u300d\u3068\u3044\u3046\u8a00\u8449\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u300a\u6c17\u697d\u305d\u3046\u306b\u6d6e\u304b\u3093\u3067\u3044\u308b\u9d28\u3082\u3001\u6c34\u9762\u4e0b\u3067\u306f\u6c34\u304b\u304d\u3092\u7d76\u3048\u305a\u52d5\u304b\u3057\u3066\u3044\u308b\u3068\u3053\u308d\u304b\u3089\u300b\u4eba\u77e5\u308c\u306a\u3044\u82e6\u52b4\u304c\u3042\u308b\u3053\u3068\u306e\u305f\u3068\u3048\u3067\u4f7f\u308f\u308c\u308b\u8a00\u8449\u306a\u3093\u3067\u3059\u3088\u306d\u3002
\u898b\u7fd2\u3046\u3068\u3053\u308d\u3082\u591a\u3044\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u306d\u3002

\uff1c\u672c\u65e5\u306e\u984c\u6750\uff1e
\u4f8b\u5916\u51e6\u7406(\u30a8\u30e9\u30fc\u51e6\u7406) (Oracle\u7de8)<\/p>\n

<\/strong>\u4eca\u56de\u306f\u3001\u51e6\u7406\u306e\u9014\u4e2d\u3067\u4f8b\u5916\uff08\u30a8\u30e9\u30fc\uff09\u304c\u767a\u751f\u3057\u305f\u5834\u5408\u306e\u51e6\u7406\u3092\u8a18\u8ff0\u3059\u308b\u4f8b\u5916\u51e6\u7406\uff08\u30a8\u30e9\u30fc\u51e6\u7406\uff09\u306b\u3064\u3044\u3066\u53d6\u308a\u4e0a\u3052\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002ORACLE\u306ePL\/SQL \u3068SQL Server\u306eTransact SQL\u3067\u306f\u8a18\u8ff0\u306e\u4ed5\u65b9\u304c\u7570\u306a\u308b\u305f\u3081\u3001\u4eca\u56de\u306f\u307e\u305aORACLE\u306b\u3064\u3044\u3066\u898b\u3066\u307f\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

PL\/SQL\u3067\u306f\u3001\u5b9f\u884c\u6642\u306e\u30a8\u30e9\u30fc\u3084\u8b66\u544a\u306e\u3053\u3068\u3092\u4f8b\u5916\u3068\u8a00\u3044\u307e\u3059\u304c\u3001\u3082\u3057\u3001\u51e6\u7406\u306e\u9014\u4e2d\u3067\u4f8b\u5916\u304c\u767a\u751f\u3057\u305f\u3068\u304d\u306b\u3001PL\/SQL\u30d6\u30ed\u30c3\u30af\u306b\u5b9f\u884c\u90e8\u3057\u304b\u306a\u304b\u3063\u305f\u5834\u5408\u3001PL\/SQL\u306f\u7570\u5e38\u7d42\u4e86(OS\u5074\u306b\u5236\u5fa1\u304c\u623b\u308b)\u3057\u307e\u3059\u3002<\/p>\n

\u4f8b\u3048\u3070\u3001\u3042\u308b\u5546\u54c1\u306b\u3064\u3044\u3066\u3001\u524d\u5e74\u306e\u51fa\u8377\u5b9f\u7e3e\u306b\u5bfe\u3059\u308b\u4eca\u5e74\u306e\u4e88\u7b97\u306e\u6bd4\u7387\u3092\u8a08\u7b97\u3067\u51fa\u3059\u51e6\u7406\u3092PL\/SQL\u3067\u8a18\u8ff0\u3057\u305f\u5834\u5408\u3001\u65b0\u5546\u54c1\u306e\u305f\u3081\u306a\u3069\u306e\u7406\u7531\u3067\u524d\u5e74\u306e\u51fa\u8377\u5b9f\u7e3e\u304c 0 \u3067\u3042\u3063\u305f\u5834\u5408\u306b\u306f\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

DECLARE
\u00a0 Yosan\u00a0 NUMBER := 12000;
\u00a0 Zennen_Jisseki\u00a0 NUMBER := 0;
\u00a0 Tai_Zennenhi NUMBER;
BEGIN
\u00a0 Tai_Zennenhi := 100.0 * Yosan \/ Zennen_Jisseki;
\u00a0 DBMS_OUTPUT.PUT_LINE(‘\u4e88\u7b97\/\u524d\u5e74\u5b9f\u7e3e = ‘ || Tai_Zennenhi||’%’);
END;
\/<\/p>\n

\u4e0a\u8a18\u3092\u5b9f\u884c\u3059\u308b\u3068\uff08SQL Plus\uff09\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306a ORA-01476 \u306e\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u7570\u5e38\u7d42\u4e86\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u6570\u5024\u30920\u3067\u5272\u308d\u3046\u3068\u3057\u305f\u3068\u304d\u306b\u51fa\u308b\u30a8\u30e9\u30fc\u3067\u3059\u3002
\"plsql_err\"<\/a><\/p>\n

\u3053\u308c\u306b\u3064\u3044\u3066\u3001\u4e0b\u8a18\u306e\u3088\u3046\u306b\u4f8b\u5916\u51e6\u7406\u90e8\u3092\u8ffd\u52a0\u3057\u3066\u30a8\u30e9\u30fc\u306e\u3068\u304d\u306e\u5bfe\u5fdc\u3092\u660e\u8a18\u3059\u308b\u3053\u3068\u3067\u3001\u7570\u5e38\u7d42\u4e86\u3055\u305b\u305a\u306b\u6b63\u5e38\u7d42\u4e86\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u4f8b\u5916\u51e6\u7406\u90e8\u306f\u3001BEGIN \uff5e END; \u306e\u9593\u306b\u3001EXCEPTION\u53e5\u3092\u5165\u308c\u3066\u3001EXCEPTION \uff5e END; \u306e\u9593\u306b\u4f8b\u5916\u51e6\u7406\u3092\u8a18\u8ff0\u3057\u307e\u3059\u3002<\/p>\n

DECLARE
\u00a0 Yosan\u00a0 NUMBER := 12000;
\u00a0 Zennen_Jisseki\u00a0 NUMBER := 0;
\u00a0 Tai_Zennenhi NUMBER;
BEGIN
\u00a0 Tai_Zennenhi := 100.0 * Yosan \/ Zennen_Jisseki;
\u00a0 DBMS_OUTPUT.PUT_LINE(‘\u4e88\u7b97\/\u524d\u5e74\u5b9f\u7e3e = ‘ || Tai_Zennenhi||’%’);
EXCEPTION
\u00a0 WHEN ZERO_DIVIDE THEN
\u00a0\u00a0\u00a0\u00a0\u00a0 DBMS_OUTPUT.PUT_LINE(‘0\u3067\u6570\u5024\u3092\u5272\u308d\u3046\u3068\u3057\u3066\u3044\u307e\u3059’);
\u00a0 \u00a0 \u00a0 Tai_Zennenhi := NULL;\u00a0
\u00a0 WHEN OTHERS THEN
\u00a0\u00a0\u00a0\u00a0\u00a0 DBMS_OUTPUT.PUT_LINE(‘\u4ed6\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f’);
\u00a0\u00a0\u00a0\u00a0\u00a0 Tai_Zennenhi := NULL;
END;
\/
\"plsql_\u4f8b\u5916\u51e6\u7406JPG\"<\/a><\/p>\n

\u4e0a\u8a18\u306f\u3001\u4e88\u7b97\u3092\u524d\u5e74\u5b9f\u7e3e\u306e0\u5024\u3067\u5272\u308d\u3046\u3068\u3057\u305f\u3068\u304d\u306b\u3001\u300cZERO_DIVIDE\u300d\u3068\u3044\u3046\u4f8b\u5916\u304c\u767a\u751f\u3057\u3001EXCEPTION\u4ee5\u4e0b\u306e\u4f8b\u5916\u51e6\u7406\u90e8\u306b\u51e6\u7406\u304c\u79fb\u308a\u3001\u300c0\u3067\u6570\u5024\u3092\u5272\u308d\u3046\u3068\u3057\u3066\u3044\u307e\u3059\u300d\u3068\u3044\u3046\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u51fa\u3057\u3066\u51e6\u7406\u3092\u7d42\u4e86\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u4f8b\u5916\u304c\u767a\u751f\u3057\u305f\u3068\u304d\u306e\u5236\u5fa1\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

\"plsql_\u4f8b\u5916\u51e6\u7406\u5236\u5fa1\"<\/a><\/p>\n

\u00a0\u305f\u3060\u3001\u4e0a\u8a18\u306e\u3088\u3046\u306b 0 \u3067\u5272\u308b\u53ef\u80fd\u6027\u304c\u3042\u3089\u304b\u3058\u3081\u308f\u304b\u3063\u3066\u3044\u308b\u5834\u5408\u306f\u3001\u51e6\u7406\uff11\u306e\u3068\u3053\u308d\u306b\u30a8\u30e9\u30fc\u30c1\u30a7\u30c3\u30af\u3092\u884c\u3046\u3053\u3068\u3067\u4f8b\u5916\u3092\u56de\u907f\u3067\u304d\u307e\u3059\u3002<\/p>\n

DECLARE
\u00a0 Yosan\u00a0 NUMBER := 12000;
\u00a0 Zennen_Jisseki\u00a0 NUMBER := 0;
\u00a0 Tai_Zennenhi NUMBER;
BEGIN
\u00a0 Tai_Zennenhi := CASE Zennen_Jisseki WHEN 0 THEN NULL
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0ELSE 100.0 * Yosan \/ Zennen_Jisseki END;<\/p>\n

\u00a0 IF Tai_Zennenhi IS NOT NULL THEN
\u00a0 \u00a0 DBMS_OUTPUT.PUT_LINE(‘\u4e88\u7b97\/\u524d\u5e74\u5b9f\u7e3e = ‘ || Tai_Zennenhi||’%’);
\u00a0 ELSE
\u00a0 \u00a0 DBMS_OUTPUT.PUT_LINE(‘\u524d\u5e74\u5b9f\u7e3e\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f’);
\u00a0 END IF;
\u00a0
EXCEPTION
\u00a0 \u00a0WHEN OTHERS THEN
\u00a0 \u00a0 \u00a0 DBMS_OUTPUT.PUT_LINE(‘\u4ed6\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u307e\u3057\u305f’);
\u00a0 \u00a0 \u00a0 Tai_Zennenhi := NULL;
END;
\/<\/p>\n

\"plsql_\u4f8b\u5916\u51e6\u7406\u56de\u907f\"<\/a><\/p>\n

\u00a0\u3053\u306e\u5834\u5408\u3001\u4e88\u7b97\u306e\u5bfe\u524d\u5e74\u5b9f\u7e3e\u6bd4\u7387\u3092\u51fa\u3059\u969b\u306b\u3001CASE\u6587\u3067 0 \u3067\u5272\u308b\u306e\u3067\u306f\u306a\u304f NULL\u306b\u8a2d\u5b9a\u3059\u308b\u304b\u305f\u3061\u306b\u3057\u3066\u304a\u308a\u3001\u4f8b\u5916\u51e6\u7406\u306f\u767a\u751f\u3057\u3066\u3044\u307e\u305b\u3093\u3002<\/p>\n

\u4eca\u65e5\u306f\u4ee5\u4e0a\u307e\u3067<\/p>\n","protected":false},"excerpt":{"rendered":"

IT\u30b3\u30fc\u30c7\u30a3\u30cd\u30fc\u30bf\u306e\u30b7\u30e5\u30a6\u3067\u3059\u3002 \u524d\u56de\u306b\u5f15\u304d\u7d9a\u304d\u3001\u52a0\u9808\u82b1\u5d0e\u6c34\u4e0a\u516c\u5712\u3067\u64ae\u3063\u305f\u5199\u771f\u3067\u3059\u3002\u7528\u6c34\u8def\u306b\u9ce5\u304c\u6cf3\u3044\u3067\u3044\u307e\u3057\u305f\u3002\u304a\u305d\u3089\u304f\u30ab\u30eb\u30ac\u30e2\u3060\u3068\u601d\u3044\u307e\u3059\u3002\u30b9\u30a4\u30b9\u30a4\u30fc\u3068\u6c17\u6301\u3061\u3088\u3055\u305d\u3046\u306b\u6cf3\u3044\u3067\u307e\u3057\u305f\u3002\u305f\u307e\u306b\u884c\u5217\u3092\u4f5c\u3063\u3066\u884c\u9032\u3057\u305f\u308a\u3059\u308b\u59ff\u3082 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[16],"tags":[],"class_list":["post-635","post","type-post","status-publish","format-standard","hentry","category-16"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=635"}],"version-history":[{"count":7,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/635\/revisions"}],"predecessor-version":[{"id":1959,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/635\/revisions\/1959"}],"wp:attachment":[{"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbsheetclient.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}