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

Çóoracle¿âÀïµÄ±í½á¹¹µ¼µ½PDÈí¼þÖеķ½·¨£¿£¿£¿£¿

СµÜ×î½üÔÚʹÓÃPD,ÎÒÏÖÔÚÓõÄÊÇoracleÊý¾Ý¿â£¬¿âÀïµÄ±íÔç¾ÍÒѾ­½¨ºÃÁË£¬
ÎÒÏÖÔÚÊÇÏëÓÐûÓÐʲô·½·¨£¬°Ñoracle¿âÀïµÄ±í½á¹¹µ¼µ½PDÈí¼þÖС£
ÓÃPDÁ¬½ÓÄ¿±êÊý¾Ý¿â£¬È»ºó¶ÔÊý¾Ý¿â½øÐÐÄæ¹¤³Ì¡£

лл¥ÉϵÄÐֵܣ¬ÎÒÈ¥ÊÔÊÔ£¡

PDÒѾ­Á¬½ÓÉÏÁËÄ¿±êÊý¾Ý¿â£¬½ÓÏÂÀ´ÐèÒªÔõôÑù×ö²ÅÄܵ¼Èë±í½á¹¹£¡




ÖÕÓÚÕÒµ½ÁË£¬Ð»Ð»Â¥ÉϵÄÐֵܣ¡


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ