Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

JavaScriptÔõÑùÐ´ÍøÒ³ÉϵÄÑéÖ¤Âë´úÂ룿

ÓÃJavaScriptÈçºÎдÔÚä¯ÀÀÍøÒµÊ±ÒªÊäÈëÑéÖ¤ÂëµÄ´úÂ룿ÈçµÇ½Óû§Ê±ÒªÊäÈëÑéÖ¤Âë.......  Çë¸ßÊִͽ̣¡
Õâ¸öºÍJSû¹ØÏµ
»Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡

ÑéÖ¤´úÂëÒ»°ãÓÃjavaµÄapplet»òflash×ö£¬ÕæÃ»¼ûµ½ÓÃjavaScript×öµÄ¡£

¶÷~ ¼´Ê¹ÄÜ×ö³öÀ´Ò²Ê§È¥ÁËÑéÖ¤ÂëµÄ×÷ÓÃÁË

HTML code:
<!DOCTYPE html PUBLIC "-//W3C/ ......

oracle ²éѯÓï¾ä

select (distinct no),flag from tbl group by no,flag
µÃµ½ÈçϽá¹û
no  flag

01    1

01    0

02    0

ÏëºÏ²¢no=01µÄÁ½ÌõΪһÌõ
no  flag

01    1

02    0
Ôõô¼ÓÌõ¼þµÃµ½ÒÔÉϽá¹ûÄØ£¿ »¹ÊÇÎÒµÄÓ ......

oracleÓÅ»¯ÎÊÌâ

ÎÒдÁËÒ»¸ö´æ´¢¹ý³Ì£¬Ê¹ÓÃÓαê¶ÔÊý¾Ý½øÐвåÈë²Ù×÷£¬Éæ¼°µ½ºÜ¶à±í£¬ÆäÖÐһЩÊÇÖ÷´Ó±í¹ØÏµ£¬°´Ë³ÐòÏÂÀ´£¬Ö÷±íÉú³ÉÊý¾Ý£¬ÔÙÉú³É×Ó±íµÄ¡£
  ×î½üÅöµ½Ò»¸öÎÊÌ⣬ÓÉÓÚÓеÄÊý¾ÝÁ¿¹ý´ó£¬Ôì³ÉËٶȺÜÂý£¬ÔÚ10¼¸ÍòÌõÒÔÉÏ¡£ÏëÇë½ÌϸßÊÖ£¬ÓÐûÓкõķ½·¨½øÐÐÓÅ»¯£¬Ìá¸ßÏÂËÙ¶È£¡
ֻҪûÓÐÌ«¶à´ó¿éÍ·´ó¶ÔÏó£¬10¼¸Íò¶ÔORACLEÀ´ ......

oracle ²éÑ¯Ìæ»»ÎÊÌâ

±íAÊý¾ÝÈçÏÂ
id        name

1 µ¥ÒøÇÙ
2 Àî¹úÕý
3 ÓȾê
4 ÖìÍõÓ¢
5 ÀîÎÄ
6 ÐÜÓ³ºì
7 ÍõÁáÁá
8 ÕÔ±ò
9 Ðì˳Ñà
10 ÖÜÓ¢
11 ÍõÑÞΰ

ÎÒÒª²éѯ³öÕâÑùµÄ½á¹û

id        name

1 µ¥ÒøÇÙ
2 Àî¹úÕý
3 ÓȾê
4 ÖìÀîÓ ......

oracle ÐòÁÐÎÊÌâ

ÎÒ½¨Á¢Á½¸ö±í£¬½¨Á˲»Í¬µÄÐòÁС£ÎªÊ²Ã´Á½Õűíͬʱ×Ô¶¯Ôö³¤¡£
±ÈÈç¿ÆÄ¿±íÔö³¤µ½34£¬35
    ÔÙ²åÈëѧÉúÐÅÏ¢¾ÍΪ£º36£¬37
    ¼ÌÐø²åÈë¿ÆÄ¿£º38£¬39

create table subject
(
      sub_id number not null primary key,
      sub_name varchar ......

oracle ¼àÌý¹ÒËÀ£¬ÄÚ´æÎÞ·¨·ÖÅä

ʹÓÃplsqlÁ¬½Ó·þÎñÆ÷µÄÊý¾Ý¿âʱ·¢ÏÖoracle²»ÄÜ·¢ÎÊÁË£¬ÌáʾʲôÎÒÒ²¼Ç²»µÃÁË¡£
Ô¶³Ì¹Û²ìoracleµÄ¼àÌý½ø³Ì·¢ÏÖ¼àÌý½ø³Ì¾ÓÈ»´ïµ½2G×óÓÒ¡£ÖØÆô¼àÌý»òÖØÆô·þÎñÆ÷ºó£¬¼àÌýÄÚ´æÓɸտªÊ¼µÄ6M×óÓÒ£¬°ë¸öСʱ×óÓÒÖð½¥Ôö¼Óµ½2G×óÓÒ£¬ÄÄλ´ó¸çÄܰïСµÜ·ÖÎöһϣ¡
¿´¿´¼àÌý³ÌÐòÈÕÖ¾Àï¶¼½²Ð©Ê²Ã´¡£

ÒýÓÃ
ʹÓÃplsqlÁ¬½Ó·þÎñÆ÷µÄÊý ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [1146] [1147] [1148] [1149] 1150 [1151] [1152] [1153] [1154] [1155]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ