œ Jun 28, 2001 (Thu) 20:31 - ‚¨‚ç #~~~~ # ‚»‚µ‚ÄOracle‚ª # select rec_a, rec_b, rec_c from tbl_a where rec_c=1 # ‚Æ # select rec_b, rec_a, rec_c from tbl_a where rec_c=1 # ‚𓙉¿‚É•]‰¿‚µ‚È‚¢i•Ô‚Á‚Ä‚‚éƒf[ƒ^‚ª‘S‘Rˆá‚¤j‚Æ‚©Œ¾‚¤ # •…‚Á‚½–â‘è‚Ƀnƒ}‚èAŽ–‘Ô‚Í‹}‘¬‚É“DÀ‰»B ‚©‚¦‚Á‚Ä‚‚éƒf[ƒ^‚ª‘S‘Rˆá‚¤‚Á‚Ä‚Ç‚¤‚¢‚¤‚±‚Æ‚¾‚낤D 1—ñ–Ú‚Æ2—ñ–Ú‚ª“ü‚ê‘Ö‚í‚é‚Ì‚Í“–‘R‚̂悤‚Èddd 19:34:14 SQL> select * from test1; A B C ---------- ---------- ---------- 1 2 3 4 5 6 19:34:18 SQL> select a,b,c from test1 where c = 3; A B C ---------- ---------- ---------- 1 2 3 19:34:28 SQL> select b,a,c from test1 where c = 3; B A C ---------- ---------- ---------- 2 1 3 ‚¾‚µDDD ‚»‚ê‚Æ‚àC‚à‚Á‚Æ‚â‚΂¢‚΂®‚ªHiOOG |
|