��� [ORDER BY 節] [FOR UPDATE 節] WITH {RR|RS|CS|UR}
SELECTæ–‡ã?¯å•?å?ˆã?›ã?¨ã€?çœ?ç•¥å?¯èƒ½ã?ªORDER BY 節ã?¨FOR UPDATE 節ã?‹ã‚‰æ§‹æˆ?ã?•れã?¾ã?™ã€‚ SELECTæ–‡ã?¯ã€?å•?å?ˆã?›ã?®æœ€åˆ?ã?®å?˜èªžã?Œä¸€èˆ¬çš„ã?«SELECTã?ªã?®ã?§ã€?ã?“ã?®å??å‰?ã?Œä¸Žã?ˆã‚‰ã‚Œã?¦ã?„ã?¾ã?™ã€‚(å•?å?ˆã?›ã?¯é?¸æŠžå¼?以外ã?«ã‚‚ã€?VALUESå¼?ã€?UNIONã€?INTERSECTã€?EXCEPTå¼?ã?§ã?‚ã‚‹å ´å?ˆã?Œã?‚りã?¾ã?™ã€‚)
ORDER BY 節ã?«ã‚ˆã‚Šã€?ResultSetã?®ä¸¦ã?³é †ã?Œæ˜Žç¤ºã?•れã?¾ã?™ã€‚FOR UPDATE 節ã?«ã‚ˆã‚Šã€?çµ?æžœã?®ã‚«ãƒ¼ã‚½ãƒ«ã‚’æ›´æ–°å?¯èƒ½ã?«ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚SELECTæ–‡ã?«ã?¯FOR EACH ONLY 節を置ã??ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚FOR EACH ONLY 節ã?¨FOR READ ONLY節ã?¯å?Œã?˜ã‚‚ã?®ã?§ã?™ã€‚
SELECTæ–‡ã?«ã?¦WITH {RR|RS|CS|UR}ã?¨ã?„ã?†æ›¸ã??æ–¹ã?§åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã‚’指定ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚
-- SAL+BONUS+COMMã?¨å??å‰?を並ã?¹ã?¦ã€?TOTAL_PAYã?¨ã?„ã?†å??å‰?ã‚’ã?¤ã?‘ã€? -- ã??ã?®å??å‰?ã?§ä¸¦ã?³æ›¿ã?ˆã‚‹ã€‚ SELECT FIRSTNME, SALARY+BONUS+COMM AS TOTAL_PAY FROM EMPLOYEE ORDER BY TOTAL_PAY -- FOR UPDATE節を指定ã?™ã‚‹ã?“ã?¨ã?§ã€? -- PROJECTã?¨ã?„ã?†è¡¨ã?«ã?‚ã‚‹ã€?開始日時(PRSTDATE)ã€?終了日時(PRENDATE)ã?¨ã?„ã?†åˆ—ã‚’æ›´æ–°ã?™ã‚‹ã€? -- æ›´æ–°å?¯èƒ½ã?ªã‚«ãƒ¼ã‚½ãƒ«ã‚’作æˆ?ã?™ã‚‹ SELECT PROJNO, PRSTDATE, PRENDATE FROM PROJECT FOR UPDATE OF PRSTDATE, PRENDATE -- ã?“ã?®æ–‡ã?«é™?り分離レベルをRRã?«ã?™ã‚‹ã€‚ SELECT * FROM Flights WHERE flight_id BETWEEN 'AA1111' AND 'AA1112' WITH RR
SQL言語ã?§ã?¯ã‚«ãƒ¼ã‚½ãƒ«ã?«å??å‰?を与ã?ˆã‚‹äº‹ã?Œã?§ã??ã?¾ã?›ã‚“。ã??ã?®ã?‹ã‚?りã?«JDBC APIã?«ã‚ˆã‚Šã‚«ãƒ¼ã‚½ãƒ«ã?«å??å‰?を与ã?ˆã?Ÿã‚Šã€?システムã?Œã‚«ãƒ¼ã‚½ãƒ«ã?«ä¸Žã?ˆã?Ÿå??å‰?ã‚’å?–å¾—ã?™ã‚‹ã?“ã?¨ã?Œã?§ã??ã?¾ã?™ã€‚詳細ã?«ã?¤ã?„ã?¦ã?¯Derby ディベãƒãƒƒãƒ‘ーズ ガイドã?®ã‚«ãƒ¼ã‚½ãƒ«ã?¸ã?®å‘½å??ã?Šã‚ˆã?³å??å‰?ã?®åˆ©ç”¨ã‚’å?‚ç…§ã?—ã?¦ä¸‹ã?•ã?„。
SELECTã?¯ã€?å•?å?ˆã?›ã?®è¡¨ã‚„ビューã€?ã??れらã?®è¡¨ã?¸ã?®ã‚¢ã‚¯ã‚»ã‚¹ãƒ‘スã?«ã?¦é?¸æŠžã?•れã?Ÿã‚³ãƒ³ã‚°ãƒãƒžãƒªãƒƒãƒˆ(ヒープやインデックスã?ªã?©ã?®è¨˜æ†¶ã?®å?˜ä½?ã?§ã?™ã€‚)ã?«ä¾?å˜ã?—ã?¾ã?™ã€‚ CREATE INDEXã?§ã?¯æº–å‚™ã?•れã?ŸSELECTæ–‡ã?Œç„¡åйã?«ã?ªã‚‹ã?“ã?¨ã?¯ã?‚りã?¾ã?›ã‚“。 DROP INDEXæ–‡ã?§ã?¯ã‚‚ã?—ç ´æ£„ã?•れる索引ã?Œæ–‡ã?«ã?¦ã‚¢ã‚¯ã‚»ã‚¹ãƒ‘スã?ªã‚‰ã€?準備ã?•れã?ŸSELECTæ–‡ã?¯ç ´æ£„ã?•れã?¾ã?™ã€‚ ã‚‚ã?—SELECTã?«ãƒ“ューã?Œå?«ã?¾ã‚Œã?¦ã?„れã?°ã€?ビューã?Œä¾?å˜ã?™ã‚‹ãƒ‡ã‚£ã‚¯ã‚·ãƒ§ãƒŠãƒªã?®æƒ…å ±ã?«ã‚‚ä¾?å˜ã?—ã?¾ã?™ã€‚(CREATE VIEW 文をå?‚ç…§ã?—ã?¦ã??ã? ã?•ã?„。)
SELECTã?®ã‚«ãƒ¼ã‚½ãƒ«ã?«å¯¾ã?—ã?¦ã€?準備ã?•れã?ŸUPDATE WHERE CURRENTã?‚ã‚‹ã?„ã?¯DELETE WHERE CURRENTæ–‡ã?¯SELECTã?«ä¾?å˜ã?—ã?¾ã?™ã€‚java.sql.Statement.close ã?«ã‚ˆã‚ŠSELECTã‚’å?–り除ã??ã?¨ã€?UPDATE WHERE CURRENT ã?Šã‚ˆã?³ DELETE WHERE CURRENTã?¯ç„¡åйã?¨ã?ªã‚Šã?¾ã?™ã€‚
SELECTã?¯å•?å?ˆã?›ã?«ã?‚ã‚‹ã?‚らゆる別å??ã?«ä¾?å˜ã?—ã?¾ã?™ã€‚別å??ã‚’ç ´æ£„ã?™ã‚‹ã?“ã?¨ã?«ã‚ˆã‚Šã€?ã‚‚ã?—準備ã?•れã?ŸSELECTæ–‡ã?«ã?¦åˆ¥å??ã?Œä½¿ã‚?れã?¦ã?„ã‚‹ã?ªã‚‰ã€?ã??ã?®æ–‡ã?¯ç„¡åйã?«ã?ªã‚Šã?¾ã?™ã€‚