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

ÕâÑùµÄsql£¬ÎÒÈ´×öµ½ÁË¡£

 ÕâÊÇÒ»¸öCSDN Oracle¿ª·¢°æ¿éÀï£¬ÍøÓÑÎʹýµÄÒ»µÀÌâ
ÌâÈçÏÂ
create table A_TEST
(
PAYOUT_ITEM_CODE VARCHAR2(30) not
null,
FORMULA_DET VARCHAR2(1000)
)
create table B_TEST
(
ELEMENT_ID VARCHAR2(5) not null,
NAME VARCHAR2(41)
)  
Çóдoracle¶à¸ö×Ö·ûÌæ»»£¨ÓвâÊÔÊý¾Ý£©
insert into a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values
('30228', '({30015}+{30016})*450');
insert into a_test
(PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30102', '({30015}+{30016})*1500');
insert into a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30102',
'({30015}+{30016})*5000');
insert into a_test (PAYOUT_ITEM_CODE,
FORMULA_DET)
values ('30102', '({30015}+{30016})*2500');
insert into
a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30102',
'({30015}+{30016})*2300');
insert into a_test (PAYOUT_ITEM_CODE,
FORMULA_DET)
values ('30102', '({30015}+{30016})*1150');
insert into
a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30104',
'({30015}+{30016})*300*12');
insert into a_test (PAYOUT_ITEM_CODE,
FORMULA_DET)
values ('30226', '{30057}*2300');
insert into a_test
(PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30102', '({30015}+{30016})*5000');
insert into a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30102',
'({30015}+{30016})*3000');
insert into a_test (PAYOUT_ITEM_CODE,
FORMULA_DET)
values ('30102', '({30015}+{30016})*1500');
insert into
a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30226',
'{30006}+{30061}+{30008}');
insert into a_test (PAYOUT_ITEM_CODE,
FORMULA_DET)
values ('30226', '{30057}*3800*12');
insert into a_test
(PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30210',
'({30030}+{30031}+{30032})*38000+{30033}*23000');
insert into a_test
(PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30210',
'({30030}+{30031}+{30032}+{30033})*38000+{30036}*10000');
insert into
a_test (PAYOUT_ITEM_CODE, FORMULA_DET)
values ('30229',
'({30015}+{30016})*1400');
insert into a_test (PAYOUT_ITEM_CODE,


Ïà¹ØÎĵµ£º

Oracle PL/SQLÈëÃÅÖ®¿®Êö

 Ò»¡¢PL/SQL³öÏÖµÄÄ¿µÄ
¡¡¡¡½á¹¹»¯²éѯÓïÑÔ(Structured Query
Language£¬¼ò³ÆSQL)ÊÇÓÃÀ´·ÃÎʹØÏµÐÍÊý¾Ý¿âÒ»ÖÖͨÓÃÓïÑÔ£¬ËüÊôÓÚµÚËÄ´úÓïÑÔ£¨4GL£©£¬ÆäÖ´ÐÐÌØµãÊǷǹý³Ì»¯£¬¼´²»ÓÃÖ¸Ã÷Ö´ÐеľßÌå·½·¨ºÍ;
¾¶£¬¶øÊǼòµ¥µÄµ÷ÓÃÏàÓ¦Óï¾äÀ´Ö±½ÓÈ¡µÃ½á¹û¼´¿É¡£ÏÔÈ»£¬ÕâÖÖ²»¹Ø×¢ÈκÎʵÏÖϸ½ÚµÄÓïÑÔ¶ÔÓÚ¿ª·¢ÕßÀ´ËµÓÐ׿«´óµÄ ......

ÔÚ×öSQL¹ÊÕÏ×ªÒÆÈº¼¯µÄʱºòÓ¦¸ÃÑ¡ÔñÄÄÖÖģʽ£¿

Èç¹ûÎÒÃǵÄSQL ServerÒª±£Ö¤¸ß¿ÉÓÃÐÔ£¬ÄÇô¿ÉÒÔ²ÉÓùÊÕÏ×ªÒÆÈº¼¯¡£×î¼òµ¥µÄ¹ÊÕÏ×ªÒÆÈº¼¯ÊÇÁ½Ì¨·þÎñÆ÷£¬Ò»Ì¨×ö»î¶¯µÄ·þÎñÆ÷£¬Áíһ̨×ö±¸Ó÷þÎñÆ÷£¬Õâ¾ÍÊÇAPģʽµÄCluster¡£ÁíÍâÒ»¸öģʽ¾ÍÊÇAAģʽ£¬Ò²¾ÍÊÇÁ½Ì¨·þÎñÆ÷¶¼ÊÇÔËÐÐSQL ServerʵÀý¡£
SQL Server²»ÏñOracleÒ»ÑùÓÐRAC£¬ËùÒÔ²»¿ÉÄÜ˵Á½Ì¨·þÎñÆ÷ͬʱÔËÐÐͬһ¸öʵÀý£¬Ïë ......

hibernateɾ³ý²Ù×÷µÄsqlÓï¾äд·¨

 
µÚÒ»ÖÖ£º
public void deleteUser(String byemail) {
  Session session = getSession();
  Transaction transaction = null;
  String hql = "delete from Register where email=?
";
  try {
   transaction = session.beginTransactio ......

·ÀÖ¹SQL×¢Èë

Ò»¡¢Ê¹ÓòÎÊý»¯ÊäÈë¡£´æ´¢¹ý³ÌÀᄀÁ¿±ÜÃâÓï¾äÆ´½Ó¡£
¶þ¡¢¶ÔÓÚһЩÊý¾Ý¿â£¬±ØÐëÉèÖÃȨÏÞ£¬ÉõÖÁÉèÖõ½×ֶΡ£
Èý¡¢Ê¼ÖÕͨ¹ý²âÊÔÀàÐÍ¡¢³¤¶È¡¢¸ñʽºÍ·¶Î§À´ÑéÖ¤Óû§ÊäÈë¡£
ËÄ¡¢¹ýÂËÃô¸Ð×Ö·û¡£
Function ReplaceStr(Str)
Str=Trim(Str)
Str=Replace(Str,"'","'")
Str=Replace(Str,";",";")
Str=Rep ......

SQL ServerÖлã×ܹ¦ÄܵÄʹÓÃGROUPING,ROLLUPºÍCUBE

1.Óà CUBE »ã×ÜÊý¾Ý
 CUBE ÔËËã·ûÉú³ÉµÄ½á¹û¼¯ÊǶàάÊý¾Ý¼¯¡£¶àάÊý¾Ý¼¯ÊÇÊÂʵÊý¾ÝµÄÀ©Õ¹£¬ÊÂʵÊý¾Ý¼´¼Ç¼¸ö±ðʼþµÄÊý¾Ý¡£À©Õ¹½¨Á¢ÔÚÓû§´òËã·ÖÎöµÄÁÐÉÏ¡£ÕâЩÁб»³ÆÎªÎ¬¡£¶àάÊý¾Ý¼¯ÊÇÒ»¸ö½á¹û¼¯£¬ÆäÖаüº¬Á˸÷ά¶ÈµÄËùÓпÉÄÜ×éºÏµÄ½»²æ±í¸ñ¡£ CUBE ÔËËã·ûÔÚ SELECT Óï¾äµÄ GROUP BY ×Ó¾äÖÐÖ¸¶¨¡£¸ÃÓï¾äµÄÑ¡ÔñÁбíÓ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ