SQLÓï¾äÓÅ»¯ÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ
ÔÚÕû¸öϵͳµÄѹÁ¦²âÊÔÏ£¬ÏÂÃæÕâ¾äSQlÓï¾äÕ¼ÓÃ×ÊÔ´±È½Ï´ó£¬ÒѾ½«trtp,ctof,trdt,idno¼ÓÁËË÷Òý£¬ µ«Ð§ÂÊ»¹ÊÇÉϲ»È¥£¬ÇëÎÊÔõôÑùÄÜÓÅ»¯Ò»Ï£¬Ê¹Ð§ÂÊÌá¸ßÄØ£¿ select sum(slam) as slam from trd_tranlist_" + ptid + " where trtp='1' " + "and ctof ='0' and trdt = ? and idno=?
create index xxx on t_xx(idno, trdt, ctof, trtp, slam); ½¨Õâ¸öË÷Òý Õâ¸öË÷Òý×ֶεÄ˳Ðò»áÓ°ÏìЧÂʲ»£¿Ó¦¸ÃÔõôÅжÏ˳ÐòÄØ£¿ Ò»°ãÀ´½²£¬°Ñ¿ÉÑ¡ÔñÐԸߵÄ×ֶΣ¨Ò²¾ÍÊÇ×Ö¶ÎÓкܶ಻ֵͬµÄÄÇÖÖ×ֶΣ©·ÅÔÚÇ°ÃæÒýÓà Õâ¸öË÷Òý×ֶεÄ˳Ðò»áÓ°ÏìЧÂʲ»£¿Ó¦¸ÃÔõôÅжÏ˳ÐòÄØ£¿ ×ֶεÄ˳ÐòÊÇ£¬¹ýÂËÊý¾ÝÁ¿×î¶àµÄ×ֶηÅÔÚwhereÌõ¼þ×îºóÃæ¡£ ÕâÑù¿ÉÒÔÌá¸ßЧÂÊÒýÓà Õâ¸öË÷Òý×ֶεÄ˳Ðò»áÓ°ÏìЧÂʲ»£¿Ó¦¸ÃÔõôÅжÏ˳ÐòÄØ£¿ Äã¿ÉÒÔ´ò¿ªoracleµÄÖ´Ðмƻ®£¬²é¿´Ò»ÏÂÄãÿ´ÎÐÞ¸Äsql²éѯÓï¾äºóµÄÖ´Ðмƻ®£¬ÕâÑù¾Í¿ÉÒÔÕÒµ½×îÓŵÄsqlÓï¾ä¡£ 4 Â¥£º Äã˵µÄÊÇRBOµÄ¶«Î÷£¬CBOÒѾûÓÐÕâÑùµÄ˵·¨ÁË ¿´¿´²»Í¬Çé¿öϵÄÖ´Ðмƻ®ÒýÓà 4 Â¥£º Äã˵µÄÊÇRBOµÄ¶«Î÷£¬CBOÒѾûÓÐÕâÑùµÄ˵·¨ÁË ¹þ¹þ£¬»°ËµÇ°¶Îʱ¼äÎÒÃæÊÔµÄʱºò¾Í±»ÎʹýÕâ¸öÎÊÌ⣬Çý¶¯±íºÍwhereÌõ¼þ˳ÐòÔÚCBOÖÐÓÐûÓÐ×÷Óᣠ°ÑÑ¡ÔñÂÊ×î¸ßµÄ¼¸¸ö½¨Á¢Ë÷Òý¾Í¿ÉÒÔÁË£¬Ë÷Òý˳ÐòÎÞËùνµÄ£¬ÏÖÔÚ¶¼ÊÇCBOʱ´úÁË£¬ÁíÍâtrtpºÍctofΪʲôûÓÐʹÓð󶨱äÁ¿ÄØ£¿£¿ Ë÷Òý˳ÐòÊÇ·ñÕýÈ·£¡£¿ ×öÒ»¸ösql_traceÀ´¿´¿
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê create or replace package PK_test as type cur_test is ref cursor; end PK_test; --½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩! create or replace ......
ÐèÇóÈçÏ£º ѧԺ academy£¨aid,aname£© °à¼¶ class£¨cid,cname,aid£© ѧÉú stu(sid,sname,aid,cid) סËÞÇø region(rid,rname) ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯ ËÞÉá dorm(did,rid,bid£¬bedn ......