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

asp¡¢delphi¡¢oracleµÄ¼¼ÊõÎĵµ×ܽá

1) DelphiÏòoracleÖд«µÝ²ÎÊý ÈçoracleÖеIJÎÊýÃûΪerpcx 
´ð£ºÈç¹ûÏë´Ó±íÀïȡֵµ½oracle£¬Ôòerpcx:=trim(aq1.fieldbyname('erpcx').AsString);
·ñÔòÖ±½ÓÓÿؼþÃû×Ö
Óï¾äΪ
with aperp do    
begin
connection:=dm.ADOCerp;      
parameters.Clear;       
procedurename:='pc_erpbominquery';       
parameters.CreateParameter(erpcx,ftstring,pdinput,60,erpcx); ´Ë¾äΪ´«²ÎÊýÓï¾ä
·ñÔòÖ±½ÓÓÃ Parameters.CreateParameter('@erpcx',ftString,pdInput,100,edit5.text);        
ExecProc;    
end; 
  
2)sqlÈ¡ËÄÉáÎåÈëÖ°  round(×Ö¶ÎÃû£¬Ð¡ÊýµãºóλÊýÈçÈ¡ÕûÊýΪ0) 
 
3)sqlÁ¬½Óͬһ·þÎñÆ÷µÄ²»Í¬±íµÄÊý¾Ý 
´ð£ºselect * from Êý¾Ý¿âÃû.dbo.±íÃû 
 
4£©ÒªÏë´Ó¶à¸ö±íÀï²éÊý¾Ý£¬aÀïÓÐ5¸ö bÀïÓÐ3¸ö cÀïÓÐ2¸öÏÔʾʱ¸ÃÈçºÎÈ¥µôÖØ¸´µÄ²¿·ÖÄØ
Èç ±ía                  ±íb                    ±íc
id  education          id    guanxi        id  work
0001  1´óѧ            0001    ¸¸×Ó          0001  1¹«Ë¾
0001  2´óѧ            0001    ĸ×Ó          0001  2¹«Ë¾
0001  3´óѧ            0001    ½ãÃÃ
0001  4´óѧ
´ð£ºalter table a add px int identity(1,1)
go
alter table b add px int identity(1,1)
go
alter table c add px int identity(1,1)
go
select  a.id,a.educatio


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

Oracle±¸·Ý½Å±¾


Ä¿±ê£ºÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£¬Ö»Òª»á¼òµ¥µÄlinuxÃüÁî¾ÍÄÜʵÏÖoracle expµÄ×Ô¶¯±¸·Ý
 
»·¾³£ºlinux as3+oracle9i
¾ßÌåµÄ²½Ö裺
 
1.ÓʼþÉèÖÃ
[root@sxapp1 mail]# cd /etc/mail
[root@sxapp1 mail]# mv submit.cf submit.cfbak
[root@sxapp1 spool]# chmod a+wrx mqueue/
[root@sxapp1 mail]# echo "sdsd ......

OracleÖÐTO_DATE¸ñʽ

http://www.cnblogs.com/ajian/archive/2009/08/25/1421063.html
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02   13:45:25ΪÀý)
  
        Year:     
        yy two digits Á½Î»Äê   &nbs ......

oracle¸´Ï°£¨Èý£© Ö®OracleÊý¾Ý×ÖµäºÍ¿ØÖÆÎļþ

      ½ñÌ츴ϰOracleµÄÊý¾Ý×ÖµäºÍ¿ØÖÆÎļþ¡£
Ò»¡¢Êý¾Ý×Öµä
      Êý¾Ý×ÖµäÊÇÓÉOracle·þÎñÆ÷´´½¨ºÍά»¤µÄÒ»×éÖ»¶ÁµÄϵͳ±í£¬Êý¾Ý×Öµä·ÖΪÁ½´óÀࣺһÀàΪ»ù±í£¬Ò»ÀàΪÊý¾Ý×ÖµäÊÓͼ¡£ÄÇôÊý¾Ý×ÖµäÖÐÓÖ´æÓÐÄÄЩÐÅÏ¢ÄØ£¿
1¡¢Êý¾Ý¿âµÄÂß¼­½á¹¹ºÍÎïÀí½á¹¹
2¡¢ËùÓÐÊý¾Ý¿â¶Ô ......

ÐÞ¸ÄORACLE×î´ó»á»°Êý

ÐÞ¸ÄORACLE×î´ó»á»°Êý ²é¿´µ±Ç°oracle×î´ó»á»°Êý show parameter Ìõ¼þ Ìõ¼þ¿ÉÒÔʹÓòÎÊýÃûÖаüº¬µÄ¼¸¸ö×Öĸ£¬Èçshow parameter process½«ÏÔʾ NAME TYPE VALUE
------------------------------------ ----------- ------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_p ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ