{"id":75771,"date":"2024-09-05T08:19:33","date_gmt":"2024-09-05T04:49:33","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/"},"modified":"2024-09-05T08:19:33","modified_gmt":"2024-09-05T04:49:33","slug":"introduction-to-gbase-8s-static-cursor-2bl8","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/","title":{"rendered":"\u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0627\u0633\u062a\u0627\u062a\u06cc\u06a9 GBase 8s"},"content":{"rendered":"<p>Summarize this content to 400 words in Persian Lang<br \/>\n            GBase 8s \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u0627\u0632\u06af\u0627\u0631 \u0628\u0627 \u0632\u0628\u0627\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc PL\/SQL Oracle \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u060c \u0627\u0639\u0644\u0627\u0646 \u0648 \u062a\u062e\u0635\u06cc\u0635 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u060c \u062a\u0631\u062a\u06cc\u0628\u060c \u0627\u0646\u062a\u062e\u0627\u0628\u060c \u06a9\u0646\u062a\u0631\u0644 \u062d\u0644\u0642\u0647\u060c \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u062b\u0628\u062a \u0627\u0634\u06cc\u0627\u0621\u060c SQL \u0627\u0633\u062a\u0627\u062a\u06cc\u06a9 \u0648 \u067e\u0648\u06cc\u0627 \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062e\u0637\u0627 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f. \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0631 \u0631\u0648\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u062b\u0627\u0628\u062a \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u0645\u0631\u06a9\u0632 \u062f\u0627\u0631\u062f. GBase 8s \u062f\u0648 \u0646\u0648\u0639 \u0646\u0634\u0627\u0646\u06af\u0631 \u062b\u0627\u0628\u062a \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f: \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc \u0648 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0622\u0634\u06a9\u0627\u0631. \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u062a\u0648\u0636\u06cc\u062d \u0645\u0641\u0635\u0644\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0627\u06cc\u0633\u062a\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 GBase 8s\u060c \u0627\u0632 \u062c\u0645\u0644\u0647 \u0645\u0648\u0627\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647\u060c \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627 \u0648 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u0648\u062b\u0631 \u0627\u0632 \u0622\u0646\u0647\u0627 \u0628\u0631\u0627\u06cc \u0628\u0647\u0628\u0648\u062f \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<p>\u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0627\u06cc\u0633\u062a\u0627 \u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0641\u0642\u0637 \u062e\u0648\u0627\u0646\u062f\u0646\u06cc \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0647\u0645\u06cc\u0634\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u0646\u062a\u0627\u06cc\u062c \u0631\u0627 \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0628\u0627\u0632 \u0634\u062f\u0646 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0628\u0648\u062f \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc \u062f\u0647\u0646\u062f \u0648 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0627\u0633\u062a\u0627\u062a\u06cc\u06a9 \u062f\u0631 \u0632\u0645\u0627\u0646 \u06a9\u0627\u0645\u067e\u0627\u06cc\u0644 \u062a\u0639\u06cc\u06cc\u0646 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>  \u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc<\/p>\n<p>\u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u062a\u0639\u0631\u06cc\u0641 \u0635\u0631\u06cc\u062d \u062a\u0648\u0633\u0637 \u06a9\u0627\u0631\u0628\u0631 \u0646\u062f\u0627\u0631\u0646\u062f. \u0647\u0631 \u0632\u0645\u0627\u0646 \u06a9\u0647 \u06cc\u06a9 \u0639\u0628\u0627\u0631\u062a DML (INSERT, UPDATE, DELETE) \u06cc\u0627 a SELECT&#8230;INTO \u062f\u0633\u062a\u0648\u0631 \u062f\u0631 PL\/SQL \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f\u060c \u06cc\u06a9 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0636\u0645\u0646\u06cc \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0639\u0644\u0627\u0645 \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>  1. \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0646\u0634\u0627\u0646\u06af\u0631 \u0636\u0645\u0646\u06cc<\/p>\n<p>\u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 PL\/SQL\u060c \u0628\u062f\u0648\u0646 \u0646\u06cc\u0627\u0632 \u0628\u0647 DECLARE\u060c OPEN\u060c FETCH\u060c \u06cc\u0627 CLOSE \u0639\u0645\u0644\u06cc\u0627\u062a<br \/>\n\u0628\u0627\u06cc\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f SELECT cur_name INTO [variable or other data types]. \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u062f OPEN\u060c FETCH\u060c \u0648 CLOSE \u0639\u0645\u0644\u06cc\u0627\u062a<br \/>\n\u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u062a\u0646\u0647\u0627 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0631\u0627 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u0646\u062f. \u0627\u06af\u0631 \u0631\u06a9\u0648\u0631\u062f \u0645\u0646\u0637\u0628\u0642\u06cc \u067e\u06cc\u062f\u0627 \u0646\u0634\u062f\u060c \u0627\u0644\u0641 NO_DATA_FOUND \u0627\u0633\u062a\u062b\u0646\u0627 \u0627\u0646\u062f\u0627\u062e\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0627\u06af\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0631\u06a9\u0648\u0631\u062f \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0634\u0648\u062f\u060c \u0627\u0644\u0641 TOO_MANY_ROWS \u0627\u0633\u062a\u062b\u0646\u0627 \u0631\u062e \u0645\u06cc \u062f\u0647\u062f.<br \/>\n\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u0641\u0642\u0637 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0639\u0644\u0627\u0645\u062a \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0631\u062f SQL% \u062e\u0627\u0646\u0648\u0627\u062f\u0647<br \/>\n\u0628\u0631\u0627\u06cc \u0647\u0631 \u06af\u0648\u0646\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQL%ISOPEN\u060c \u0646\u062a\u06cc\u062c\u0647 \u0647\u0645\u06cc\u0634\u0647 \u0627\u0633\u062a FALSE \u0632\u06cc\u0631\u0627 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc \u062a\u0648\u0633\u0637 PL\/SQL \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u0634\u0648\u0646\u062f.<br \/>\n\u0642\u0628\u0644 \u0627\u0632 \u0628\u0627\u0632 \u0634\u062f\u0646 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0636\u0645\u0646\u06cc\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 SQL%FOUND\u060c SQL%NOTFOUND\u060c \u06cc\u0627 SQL%ROWCOUNT \u0645\u0646\u062c\u0631 \u062e\u0648\u0627\u0647\u062f \u0634\u062f NULL.<\/p>\n<p>  2. \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0634\u062f\u0647 \u0628\u0631\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc<\/p>\n<p>  SQL%ISOPEN<\/p>\n<p>\u0645\u0639\u0646\u06cc: \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0628\u0627\u0632 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631.<br \/>\n\u0647\u0645\u06cc\u0634\u0647 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u062f FALSE \u0632\u06cc\u0631\u0627 \u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc \u0647\u0645\u06cc\u0634\u0647 \u067e\u0633 \u0627\u0632 \u0627\u062c\u0631\u0627 \u0628\u0633\u062a\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.<\/p>\n<p>  SQL%FOUND<\/p>\n<p>\u0645\u0639\u0646\u06cc: \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0631\u062f\u06cc\u0641\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0647 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631.<br \/>\n\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f NULL: \u0646\u0647 SELECT \u06cc\u0627 \u062f\u0633\u062a\u0648\u0631 DML \u0627\u062c\u0631\u0627 \u0634\u062f\u0647 \u0627\u0633\u062a.<br \/>\n\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f TRUE: \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0646\u062f.<br \/>\n\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f FALSE: \u0647\u06cc\u0686 \u0631\u062f\u06cc\u0641\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u0646\u06af\u0631\u0641\u062a.<\/p>\n<p>  SQL%NOTFOUND<\/p>\n<p>\u0645\u0639\u0646\u06cc: \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0647\u06cc\u0686 \u0631\u062f\u06cc\u0641\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u0646\u06af\u0631\u0641\u062a\u0647 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631.<br \/>\n\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f NULL: \u0646\u0647 SELECT \u06cc\u0627 \u062f\u0633\u062a\u0648\u0631 DML \u0627\u062c\u0631\u0627 \u0634\u062f\u0647 \u0627\u0633\u062a.<br \/>\n\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f TRUE: \u0647\u06cc\u0686 \u0631\u062f\u06cc\u0641\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u0646\u06af\u0631\u0641\u062a.<br \/>\n\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f FALSE: \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0646\u062f.<\/p>\n<p>  SQL%ROWCOUNT<\/p>\n<p>\u0645\u0639\u0646\u06cc: \u062a\u0639\u062f\u0627\u062f \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.<br \/>\n\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f NULL: \u0646\u0647 SELECT \u06cc\u0627 \u062f\u0633\u062a\u0648\u0631 DML \u0627\u062c\u0631\u0627 \u0634\u062f\u0647 \u0627\u0633\u062a.<br \/>\n\u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a\u060c \u062a\u0639\u062f\u0627\u062f \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n<p>  \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0635\u0631\u06cc\u062d<\/p>\n<p>  1. \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0622\u0634\u06a9\u0627\u0631<\/p>\n<p>\u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0648\u0627\u0636\u062d \u062a\u0648\u0633\u0637 \u06a9\u0627\u0631\u0628\u0631 \u062a\u0639\u0631\u06cc\u0641 \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u0634\u0648\u0646\u062f.<br \/>\n\u0622\u0646\u0647\u0627 \u0628\u0627\u06cc\u062f \u0627\u0639\u0644\u0627\u0646 \u0634\u062f\u0647 \u0648 \u0628\u0627 \u06cc\u06a9 \u0639\u0628\u0627\u0631\u062a \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0631\u062a\u0628\u0637 \u0634\u0648\u0646\u062f.<br \/>\n\u0622\u0646\u0647\u0627 \u0631\u0627 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u0646\u0633\u0628\u062a \u062f\u0627\u062f\u060c \u062f\u0631 \u0639\u0628\u0627\u0631\u0627\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u060c \u06cc\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0628\u0647 \u0632\u06cc\u0631\u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627 \u06cc\u0627 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u06cc \u0645\u06cc\u0632\u0628\u0627\u0646 \u0627\u0631\u0633\u0627\u0644 \u06a9\u0631\u062f.<br \/>\n\u062f\u0631 \u0645\u0648\u0627\u0642\u0639\u06cc \u06a9\u0647 \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u06cc \u0644\u0627\u0632\u0645 \u0627\u0633\u062a \u0628\u0627\u06cc\u062f \u0627\u0632 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f.<\/p>\n<p>  2. \u0645\u0631\u0627\u062d\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0648\u0627\u0636\u062d<\/p>\n<p>1) \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f: \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0648 \u0639\u0628\u0627\u0631\u062a \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0622\u0646 \u0631\u0627 \u0627\u0639\u0644\u0627\u0645 \u06a9\u0646\u06cc\u062f.2) \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f: \u06a9\u0648\u0626\u0631\u06cc \u0645\u0631\u062a\u0628\u0637 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f\u060c \u0645\u062c\u0645\u0648\u0639\u0647 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 \u0641\u0636\u0627\u06cc \u06a9\u0627\u0631\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0628\u0627\u0631\u06af\u06cc\u0631\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u0642\u0628\u0644 \u0627\u0632 \u0627\u0648\u0644\u06cc\u0646 \u0631\u062f\u06cc\u0641 \u0645\u062c\u0645\u0648\u0639\u0647 \u0646\u062a\u0627\u06cc\u062c \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.3) \u0648\u0627\u06a9\u0634\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627: \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0645\u0648\u0642\u0639\u06cc\u062a \u0645\u0646\u0627\u0633\u0628 \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0646\u062a\u0627\u06cc\u062c \u062d\u0631\u06a9\u062a \u062f\u0647\u06cc\u062f.4) \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u0628\u0628\u0646\u062f\u06cc\u062f: \u067e\u0633 \u0627\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u060c \u0622\u0646 \u0631\u0627 \u0628\u0628\u0646\u062f\u06cc\u062f \u062a\u0627 \u0645\u0646\u0627\u0628\u0639 \u0622\u0632\u0627\u062f \u0634\u0648\u0646\u062f.<\/p>\n<p>  3. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627<\/p>\n<p>  \u0627\u0639\u0644\u0627\u0645\u06cc\u0647 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0648 \u062a\u0639\u0631\u06cc\u0641<\/p>\n<p>DECLARE<br \/>\n   &#8212; Declare cursor c1<br \/>\n   CURSOR c1 RETURN departments%ROWTYPE;<br \/>\n   &#8212; Declare and define cursor c2<br \/>\n   CURSOR c2 IS SELECT employee_id, job_id, salary FROM employees WHERE salary &gt; 2000;<br \/>\n   &#8212; Define cursor c1<br \/>\n   CURSOR c1 RETURN departments%ROWTYPE IS SELECT * FROM departments WHERE department_id = 110;<br \/>\n   &#8212; Declare cursor c3<br \/>\n   CURSOR c3;<br \/>\n   &#8212; Define cursor c3<br \/>\n   CURSOR c3 IS SELECT * FROM locations WHERE country_id = &#8216;JP&#8217;;<br \/>\nBEGIN<br \/>\n   NULL;<br \/>\nEND;<br \/>\n\/<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>  \u0648\u0627\u06a9\u0634\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u06cc \u0645\u0646\u0638\u0645<\/p>\n<p>&#8212; Create table<br \/>\nCREATE TABLE t(id INT, name VARCHAR(10));<br \/>\nINSERT INTO t VALUES(1, &#8216;jack&#8217;);<br \/>\nINSERT INTO t VALUES(2, &#8216;jerry&#8217;);<\/p>\n<p>DECLARE<br \/>\n   v1 INT;<br \/>\n   v2 VARCHAR(10);<br \/>\n   CURSOR c1 IS SELECT id, name FROM t;<br \/>\nBEGIN<br \/>\n   OPEN c1;<br \/>\n   LOOP<br \/>\n       FETCH c1 INTO v1, v2;<br \/>\n       EXIT WHEN c1%NOTFOUND;<br \/>\n       DBMS_OUTPUT.PUT_LINE(&#8216;id = &#8216; || v1);<br \/>\n       DBMS_OUTPUT.PUT_LINE(&#8216;name=&#8221; || v2);<br \/>\n   END LOOP;<\/p>\n<p>   CLOSE c1;<br \/>\nEND;<br \/>\n\/<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>  \u0648\u0627\u06a9\u0634\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u06cc \u0631\u06a9\u0648\u0631\u062f<\/p>\n<p>&#8212; Create table<br \/>\nCREATE TABLE t(id INT, name VARCHAR(10));<br \/>\nINSERT INTO t VALUES(1, &#8220;jack&#8217;);<br \/>\nINSERT INTO t VALUES(2, &#8216;jerry&#8217;);<\/p>\n<p>DECLARE<br \/>\n   v t%ROWTYPE;<br \/>\n   CURSOR c1 IS SELECT id, name FROM t;<br \/>\nBEGIN<br \/>\n   OPEN c1;<br \/>\n   LOOP<br \/>\n       FETCH c1 INTO v;<br \/>\n       EXIT WHEN c1%NOTFOUND;<br \/>\n       DBMS_OUTPUT.PUT_LINE(&#8216;id = &#8216; || v.id);<br \/>\n       DBMS_OUTPUT.PUT_LINE(&#8216;name=&#8221; || v.name);<br \/>\n   END LOOP;<\/p>\n<p>   CLOSE c1;<br \/>\nEND;<br \/>\n\/<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>  \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0628\u0627 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 (\u0628\u0627\u0632 \u06a9\u0631\u062f\u0646 \u0642\u0628\u0644 \u0627\u0632 \u062a\u0645\u0627\u0633)<\/p>\n<p>&#8212; Create table<br \/>\nCREATE TABLE t(id INT, name VARCHAR(10));<br \/>\nINSERT INTO t VALUES(1, &#8220;jack&#8217;);<br \/>\nINSERT INTO t VALUES(2, &#8216;jerry&#8217;);<\/p>\n<p>DECLARE<br \/>\nCURSOR c (c_id INT) IS SELECT name FROM t WHERE id = c_id;<br \/>\n&#8212; Define procedure<br \/>\nPROCEDURE p1 IS<br \/>\np_name VARCHAR(10);<br \/>\nBEGIN<br \/>\n   LOOP<br \/>\n       FETCH c INTO p_name;<br \/>\n       EXIT WHEN c%NOTFOUND;<br \/>\n       DBMS_OUTPUT.PUT_LINE(&#8216;result is: &#8216; || p_name);<br \/>\n   END LOOP;<br \/>\nEND;<\/p>\n<p>BEGIN<br \/>\n   OPEN c(2);   &#8212; Open the cursor<br \/>\n   p1;          &#8212; Call the procedure<br \/>\n   CLOSE c;     &#8212; Close the cursor<br \/>\nEND;<br \/>\n\/<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u0628\u0627 \u0627\u06cc\u0646 \u0645\u0642\u062f\u0645\u0647 \u0645\u0641\u0635\u0644\u060c \u0627\u06a9\u0646\u0648\u0646 \u062f\u0631\u06a9 \u062e\u0648\u0628\u06cc \u0627\u0632 \u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0627\u0633\u062a\u0627\u062a\u06cc\u06a9 \u062f\u0631 GBase 8s \u0648 \u0646\u062d\u0648\u0647 \u0627\u0639\u0645\u0627\u0644 \u0622\u0646\u0647\u0627 \u062f\u0627\u0631\u06cc\u062f. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0635\u062d\u06cc\u062d \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627 \u0646\u0647 \u062a\u0646\u0647\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u06a9\u0627\u0631\u0627\u06cc\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0647\u0628\u0648\u062f \u0628\u062e\u0634\u062f\u060c \u0628\u0644\u06a9\u0647 \u06a9\u062f \u0634\u0645\u0627 \u0631\u0627 \u0634\u0641\u0627\u0641 \u062a\u0631 \u0648 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0622\u0633\u0627\u0646 \u062a\u0631 \u0645\u06cc \u06a9\u0646\u062f. \u0627\u0645\u06cc\u062f\u0648\u0627\u0631\u0645 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0647 \u0634\u0645\u0627 \u062f\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0647\u062a\u0631 \u0627\u0632 \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 GBase 8s \u06a9\u0645\u06a9 \u06a9\u0646\u062f. \u0628\u0627 \u062a\u0634\u06a9\u0631 \u0627\u0632 \u0634\u0645\u0627 \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646!<\/p>\n<div data-article-id=\"1987459\" id=\"article-body\">\n<p>GBase 8s \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u0627\u0632\u06af\u0627\u0631 \u0628\u0627 \u0632\u0628\u0627\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc PL\/SQL Oracle \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u060c \u0627\u0639\u0644\u0627\u0646 \u0648 \u062a\u062e\u0635\u06cc\u0635 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u060c \u062a\u0631\u062a\u06cc\u0628\u060c \u0627\u0646\u062a\u062e\u0627\u0628\u060c \u06a9\u0646\u062a\u0631\u0644 \u062d\u0644\u0642\u0647\u060c \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u062b\u0628\u062a \u0627\u0634\u06cc\u0627\u0621\u060c SQL \u0627\u0633\u062a\u0627\u062a\u06cc\u06a9 \u0648 \u067e\u0648\u06cc\u0627 \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062e\u0637\u0627 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f. \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0631 \u0631\u0648\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u062b\u0627\u0628\u062a \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u0645\u0631\u06a9\u0632 \u062f\u0627\u0631\u062f. GBase 8s \u062f\u0648 \u0646\u0648\u0639 \u0646\u0634\u0627\u0646\u06af\u0631 \u062b\u0627\u0628\u062a \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f: \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc \u0648 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0622\u0634\u06a9\u0627\u0631. \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u062a\u0648\u0636\u06cc\u062d \u0645\u0641\u0635\u0644\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0627\u06cc\u0633\u062a\u0627 \u062f\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 GBase 8s\u060c \u0627\u0632 \u062c\u0645\u0644\u0647 \u0645\u0648\u0627\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647\u060c \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627 \u0648 \u0646\u062d\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u0648\u062b\u0631 \u0627\u0632 \u0622\u0646\u0647\u0627 \u0628\u0631\u0627\u06cc \u0628\u0647\u0628\u0648\u062f \u06a9\u0627\u0631\u0627\u06cc\u06cc \u0639\u0645\u0644\u06cc\u0627\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<p>\u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0627\u06cc\u0633\u062a\u0627 \u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0641\u0642\u0637 \u062e\u0648\u0627\u0646\u062f\u0646\u06cc \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0647\u0645\u06cc\u0634\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u0646\u062a\u0627\u06cc\u062c \u0631\u0627 \u0647\u0645\u0627\u0646\u0637\u0648\u0631 \u06a9\u0647 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0628\u0627\u0632 \u0634\u062f\u0646 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0628\u0648\u062f \u0646\u0645\u0627\u06cc\u0634 \u0645\u06cc \u062f\u0647\u0646\u062f \u0648 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0627\u0633\u062a\u0627\u062a\u06cc\u06a9 \u062f\u0631 \u0632\u0645\u0627\u0646 \u06a9\u0627\u0645\u067e\u0627\u06cc\u0644 \u062a\u0639\u06cc\u06cc\u0646 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#%D9%86%D8%B4%D8%A7%D9%86%DA%AF%D8%B1%D9%87%D8%A7%DB%8C_%D8%B6%D9%85%D9%86%DB%8C\" >\u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#1_%D9%88%DB%8C%DA%98%DA%AF%DB%8C_%D9%87%D8%A7%DB%8C_%D9%86%D8%B4%D8%A7%D9%86%DA%AF%D8%B1_%D8%B6%D9%85%D9%86%DB%8C\" >1. \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0646\u0634\u0627\u0646\u06af\u0631 \u0636\u0645\u0646\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#2_%D9%88%DB%8C%DA%98%DA%AF%DB%8C_%D9%87%D8%A7%DB%8C_%D9%BE%D8%B4%D8%AA%DB%8C%D8%A8%D8%A7%D9%86%DB%8C_%D8%B4%D8%AF%D9%87_%D8%A8%D8%B1%D8%A7%DB%8C_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7%D9%87%D8%A7%DB%8C_%D8%B6%D9%85%D9%86%DB%8C\" >2. \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0634\u062f\u0647 \u0628\u0631\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#SQLISOPEN\" >SQL%ISOPEN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#SQLFOUND\" >SQL%FOUND<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#SQLNOTFOUND\" >SQL%NOTFOUND<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#SQLROWCOUNT\" >SQL%ROWCOUNT<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7%D9%87%D8%A7%DB%8C_%D8%B5%D8%B1%DB%8C%D8%AD\" >\u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0635\u0631\u06cc\u062d<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#1_%D9%88%DB%8C%DA%98%DA%AF%DB%8C_%D9%87%D8%A7%DB%8C_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7_%D8%A2%D8%B4%DA%A9%D8%A7%D8%B1\" >1. \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0622\u0634\u06a9\u0627\u0631<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#2_%D9%85%D8%B1%D8%A7%D8%AD%D9%84_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7%D9%87%D8%A7%DB%8C_%D9%88%D8%A7%D8%B6%D8%AD\" >2. \u0645\u0631\u0627\u062d\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0648\u0627\u0636\u062d<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#3_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7\" >3. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#%D8%A7%D8%B9%D9%84%D8%A7%D9%85%DB%8C%D9%87_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7_%D9%88_%D8%AA%D8%B9%D8%B1%DB%8C%D9%81\" >\u0627\u0639\u0644\u0627\u0645\u06cc\u0647 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0648 \u062a\u0639\u0631\u06cc\u0641<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#%D9%88%D8%A7%DA%A9%D8%B4%DB%8C_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%AF%D8%B1_%D9%85%D8%AA%D8%BA%DB%8C%D8%B1%D9%87%D8%A7%DB%8C_%D9%85%D9%86%D8%B8%D9%85\" >\u0648\u0627\u06a9\u0634\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u06cc \u0645\u0646\u0638\u0645<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#%D9%88%D8%A7%DA%A9%D8%B4%DB%8C_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%AF%D8%B1_%D9%85%D8%AA%D8%BA%DB%8C%D8%B1%D9%87%D8%A7%DB%8C_%D8%B1%DA%A9%D9%88%D8%B1%D8%AF\" >\u0648\u0627\u06a9\u0634\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u06cc \u0631\u06a9\u0648\u0631\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/nabfollower.com\/blog\/introduction-to-gbase-8s-static-cursor-2bl8\/#%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7_%D8%A8%D8%A7_%D9%BE%D8%A7%D8%B1%D8%A7%D9%85%D8%AA%D8%B1%D9%87%D8%A7_%D8%A8%D8%A7%D8%B2_%DA%A9%D8%B1%D8%AF%D9%86_%D9%82%D8%A8%D9%84_%D8%A7%D8%B2_%D8%AA%D9%85%D8%A7%D8%B3\" >\u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0628\u0627 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 (\u0628\u0627\u0632 \u06a9\u0631\u062f\u0646 \u0642\u0628\u0644 \u0627\u0632 \u062a\u0645\u0627\u0633)<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D8%B4%D8%A7%D9%86%DA%AF%D8%B1%D9%87%D8%A7%DB%8C_%D8%B6%D9%85%D9%86%DB%8C\"><\/span>\n<p>  \u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u062a\u0639\u0631\u06cc\u0641 \u0635\u0631\u06cc\u062d \u062a\u0648\u0633\u0637 \u06a9\u0627\u0631\u0628\u0631 \u0646\u062f\u0627\u0631\u0646\u062f. \u0647\u0631 \u0632\u0645\u0627\u0646 \u06a9\u0647 \u06cc\u06a9 \u0639\u0628\u0627\u0631\u062a DML (INSERT, UPDATE, DELETE) \u06cc\u0627 a <code>SELECT...INTO<\/code> \u062f\u0633\u062a\u0648\u0631 \u062f\u0631 PL\/SQL \u0627\u062c\u0631\u0627 \u0645\u06cc \u0634\u0648\u062f\u060c \u06cc\u06a9 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0636\u0645\u0646\u06cc \u0628\u0647 \u0637\u0648\u0631 \u062e\u0648\u062f\u06a9\u0627\u0631 \u0627\u0639\u0644\u0627\u0645 \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_%D9%88%DB%8C%DA%98%DA%AF%DB%8C_%D9%87%D8%A7%DB%8C_%D9%86%D8%B4%D8%A7%D9%86%DA%AF%D8%B1_%D8%B6%D9%85%D9%86%DB%8C\"><\/span>\n<p>  1. \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0646\u0634\u0627\u0646\u06af\u0631 \u0636\u0645\u0646\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 PL\/SQL\u060c \u0628\u062f\u0648\u0646 \u0646\u06cc\u0627\u0632 \u0628\u0647 <code>DECLARE<\/code>\u060c <code>OPEN<\/code>\u060c <code>FETCH<\/code>\u060c \u06cc\u0627 <code>CLOSE<\/code> \u0639\u0645\u0644\u06cc\u0627\u062a<\/li>\n<li>\u0628\u0627\u06cc\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f <code>SELECT cur_name INTO [variable or other data types]<\/code>. \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u062f <code>OPEN<\/code>\u060c <code>FETCH<\/code>\u060c \u0648 <code>CLOSE<\/code> \u0639\u0645\u0644\u06cc\u0627\u062a<\/li>\n<li>\u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u062a\u0646\u0647\u0627 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u0631\u0627 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u0646\u062f. \u0627\u06af\u0631 \u0631\u06a9\u0648\u0631\u062f \u0645\u0646\u0637\u0628\u0642\u06cc \u067e\u06cc\u062f\u0627 \u0646\u0634\u062f\u060c \u0627\u0644\u0641 <code>NO_DATA_FOUND<\/code> \u0627\u0633\u062a\u062b\u0646\u0627 \u0627\u0646\u062f\u0627\u062e\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0627\u06af\u0631 \u0686\u0646\u062f\u06cc\u0646 \u0631\u06a9\u0648\u0631\u062f \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0634\u0648\u062f\u060c \u0627\u0644\u0641 <code>TOO_MANY_ROWS<\/code> \u0627\u0633\u062a\u062b\u0646\u0627 \u0631\u062e \u0645\u06cc \u062f\u0647\u062f.<\/li>\n<li>\u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u0641\u0642\u0637 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0639\u0644\u0627\u0645\u062a \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0631\u062f <code>SQL%<\/code> \u062e\u0627\u0646\u0648\u0627\u062f\u0647<\/li>\n<li>\u0628\u0631\u0627\u06cc \u0647\u0631 \u06af\u0648\u0646\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>SQL%ISOPEN<\/code>\u060c \u0646\u062a\u06cc\u062c\u0647 \u0647\u0645\u06cc\u0634\u0647 \u0627\u0633\u062a <code>FALSE<\/code> \u0632\u06cc\u0631\u0627 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc \u062a\u0648\u0633\u0637 PL\/SQL \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u0634\u0648\u0646\u062f.<\/li>\n<li>\u0642\u0628\u0644 \u0627\u0632 \u0628\u0627\u0632 \u0634\u062f\u0646 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0636\u0645\u0646\u06cc\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 <code>SQL%FOUND<\/code>\u060c <code>SQL%NOTFOUND<\/code>\u060c \u06cc\u0627 <code>SQL%ROWCOUNT<\/code> \u0645\u0646\u062c\u0631 \u062e\u0648\u0627\u0647\u062f \u0634\u062f <code>NULL<\/code>.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"2_%D9%88%DB%8C%DA%98%DA%AF%DB%8C_%D9%87%D8%A7%DB%8C_%D9%BE%D8%B4%D8%AA%DB%8C%D8%A8%D8%A7%D9%86%DB%8C_%D8%B4%D8%AF%D9%87_%D8%A8%D8%B1%D8%A7%DB%8C_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7%D9%87%D8%A7%DB%8C_%D8%B6%D9%85%D9%86%DB%8C\"><\/span>\n<p>  2. \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0634\u062f\u0647 \u0628\u0631\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"SQLISOPEN\"><\/span>\n<p>  <code>SQL%ISOPEN<\/code><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\n<strong>\u0645\u0639\u0646\u06cc<\/strong>: \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0628\u0627\u0632 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631.<\/li>\n<li>\u0647\u0645\u06cc\u0634\u0647 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u062f <code>FALSE<\/code> \u0632\u06cc\u0631\u0627 \u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0636\u0645\u0646\u06cc \u0647\u0645\u06cc\u0634\u0647 \u067e\u0633 \u0627\u0632 \u0627\u062c\u0631\u0627 \u0628\u0633\u062a\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"SQLFOUND\"><\/span>\n<p>  <code>SQL%FOUND<\/code><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\n<strong>\u0645\u0639\u0646\u06cc<\/strong>: \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0631\u062f\u06cc\u0641\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0647 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631.<\/li>\n<li>\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f <code>NULL<\/code>: \u0646\u0647 <code>SELECT<\/code> \u06cc\u0627 \u062f\u0633\u062a\u0648\u0631 DML \u0627\u062c\u0631\u0627 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<li>\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f <code>TRUE<\/code>: \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0646\u062f.<\/li>\n<li>\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f <code>FALSE<\/code>: \u0647\u06cc\u0686 \u0631\u062f\u06cc\u0641\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u0646\u06af\u0631\u0641\u062a.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"SQLNOTFOUND\"><\/span>\n<p>  <code>SQL%NOTFOUND<\/code><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\n<strong>\u0645\u0639\u0646\u06cc<\/strong>: \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0622\u06cc\u0627 \u0647\u06cc\u0686 \u0631\u062f\u06cc\u0641\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u0646\u06af\u0631\u0641\u062a\u0647 \u0627\u0633\u062a \u06cc\u0627 \u062e\u06cc\u0631.<\/li>\n<li>\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f <code>NULL<\/code>: \u0646\u0647 <code>SELECT<\/code> \u06cc\u0627 \u062f\u0633\u062a\u0648\u0631 DML \u0627\u062c\u0631\u0627 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<li>\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f <code>TRUE<\/code>: \u0647\u06cc\u0686 \u0631\u062f\u06cc\u0641\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u0646\u06af\u0631\u0641\u062a.<\/li>\n<li>\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f <code>FALSE<\/code>: \u06cc\u06a9 \u06cc\u0627 \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a\u0646\u062f.<\/li>\n<\/ul>\n<h4><span class=\"ez-toc-section\" id=\"SQLROWCOUNT\"><\/span>\n<p>  <code>SQL%ROWCOUNT<\/code><br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<ul>\n<li>\n<strong>\u0645\u0639\u0646\u06cc<\/strong>: \u062a\u0639\u062f\u0627\u062f \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n<li>\u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f <code>NULL<\/code>: \u0646\u0647 <code>SELECT<\/code> \u06cc\u0627 \u062f\u0633\u062a\u0648\u0631 DML \u0627\u062c\u0631\u0627 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<li>\u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a\u060c \u062a\u0639\u062f\u0627\u062f \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u062a\u062d\u062a \u062a\u0623\u062b\u06cc\u0631 \u0631\u0627 \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u062f.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7%D9%87%D8%A7%DB%8C_%D8%B5%D8%B1%DB%8C%D8%AD\"><\/span>\n<p>  \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0635\u0631\u06cc\u062d<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_%D9%88%DB%8C%DA%98%DA%AF%DB%8C_%D9%87%D8%A7%DB%8C_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7_%D8%A2%D8%B4%DA%A9%D8%A7%D8%B1\"><\/span>\n<p>  1. \u0648\u06cc\u0698\u06af\u06cc \u0647\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0622\u0634\u06a9\u0627\u0631<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li>\u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0648\u0627\u0636\u062d \u062a\u0648\u0633\u0637 \u06a9\u0627\u0631\u0628\u0631 \u062a\u0639\u0631\u06cc\u0641 \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u0634\u0648\u0646\u062f.<\/li>\n<li>\u0622\u0646\u0647\u0627 \u0628\u0627\u06cc\u062f \u0627\u0639\u0644\u0627\u0646 \u0634\u062f\u0647 \u0648 \u0628\u0627 \u06cc\u06a9 \u0639\u0628\u0627\u0631\u062a \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0631\u062a\u0628\u0637 \u0634\u0648\u0646\u062f.<\/li>\n<li>\u0622\u0646\u0647\u0627 \u0631\u0627 \u0646\u0645\u06cc \u062a\u0648\u0627\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631\u06cc \u0646\u0633\u0628\u062a \u062f\u0627\u062f\u060c \u062f\u0631 \u0639\u0628\u0627\u0631\u0627\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u060c \u06cc\u0627 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u067e\u0627\u0631\u0627\u0645\u062a\u0631 \u0628\u0647 \u0632\u06cc\u0631\u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627 \u06cc\u0627 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u06cc \u0645\u06cc\u0632\u0628\u0627\u0646 \u0627\u0631\u0633\u0627\u0644 \u06a9\u0631\u062f.<\/li>\n<li>\u062f\u0631 \u0645\u0648\u0627\u0642\u0639\u06cc \u06a9\u0647 \u0627\u0646\u0639\u0637\u0627\u0641 \u067e\u0630\u06cc\u0631\u06cc \u0644\u0627\u0632\u0645 \u0627\u0633\u062a \u0628\u0627\u06cc\u062f \u0627\u0632 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"2_%D9%85%D8%B1%D8%A7%D8%AD%D9%84_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7%D9%87%D8%A7%DB%8C_%D9%88%D8%A7%D8%B6%D8%AD\"><\/span>\n<p>  2. \u0645\u0631\u0627\u062d\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627\u06cc \u0648\u0627\u0636\u062d<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>1) <strong>\u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f<\/strong>: \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0648 \u0639\u0628\u0627\u0631\u062a \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0622\u0646 \u0631\u0627 \u0627\u0639\u0644\u0627\u0645 \u06a9\u0646\u06cc\u062f.<br \/>2) <strong>\u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f<\/strong>: \u06a9\u0648\u0626\u0631\u06cc \u0645\u0631\u062a\u0628\u0637 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f\u060c \u0645\u062c\u0645\u0648\u0639\u0647 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 \u0641\u0636\u0627\u06cc \u06a9\u0627\u0631\u06cc \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0628\u0627\u0631\u06af\u06cc\u0631\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u0642\u0628\u0644 \u0627\u0632 \u0627\u0648\u0644\u06cc\u0646 \u0631\u062f\u06cc\u0641 \u0645\u062c\u0645\u0648\u0639\u0647 \u0646\u062a\u0627\u06cc\u062c \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.<br \/>3) <strong>\u0648\u0627\u06a9\u0634\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627<\/strong>: \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u062f\u0631 \u0635\u0648\u0631\u062a \u0646\u06cc\u0627\u0632 \u0628\u0647 \u0645\u0648\u0642\u0639\u06cc\u062a \u0645\u0646\u0627\u0633\u0628 \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0646\u062a\u0627\u06cc\u062c \u062d\u0631\u06a9\u062a \u062f\u0647\u06cc\u062f.<br \/>4) <strong>\u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0631\u0627 \u0628\u0628\u0646\u062f\u06cc\u062f<\/strong>: \u067e\u0633 \u0627\u0632 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u060c \u0622\u0646 \u0631\u0627 \u0628\u0628\u0646\u062f\u06cc\u062f \u062a\u0627 \u0645\u0646\u0627\u0628\u0639 \u0622\u0632\u0627\u062f \u0634\u0648\u0646\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7\"><\/span>\n<p>  3. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<h4><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B9%D9%84%D8%A7%D9%85%DB%8C%D9%87_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7_%D9%88_%D8%AA%D8%B9%D8%B1%DB%8C%D9%81\"><\/span>\n<p>  \u0627\u0639\u0644\u0627\u0645\u06cc\u0647 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0648 \u062a\u0639\u0631\u06cc\u0641<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">DECLARE<\/span>\n   <span class=\"c1\">-- Declare cursor c1<\/span>\n   <span class=\"k\">CURSOR<\/span> <span class=\"n\">c1<\/span> <span class=\"k\">RETURN<\/span> <span class=\"n\">departments<\/span><span class=\"o\">%<\/span><span class=\"n\">ROWTYPE<\/span><span class=\"p\">;<\/span>  \n   <span class=\"c1\">-- Declare and define cursor c2<\/span>\n   <span class=\"k\">CURSOR<\/span> <span class=\"n\">c2<\/span> <span class=\"k\">IS<\/span> <span class=\"k\">SELECT<\/span> <span class=\"n\">employee_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">job_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">salary<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">employees<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">salary<\/span> <span class=\"o\">&gt;<\/span> <span class=\"mi\">2000<\/span><span class=\"p\">;<\/span>\n   <span class=\"c1\">-- Define cursor c1<\/span>\n   <span class=\"k\">CURSOR<\/span> <span class=\"n\">c1<\/span> <span class=\"k\">RETURN<\/span> <span class=\"n\">departments<\/span><span class=\"o\">%<\/span><span class=\"n\">ROWTYPE<\/span> <span class=\"k\">IS<\/span> <span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">departments<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">department_id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">110<\/span><span class=\"p\">;<\/span>\n   <span class=\"c1\">-- Declare cursor c3<\/span>\n   <span class=\"k\">CURSOR<\/span> <span class=\"n\">c3<\/span><span class=\"p\">;<\/span>      \n   <span class=\"c1\">-- Define cursor c3<\/span>\n   <span class=\"k\">CURSOR<\/span> <span class=\"n\">c3<\/span> <span class=\"k\">IS<\/span> <span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">locations<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">country_id<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'JP'<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">BEGIN<\/span>\n   <span class=\"k\">NULL<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">END<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">\/<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"%D9%88%D8%A7%DA%A9%D8%B4%DB%8C_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%AF%D8%B1_%D9%85%D8%AA%D8%BA%DB%8C%D8%B1%D9%87%D8%A7%DB%8C_%D9%85%D9%86%D8%B8%D9%85\"><\/span>\n<p>  \u0648\u0627\u06a9\u0634\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u06cc \u0645\u0646\u0638\u0645<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Create table<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">t<\/span><span class=\"p\">(<\/span><span class=\"n\">id<\/span> <span class=\"nb\">INT<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">10<\/span><span class=\"p\">));<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">t<\/span> <span class=\"k\">VALUES<\/span><span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'jack'<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">t<\/span> <span class=\"k\">VALUES<\/span><span class=\"p\">(<\/span><span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'jerry'<\/span><span class=\"p\">);<\/span>\n\n<span class=\"k\">DECLARE<\/span> \n   <span class=\"n\">v1<\/span> <span class=\"nb\">INT<\/span><span class=\"p\">;<\/span>\n   <span class=\"n\">v2<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">10<\/span><span class=\"p\">);<\/span>\n   <span class=\"k\">CURSOR<\/span> <span class=\"n\">c1<\/span> <span class=\"k\">IS<\/span> <span class=\"k\">SELECT<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">t<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">BEGIN<\/span>\n   <span class=\"k\">OPEN<\/span> <span class=\"n\">c1<\/span><span class=\"p\">;<\/span>\n   <span class=\"n\">LOOP<\/span>\n       <span class=\"k\">FETCH<\/span> <span class=\"n\">c1<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">v1<\/span><span class=\"p\">,<\/span> <span class=\"n\">v2<\/span><span class=\"p\">;<\/span>\n       <span class=\"n\">EXIT<\/span> <span class=\"k\">WHEN<\/span> <span class=\"n\">c1<\/span><span class=\"o\">%<\/span><span class=\"n\">NOTFOUND<\/span><span class=\"p\">;<\/span>\n       <span class=\"n\">DBMS_OUTPUT<\/span><span class=\"p\">.<\/span><span class=\"n\">PUT_LINE<\/span><span class=\"p\">(<\/span><span class=\"s1\">'id = '<\/span> <span class=\"o\">||<\/span> <span class=\"n\">v1<\/span><span class=\"p\">);<\/span>\n       <span class=\"n\">DBMS_OUTPUT<\/span><span class=\"p\">.<\/span><span class=\"n\">PUT_LINE<\/span><span class=\"p\">(<\/span><span class=\"s1\">'name=\"<\/span> <span class=\"o\">||<\/span> <span class=\"n\">v2<\/span><span class=\"p\">);<\/span>\n   <span class=\"k\">END<\/span> <span class=\"n\">LOOP<\/span><span class=\"p\">;<\/span>\n\n   <span class=\"k\">CLOSE<\/span> <span class=\"n\">c1<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">END<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">\/<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"%D9%88%D8%A7%DA%A9%D8%B4%DB%8C_%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%AF%D8%B1_%D9%85%D8%AA%D8%BA%DB%8C%D8%B1%D9%87%D8%A7%DB%8C_%D8%B1%DA%A9%D9%88%D8%B1%D8%AF\"><\/span>\n<p>  \u0648\u0627\u06a9\u0634\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u06cc \u0631\u06a9\u0648\u0631\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Create table<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">t<\/span><span class=\"p\">(<\/span><span class=\"n\">id<\/span> <span class=\"nb\">INT<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">10<\/span><span class=\"p\">));<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">t<\/span> <span class=\"k\">VALUES<\/span><span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"s1\">\"jack'<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">t<\/span> <span class=\"k\">VALUES<\/span><span class=\"p\">(<\/span><span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'jerry'<\/span><span class=\"p\">);<\/span>\n\n<span class=\"k\">DECLARE<\/span> \n   <span class=\"n\">v<\/span> <span class=\"n\">t<\/span><span class=\"o\">%<\/span><span class=\"n\">ROWTYPE<\/span><span class=\"p\">;<\/span>\n   <span class=\"k\">CURSOR<\/span> <span class=\"n\">c1<\/span> <span class=\"k\">IS<\/span> <span class=\"k\">SELECT<\/span> <span class=\"n\">id<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">t<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">BEGIN<\/span>\n   <span class=\"k\">OPEN<\/span> <span class=\"n\">c1<\/span><span class=\"p\">;<\/span>\n   <span class=\"n\">LOOP<\/span>\n       <span class=\"k\">FETCH<\/span> <span class=\"n\">c1<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">v<\/span><span class=\"p\">;<\/span>\n       <span class=\"n\">EXIT<\/span> <span class=\"k\">WHEN<\/span> <span class=\"n\">c1<\/span><span class=\"o\">%<\/span><span class=\"n\">NOTFOUND<\/span><span class=\"p\">;<\/span>\n       <span class=\"n\">DBMS_OUTPUT<\/span><span class=\"p\">.<\/span><span class=\"n\">PUT_LINE<\/span><span class=\"p\">(<\/span><span class=\"s1\">'id = '<\/span> <span class=\"o\">||<\/span> <span class=\"n\">v<\/span><span class=\"p\">.<\/span><span class=\"n\">id<\/span><span class=\"p\">);<\/span>\n       <span class=\"n\">DBMS_OUTPUT<\/span><span class=\"p\">.<\/span><span class=\"n\">PUT_LINE<\/span><span class=\"p\">(<\/span><span class=\"s1\">'name=\"<\/span> <span class=\"o\">||<\/span> <span class=\"n\">v<\/span><span class=\"p\">.<\/span><span class=\"n\">name<\/span><span class=\"p\">);<\/span>\n   <span class=\"k\">END<\/span> <span class=\"n\">LOOP<\/span><span class=\"p\">;<\/span>\n\n   <span class=\"k\">CLOSE<\/span> <span class=\"n\">c1<\/span><span class=\"p\">;<\/span>\n<span class=\"k\">END<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">\/<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_%D9%85%DA%A9%D8%A7%D9%86_%D9%86%D9%85%D8%A7_%D8%A8%D8%A7_%D9%BE%D8%A7%D8%B1%D8%A7%D9%85%D8%AA%D8%B1%D9%87%D8%A7_%D8%A8%D8%A7%D8%B2_%DA%A9%D8%B1%D8%AF%D9%86_%D9%82%D8%A8%D9%84_%D8%A7%D8%B2_%D8%AA%D9%85%D8%A7%D8%B3\"><\/span>\n<p>  \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 \u0628\u0627 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627 (\u0628\u0627\u0632 \u06a9\u0631\u062f\u0646 \u0642\u0628\u0644 \u0627\u0632 \u062a\u0645\u0627\u0633)<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Create table<\/span>\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">t<\/span><span class=\"p\">(<\/span><span class=\"n\">id<\/span> <span class=\"nb\">INT<\/span><span class=\"p\">,<\/span> <span class=\"n\">name<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">10<\/span><span class=\"p\">));<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">t<\/span> <span class=\"k\">VALUES<\/span><span class=\"p\">(<\/span><span class=\"mi\">1<\/span><span class=\"p\">,<\/span> <span class=\"s1\">\"jack'<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">t<\/span> <span class=\"k\">VALUES<\/span><span class=\"p\">(<\/span><span class=\"mi\">2<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'jerry'<\/span><span class=\"p\">);<\/span>\n\n<span class=\"k\">DECLARE<\/span>\n<span class=\"k\">CURSOR<\/span> <span class=\"k\">c<\/span> <span class=\"p\">(<\/span><span class=\"n\">c_id<\/span> <span class=\"nb\">INT<\/span><span class=\"p\">)<\/span> <span class=\"k\">IS<\/span> <span class=\"k\">SELECT<\/span> <span class=\"n\">name<\/span> <span class=\"k\">FROM<\/span> <span class=\"n\">t<\/span> <span class=\"k\">WHERE<\/span> <span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"n\">c_id<\/span><span class=\"p\">;<\/span>\n<span class=\"c1\">-- Define procedure<\/span>\n<span class=\"k\">PROCEDURE<\/span> <span class=\"n\">p1<\/span> <span class=\"k\">IS<\/span>\n<span class=\"n\">p_name<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">10<\/span><span class=\"p\">);<\/span>\n<span class=\"k\">BEGIN<\/span>\n   <span class=\"n\">LOOP<\/span>   \n       <span class=\"k\">FETCH<\/span> <span class=\"k\">c<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">p_name<\/span><span class=\"p\">;<\/span>\n       <span class=\"n\">EXIT<\/span> <span class=\"k\">WHEN<\/span> <span class=\"k\">c<\/span><span class=\"o\">%<\/span><span class=\"n\">NOTFOUND<\/span><span class=\"p\">;<\/span>\n       <span class=\"n\">DBMS_OUTPUT<\/span><span class=\"p\">.<\/span><span class=\"n\">PUT_LINE<\/span><span class=\"p\">(<\/span><span class=\"s1\">'result is: '<\/span> <span class=\"o\">||<\/span> <span class=\"n\">p_name<\/span><span class=\"p\">);<\/span>\n   <span class=\"k\">END<\/span> <span class=\"n\">LOOP<\/span><span class=\"p\">;<\/span>   \n<span class=\"k\">END<\/span><span class=\"p\">;<\/span>\n\n<span class=\"k\">BEGIN<\/span>\n   <span class=\"k\">OPEN<\/span> <span class=\"k\">c<\/span><span class=\"p\">(<\/span><span class=\"mi\">2<\/span><span class=\"p\">);<\/span>   <span class=\"c1\">-- Open the cursor<\/span>\n   <span class=\"n\">p1<\/span><span class=\"p\">;<\/span>          <span class=\"c1\">-- Call the procedure<\/span>\n   <span class=\"k\">CLOSE<\/span> <span class=\"k\">c<\/span><span class=\"p\">;<\/span>     <span class=\"c1\">-- Close the cursor<\/span>\n<span class=\"k\">END<\/span><span class=\"p\">;<\/span>\n<span class=\"o\">\/<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0628\u0627 \u0627\u06cc\u0646 \u0645\u0642\u062f\u0645\u0647 \u0645\u0641\u0635\u0644\u060c \u0627\u06a9\u0646\u0648\u0646 \u062f\u0631\u06a9 \u062e\u0648\u0628\u06cc \u0627\u0632 \u0646\u0634\u0627\u0646\u06af\u0631\u0647\u0627\u06cc \u0627\u0633\u062a\u0627\u062a\u06cc\u06a9 \u062f\u0631 GBase 8s \u0648 \u0646\u062d\u0648\u0647 \u0627\u0639\u0645\u0627\u0644 \u0622\u0646\u0647\u0627 \u062f\u0627\u0631\u06cc\u062f. \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0635\u062d\u06cc\u062d \u0627\u0632 \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627\u0647\u0627 \u0646\u0647 \u062a\u0646\u0647\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u06a9\u0627\u0631\u0627\u06cc\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0647\u0628\u0648\u062f \u0628\u062e\u0634\u062f\u060c \u0628\u0644\u06a9\u0647 \u06a9\u062f \u0634\u0645\u0627 \u0631\u0627 \u0634\u0641\u0627\u0641 \u062a\u0631 \u0648 \u0646\u06af\u0647\u062f\u0627\u0631\u06cc \u0622\u0633\u0627\u0646 \u062a\u0631 \u0645\u06cc \u06a9\u0646\u062f. \u0627\u0645\u06cc\u062f\u0648\u0627\u0631\u0645 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0647 \u0634\u0645\u0627 \u062f\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0628\u0647\u062a\u0631 \u0627\u0632 \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u06a9\u0627\u0646 \u0646\u0645\u0627 GBase 8s \u06a9\u0645\u06a9 \u06a9\u0646\u062f. \u0628\u0627 \u062a\u0634\u06a9\u0631 \u0627\u0632 \u0634\u0645\u0627 \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646!<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summarize this content to 400 words in Persian Lang GBase 8s \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0633\u0627\u0632\u06af\u0627\u0631 \u0628\u0627 \u0632\u0628\u0627\u0646 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc PL\/SQL Oracle \u0627\u0633\u062a \u06a9\u0647 \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u060c \u0627\u0639\u0644\u0627\u0646 \u0648 \u062a\u062e\u0635\u06cc\u0635 \u0645\u062a\u063a\u06cc\u0631\u0647\u0627\u060c \u062a\u0631\u062a\u06cc\u0628\u060c \u0627\u0646\u062a\u062e\u0627\u0628\u060c \u06a9\u0646\u062a\u0631\u0644 \u062d\u0644\u0642\u0647\u060c \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u062b\u0628\u062a \u0627\u0634\u06cc\u0627\u0621\u060c SQL \u0627\u0633\u062a\u0627\u062a\u06cc\u06a9 \u0648 \u067e\u0648\u06cc\u0627 \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a \u062e\u0637\u0627 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u062f. \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u0628\u0631 \u0631\u0648\u06cc &hellip;<\/p>\n","protected":false},"author":2,"featured_media":75772,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-75771","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/75771","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=75771"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/75771\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/75772"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=75771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=75771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=75771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}