delphiÈçºÎ±¸·ÝorcalÊý¾Ý¿â£¿ - Delphi / Êý¾Ý¿âÏà¹Ø
³ÌÐòʹÓõÄÊÇOrcalÊý¾Ý¿â£¬Ï붨ÆÚ£¨Ã¿¼¾¶È£©¶ÔÊý¾Ý¿â½øÐб¸·Ý£¬Ã»É¶Í·Ð÷£¬ÇëÎÊÓ¦¸ÃÔõôŪ£¿
ÓÐÊ²Ã´ÌØÊâÒªÇóÂ𣬱ÈÈçҪǰ¶Ë½çÃæ£¿ Ò»°ãÓÃÊý¾Ý¿â×Ô´øµÄ¡°¼Æ»®ÈÎÎñ¡±ÅäÖÃһϾ͹»ÁË Ã»ÓÐÊ²Ã´ÌØÊâÒªÇó¡£ÀýÈ磬ֻҪµã³ÌÐòµÄijһ¸ö°´Å¥£¬¾Í¿ÉÒÔ°Ñijһ¼¾¶ÈµÄÊý¾Ý±¸·Ýµ½´ÅÅÌÉÏ ½¨Á¢oracle partition£¬¶ÔÖ¸¶¨µÄpartition½øÐÐÊý¾Ý±¸·Ý£¬Äã¿ÉÒÔʹÓÃutl_fileÔÚ´æ´¢¹ý³ÌÖн«Êý¾ÝдÈëÎļþ¡£ http://www.cnblogs.com/pengyq/archive/2008/08/27/1277739.html ¶¨ÆÚÖ´ÐÐÕâ¸ö³ÌÐò(ʹÓÃEXPÃüÁîµ¼³ö),½á¹ûÊÇÔÚF:\dmp\Öд¢´æÃûΪmymis20100423.dmpµÄһϵÁÐÎļþ¡£ procedure TForm1.Button1Click(Sender: TObject); begin WinExec(pchar('D:\ora92\bin\exp mymis/123456@v2 file=F:\dmp\mymis'+formatdatetime('YYYYMMDD',date)+'.dmp owner=mymis'),SW_SHOW); end; oracleÊý¾Ý¿âµÄ±¸·Ý,¿ÉÒÔ²ÉÓÃrmanµÈ,ÔÚ·þÎñÆ÷ÉÏÉèÖÃ. Êý¾Ý±¸·Ýµ½´ÅÅÌÉÏÒýÓà ¶¨ÆÚÖ´ÐÐÕâ¸ö³ÌÐò(ʹÓÃEXPÃüÁîµ¼³ö),½á¹ûÊÇÔÚF:\dmp\Öд¢´æÃûΪmymis20100423.dmpµÄһϵÁÐÎļþ¡£ procedure TForm1.Button1Click(Sender: TObject); begin WinExec(pchar('D:\ora92\bin\exp mymis/123456@v2 file=F:\dmp\mymis'+formatdatetime¡¡ ÇëÎÊÕâÖÖ·½·¨Ö§³ÖÔ¶³Ì±¸·ÝÂ𣿠Çײâºó £¬expÃüÁîÖ§³ÖÔ¶³Ì±¸·Ý£¬²»¹ýÒª°²×°ÍêÕû¿Í»§¶Ë
Ïà¹ØÎÊ´ð£º
select * from shuju.DB where ¿ªÅ̼Û-ÊÕÅ̼Û<=0.02 ¿ªÅÌ¼Û ÓëÊÕÅÌ¼Û ÊÇÊý¾Ý¿âÀïµÄ×Ö¶Î select * from aTableName where ((¿ªÅ̼Û-ÊÕÅ̼Û) <=0.02 ) ¿ªÅ̼۱ÈÊÕÅ̼۵ÍÁ½·ÖÒÔϵÄÇé¿ö Mark!!!!!! se ......
Delphi(Pascal) code: function DBGridEhToExportFile(dbgrideh:TDBGridEh;filename:string='µ¼³öµÄÎļþ'):boolean ; var ExpClass:TDBGridEhExportClass; Ext:String; savedialog1:tsavedialog; b ......
ÈçÌ⣡ ÔÚDelphiÀïÃæµ÷ÓÃÎÒC#дµÄÒ»¸ö¿ÉÖ´ÐгÌÐò£¬È»ºóÔËÐÐDelphiµÄÓ¦ÓóÌÐòµÄʱºò£¬ÓкܴóµÄ¸ÅÂʵ÷Óò»ÉÏC#дµÄÓ¦ÓóÌÐò¡£ ´úÂë¿Ï¶¨Ã»ÓÐÎÊÌâ¡£ÓÐʱºòÄܵ÷ÓÃÉÏ£¬ÓÐʱºòµãÁËûÓз´Ó¦£¬¼´²»Äܵ ......
ºÜ¼òµ¥µÄÎÊÌ⣬ÈçºÎÔÚ×é¼þmapcontrolÖÐÏÔʾAutoCAD»æÖƵĵØÍ¼ÐÅÏ¢£¿ÇëÏêϸָ½Ì ʲôÇé¿ö£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ mapcontrolÊÇʲô¶«Î÷ѽ ÏÔʾAutoCAD»æÖƵĵØÍ¼ÐÅÏ¢,´ÓÍøÉÏÕҿؼþ°É, »òÕßÄúÓнâÊÍ ......
ÈçÌâËùʾ СµÜʹÓÃDelphi7»·¾³½øÐÐÊý¾Ý²É¼¯£¬²É¼¯µ½µÄÊý¾Ý·ÅÈëSQL Server2000Êý¾Ý¿âÖУ¬µ«ÊÇÏë²»°²×°SQLServer2000À´ÊµÏÖ´ÓÆäËü¼ÆËã»úÉÏÔËÐд˳ÌÐò£¬²»ÖªÈçºÎʵÏÖ£¿Íû¸÷λ´óϺ¸æÖªÒ»¶þ¡£ ÁíÍ⣬ÏÖÔÚСµÜÓöµ½ÁËÒ»¸ö ......