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

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À´¿´¿


Ïà¹ØÎÊ´ð£º

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......

sql ÎÊÌâ - MS-SQL Server / »ù´¡Àà

ÐèÇóÈçÏ£º
ѧԺ 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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ