教员检查学员作业.PDFVIP

ׂѿ䛑ⱏᄫᬷ㛑䆱Ўᖙ ㄝ䰙↣ક㹿ߦऴ ݀೼ׂᚙᡸᴎҔᠧ䆄໘ഔ ᬷ਼ὐᷛᅗ਼Փ Ⳍ᷽ ² 㞾䅵ᅲⳂ῵ᗱ ² 㞾⍜䆱㸼㒗 ² 㞾⍜䆱݇Ҏક㸼݇Ҏ ² 㞾߻ᓔ㹿ߦऴ ᬷ਼䆌䅵䰙↣Ⳍ᷽ ㄝ䛑ߦ ᣹ᇚ70 ߦ䫔 ᴃ䰙↣䞣✊Ң㒣ᄤ԰⍜䆱㸼㒗݇Ҏક㸼݇ҎӀড߻ᓔ৤⾥㋏෍ߦऴ㹿Ⳃ᮴⌟ 㒡њ1Ⳃ῵ᗱ 䯈乱 ᬷ਼䆌䅵䯈乱䇋᯺ GITM ݄৘Ⳃ䳔਼㉏㐕㓪㾷䛑䯂Ⳃ᠔㒧ᑈ䗄㸼᳔ᮍᔩ᳔ᮍᬍՓ∈䕥乬㑻 䛑䯂৬ᯢ᳔ᮍ䳔਼㹿ᯢ᠔ԋࠊ㐕㓪থᑺহ៤㟐ߚ⧚ㅵᕫߎ⿟৮ᠧ㞾ᅮؐᬒⳂᛳ ޴᠔ৱᡸᴎҔ਼থᑺ䖯ᛳ޴ᑧᏱ᳻ᖗࠊ২Ⳃ䅵䞠ક䅵މ᮴Ẕ ߦᵰ 䗖ᛳ޴ো㞾᳈ᭈᥜᒄⳂᅲᴗࠡᓯ䏃Ⳃ᳈⾥ᴗࠡѦ䰊৬ᯢ䆕䯈ⳟ৬䍋⒮Ⳃ ᠔д䰆ߚ⧚⼎ൟⳂѻѯᬍՓ䍋⒮োӀ᳈ᮄ㹿㹿ЎⳂ⣀ᅲ㸼ᔩ᠔৬ᯢ᳔ᮍⳟ ৬Ⳃᭈᥜᯢᭈᥜᒄᦦֱᅲᴗֵࠡ䆩৬ᭈᥜധ৬ᯢ䰆ৃ㞾ᳩ᠔ധ᳔ᮍݡҷ ᠔ᖭ乥ㅵᕫ࡯乏Ⳃ᳔ᮍᅮҪֵ䆩ᭈᥜⳂ㣗ೈᦦֱќᓎⳂᭈᥜᑧপ োӀ㸠ব⾥৬㒗Ⳃ㸼㒗Ѧ⣀ᅲⳂ㸼ક㹿㒗Ѧᮄ㹿 1 ݈Ꮉ᮴⾩ᡸ䆄ᅗ IBM 䕗ӑᏆᏭᬷ㛑Ўᖙ Ўᖙഔണ݈Ꮉ∖Ў䑿8 ৓Ў⾩䰸䍋⒮ׂᚙЎᖙ2 ৓ὖ709 ᇍ 㚆㐕ⱏ䆶0931-8268960 0931-8268961 ׂѿ䛑ⱏᄫᬷ㛑䆱Ўᖙ ㄝ䰙↣ક㹿ߦऴ ݀೼ׂᚙᡸᴎҔᠧ䆄໘ഔ 䅵މ᮴Ẕ 䘀䖨⍜䆱કߦᵰᅲⳂᴗࠡḜᥜᅸ䰤ᑺⳂᛳ޴ᇑᡔ২䗨Ⳃ䅵މ᮴Ẕ 㒡њ2㸼㒗 䯈乱 ധҙПᛳ޴ԋߚ⧚㸼㒗 ߦᵰ ധ՟INSERTUPDATE DELETE કSELECT…FOR UPDATE ㅵ䇃৆ᯢOracle ԋ㟇ࣙ ᑺ㸼㒗ᅲSELECT…FOR UPDATE 䇃৆ܜ䆓᠔↨䗯ᣛ㸼䆆ᔶӀ䗄㸼᳔ᮍ䖯Ѹ 䆆ᔶԋ㽕ᅲৃ㞾⬉প䏃ᷛ䆹Ⳃ᠔䗄㸼䕧ৃᳩധ಴⚍ᦦѻ䇁Ѣࡼ৮ᅲᠧԋ 䞠ᬜݡҷ᠔ᠧোӀ䕧䖯Ѹ䆆ᔶ 䅵މ᮴Ẕ ᬷ਼䆌䅵݊䭓↉催 䘀䖨ᢽ᠔৬ᯢ᳔ᮍ㹿Ⳃⳟ৬㸼ᵤ⍜䆱SELECT…FOR UPDATE ㅵ䇃৆ᓯ䏃Ⳃ㸼㒗 ᴃկ՟ACCP ᠔કSCOTT ᠔ⱘᔶᭈᥜᒄ䗄㸼⍜䆱 1ӀACCP ᠔䕃ӮⱘᔶSQL*Plusᦤџ᠔SCOTT ᳔ᮍemployee 㹿Ⳃᴹ䰶 SQLGRANT ALL ON employee TO SCOTT; 2 ACCP ᠔ᡒ㸼߷੠Ӆ SQLSELECT * FROM employee WHERE empno=’E006’ FOR UPDATE; ᯢemployee 㹿Ⳃ “E006 㸼ԋ㽕ᅲACCP ᠔ሖোӀ᳔ᮍ䇁㹿 SQLUPDATE employee SET designation=’Accountant’ WHERE empno=’E006’; “E006 㸼᳔ᮍࡶ 3 ᠻᓚSQL*Plus ⳂাᅸկӀSCOTT ᠔䕃Ӯⱘᔶᑧ᳔ᮍemployee 㹿ⳂE006 㸼 SQLUPDATE employee SET designation=’Accountant’ WHERE empno=’E006’; ੠Ӆ᮹⌟㄀ঞᡒ㸼SQL*Plus ټଂᑺㅵᕫACCP ᠔ᦦѻѢࡼ 4 ߧ᥂ࠊㄝSQL*PlusACCP ᠔ᡒ㸼Ӏ੠ӅᦦѻѢࡼ SQLCOMMIT ᯢ㽕䞠ᬜ⡍৮᠔SCOOT Ⳃ᳔ᮍ੠Ӆᠧԋࡶᡒ㸼ᄤᶹ᠔SCOOT ധ↉催3 ᡒ㸼Ⳃ᳈᳔ᮍ “E002 㸼Ⳃ੠Ӆ䚼ПᬍՓᇤࡶᡒ㸼ೈМ“E002 㸼㽕ᅲ 2 ݈Ꮉ᮴⾩ᡸ䆄ᅗ IBM 䕗ӑᏆᏭᬷ㛑Ўᖙ Ўᖙഔണ݈Ꮉ∖Ў䑿8 ৓Ў⾩䰸䍋⒮ׂᚙЎᖙ2 ৓ὖ709 ᇍ 㚆㐕ⱏ䆶0931-8268960 0931-8268961