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

ORACLE³£ÓÃSQLÓÅ»¯hintÓï¾ä

PowerBuilderÈ¡µÃ¾Þ´ó³É¾ÍµÄÔ­Òò¾ÍÊÇÓй¦ÄÜÇ¿´óºÍÁé»î¶à±äµÄDatawindow¶ÔÏ󣬱¾ÈËÓÃPowerBuilder¿ª·¢¹ýÒ»¶Îʱ¼äºó£¬×ܽá³öһЩ¼¼ÇÉ£¬ÒÔ¹©¹ã´óµÄPB¿ª·¢Õß½è¼øʹÓá£
1¡¢ ÈçºÎ´´½¨Ò»¸ö¾ßÓÐÖð½¥µÝÔöÇóºÍ¹¦Äܵı¨±í£¬ÈçÏÂÐÎʽ£º Running TotalÁУ¬ÎÒÃÇ¿ÉʹÓüÆËãÁУºCumulativeSum£¨Quantity for all£©£¬¼´¿É´ïµ½Öð½¥µÝÔöÇóºÍµÄ¹¦ÄÜ¡£
2¡¢ Êý¾Ý´°¿ÚµÄÊý¾ÝËÍ»º³åÇø֮ǰȷÈϵÄËĸö²½Öè Ê×ÏÈÅжÏÊý¾ÝÀàÐÍÊÇ·ñÕýÈ·¡£Èç²»ÕýÈ·Ôò´¥·¢ItemErrorʼþ¡£ ItemErrorʼþ¡£ ItemChangedʼþ£¬Èç¹ûÊý¾ÝºÍItemChangedÏà³â£¬½«´¥·¢ItemErrorʼþ¡£
3¡¢ÈçºÎÔÚDataWindowÖÐÓÃÊý¾ÝÀàÐÍΪDatetimeµÄÁÐΪÌõ¼þ½øÐвéÑ°
  £¨1£© µ±Òª²éÕÒµÄÈÕÆÚÌõ¼þÊÇÒ»³£ÊýʱʹÓÃÈçϱí´ïʽ£º
  £¨2£©µ±Òª²éÕÒµÄÈÕÆÚÌõ¼þÊÇÒ»¸ö±äÁ¿Ê±Ê¹ÓÃÈçϵıí´ïʽ£º
  £¨3£©Òª²éÕÒµÄÈÕÆÚÌõ¼þÊÇÒ»¸öDateTimeÊý¾ÝÀàÐÍʱʹÓÃÈçϱí´ïʽ£º
       a¡¢ÉèÖÃÊý¾Ý´°¿ÚBooleanÐÍÊôÐÔµÄÈýÖÖ·½·¨ ÌṩÁËÈýÖÖ·½·¨ÉèÖÃÊý¾Ý´°¿ÚµÄ²¼¶ûÐÍÊôÐÔ£¬·Ö±ðÊÇTrue/False, 1/0, 'Yes'/'No'¡£ÀýÈç: ÔÚ´¦ÀíʱÒÔ×Ö·û´®µÄÐÎʽ±£´æÊôÐÔ£¬¶ø²»¿¼ÂÇÊôÐÔÖµÊDz¼¶ûÐÍ¡¢³¤ÕûÐÍ»òÊÇ×Ö·ûÐÍ¡£ÎªÁ˽øÒ»²½Àí½â£¬¿ÉÒÔµ¼³öÒ»¸öÊý¾Ý´°¿Ú²¢²é¿´ËüµÄÔ­Â룬¿ÉÒÔ·¢ÏÖ¼´Ê¹ÊÇÁеÄÑÕÉ«ÊôÐÔËüÒ²ÊÇʹÓôøË«ÒýºÅµÄÊý×ÖÀ´±í´ï¡£
4¡¢ÈçºÎÔÚÊý¾Ý´°¿Ú£¨Datawindow£©ÖпìËÙɾ³ý¶àÐÐ ÔÚ¿ª·¢¹ý³ÌÖпÉÄܾ­³£ÓÐÒª½øÐжàÐÐɾ³ýµÄ²Ù×÷£¬Ò»°ã¶¼Ê¹ÓÃÑ­»·Óï¾ä½øÐвÙ×÷£º
5¡¢ÈçºÎÔÚDataWindowµÄSQLÓï·¨Öв»Ê¹ÓÃSELECT DISTINCTʵÏÖɾ³ýÖظ´µÄÐÐ Ê×ÏȶÔÄãÒªÏÔʾΨһֵµÄÁнøÐÐÅÅÐò£º"money"£¬È»ºóÔö¼ÓÈçϹýÂË×Ö·û´®£º" money < > money [-1] or GetRow () = 1"
6¡¢ÈçºÎÔÚ·Ö×éÐÎʽµÄDataWindowÖзֱðÏÔʾ¸÷×éµÄÐкÅ
  µ±ÎÒÃÇΪDatawindowµÄÿһÐÐÏÔʾÐкÅʱ£¬¿ÉÒÔ¼òµ¥µÄ·ÅÒ»¸ö±í´ïʽΪGetRow()¼ÆËãÁС£µ«ÊǶÔÓÚ·Ö×éµÄDatawindow£¬Òª·Ö±ðÏÔʾ¸÷×éµÄÐкţ¬ÔòӦʹÓñí´ïʽΪGetRow() - First(GetRow() for Group 1) 1µÄ¼ÆËãÁС£
7¡¢ÈçºÎ¸Ä±äÁеÄ×ÖÌåÑÕÉ«£¬ÒÔÌáÐÑÓû§´ËÁÐÒÑ×öÐÞ¸Ä
  ÔÚÁеÄColorÊôÐÔÖУ¬ÊäÈëÈçϱí´ïʽIF (column_name < >column_name.Original, RGB(255, 0, 0), RGB(0, 0, 0))¡£ÔÚÕâ¸öÌõ¼þÖУ¬Èç¹û´ËÁÐÒѸı䣬ÔòÏÔʾºìÉ«×ÖÌ壬·ñÔòÏÔʾºÚÉ«×ÖÌå¡£Õâ¸ö±í´ïʽÖ÷ÒªÓÃcolumn_name < > column_name.Original±È½Ïµ±Ç°ÁеÄÖµºÍԭʼÁеÄÖµÊÇ·ñÏàͬÀ´´ïµ½ÅжϵÄÄ¿µ


Ïà¹ØÎĵµ£º

redhat linux enterprise 5 °²×°Oracle10G

1¡¢ÓÉÓÚorcale10²»Ö§³Ö redhat as5 ÐèÒªÐÞ¸Ä/etc/redhat-realease ½« Red
  Hat Enterprise Linux Server release 5 (Tikanga) ¸ÄΪRed Hat Enterprise
 Linux Server release 4 (Tikanga) £¬°²×°Íê³ÉºóÔÙ½«ÆäÐ޸ĻØÀ´
2¡¢ÐÞ¸Ä/etc/hosts Îļþ½«127.0.0.1¸ÄΪ±¾»úIPµØÖ· ·ñÔòÍøÂç¼ì²éͨ²»¹ý
 
3¡¢¼ì² ......

·´°²×°Sql Server 2005

ͨ¹ý“Ìí¼Óɾ³ý³ÌÐò”Àï²¢²»ÄÜÍêȫɾ³ýSQlL server¡£
ͨ¹ýÏÂÃæµÄÃüÁÍêÈ«·´°²×°SQL server 2005
d:\Setup.exe 
/
qb REMOVE
=ALL
 INSTANCENAME
=<
InstanceName
>
ĬÈÏʵÀýµÄÃû×ÖÊÇMSSQLSERVER
ÒýÓÃÎÄÕµØÖ·£ºhttp://www.cnblogs.com/jvstudio/archive/2010/01/17/1650089.ht ......

ORACLE SQLÐÔÄÜÓÅ»¯

ORACLE SQLÐÔÄÜÓÅ»¯
ÎÒÒª½²µÄÌâÄ¿ÊÇOracle SQLÐÔÄÜÓÅ»¯£¬Ö»ÊÇOracleÐÔÄÜÓÅ»¯ÖеÄÒ»Ïî¡£OracleµÄÐÔÄÜÓÅ»¯°üº¬ºÜ¶à·½Ã棬±ÈÈçµ÷ÕûÎïÀí´æÈ¡£¬µ÷ÕûÂß¼­´æÈ¡£¬µ÷ÕûÄÚ´æʹÓ㬼õÉÙÍøÂçÁ÷Á¿µÈ¡£ÕâÀïÑ¡ÔñSQLÐÔÄÜÓÅ»¯ÊÇÒòΪÕⲿ·ÖÄÚÈÝÎÒÃDzâÊÔÈËÔ±×îÈÝÒ×½Ó´¥µ½£¬ÁíÍ⿪·¢ÈËԱдSQL½Å±¾Ê±ÓÐʱºÜËæÒ⣬²»Öª²»¾õ¾Í»áÔì³É³ÌÐòÐÔÄÜÉϵÄÏ ......

¸øPL/SQL´´½¨Õ˺š¢ÃÜÂëºÍ¸¶È¨ÏÞ

¸øPL/SQL´´½¨Õ˺š¢ÃÜÂëºÍ¸¶È¨ÏÞ
CREATE USER zxd  PROFILE "DEFAULT" IDENTIFIED BY zxd DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK
grant dba to "zxd";
F:\oracle\ora92\network\admin  Â·¾¶ÏÂtnsnames.ora
ZXD =
  (DESCRIPTION =
  &nb ......

[SQL Server2005]SQL ServerËÀËø×ܽá(ת)

1. ËÀËøÔ­Àí
    ¸ù¾Ý²Ù×÷ϵͳÖеĶ¨Ò壺ËÀËøÊÇÖ¸ÔÚÒ»×é½ø³ÌÖеĸ÷¸ö½ø³Ì¾ùÕ¼Óв»»áÊͷŵÄ×ÊÔ´£¬µ«Òò»¥ÏàÉêÇë±»ÆäËû½ø³ÌËùÕ¾Óò»»áÊͷŵÄ×ÊÔ´¶ø´¦ÓÚµÄÒ»ÖÖÓÀ¾ÃµÈ´ý״̬¡£
    ËÀËøµÄËĸö±ØÒªÌõ¼þ£º
»¥³âÌõ¼þ(Mutual exclusion)£º×ÊÔ´²»Äܱ»¹²Ïí£¬Ö»ÄÜÓÉÒ»¸ö½ø³ÌʹÓá£
ÇëÇóÓë±£³ÖÌõ¼þ(Ho ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ