Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

[ÐÂÊÖ]oracle´æ´¢¹ý³Ì²åÈëÊý¾ÝÎÊÌâ

ÓÐ2¸ö±í
studentѧÉú±í
----------------------------------------------------------------------------
sno sname sage ssex sxiexing sclass sjiguan shjxz szcode stel
ѧºÅ                          °à¼¶

score
--------------------------------------------------------------------------------------
ssno  course1 course2 course3 course4 course5 course6 course7 course8 course9 course10
ѧºÅ

course1-course10·Ö±í´ú±íÊ®Ãſγ̣¬¿Î³ÌÊǷְ༶µÄ£¬ÕâÀï·ÖÁ½¸ö°à¼¶£¨11°à£¬22°à£©£¬21°àµÄ¿Î³ÌÊÇ
(course1,course2,course3,course7,course9)ʣϵÄÊÇ11°àµÄ¿Î³Ì¡£

Ä¿µÄÊÇҪͨ¹ý´æ´¢¹ý³ÌÔÚscore±íÖвåÈë³É¼¨£¬ÓÉÓÚÁ½¸ö°àµÄ¿Î³Ì²»Ò»Ñù£¬¹Ê²åÈë³É¼¨µÄʱºòÒª¿¼ÂÇÍùÄĸö¿Î³Ì²åÈëµÄÎÊÌâ¡£

ÎÒÊÇÏëͨ¹ýIFÓï¾äÅжϳöÊÇÄĸö°àµÄ £¬ÔÙͨ¹ýinsert into score(course1,course2,course3,course7,course9)
values(&course1,&course2,&course3,&course7,&course9)
else
insert into score(course4,course5,course6,cours8,course10)
values(&course4,&course5,&course6,&cours8,&course10)
²åÈë³É¼¨£¬ÀÏÊÇÌáʾ¹ý³ÌÓбàÒë´íÎó£¬Âé·³¸÷λ°ïæָµãϰ¡¡«¡«
ÎÊÌâÃèÊö²»Çå³þÚÀ

ÊäÈë²ÎÊýÊÇÄÄÐ©ÄØ£¿

ÊäÈë¡­¡­ÎÒÒ²²»Çå³þ

¸Ð¾õÊäÈëʲô¶¼²»ºÃÅжÏÄǸö¡«¡«

ÄÇÕâÑù´æ´¢¹ý³Ì²»ºÃдÁËÄØ

¿Ï¶¨ÓÐÒ»¸ö×Ö¶ÎÊÇsnoѧºÅ°É£¬ÆäËû¾ÍÊÇ5¸ö»òÕß10¸ö·ÖÊýÁË

ÊÇѽ  ÊÇÒªµ


Ïà¹ØÎÊ´ð£º

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

oracle ·¢Óʼþ´íÎó

ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
                            mes_co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ