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

oracle insertÓï·¨£¨ÈÕÆÚ¸ñʽ£©

insert into dts_auction_comments (id,auction_id,user_id,user_nick,comments,gmt_create,gmt_modified,status,comm_type)
                            values(409,127380,555,'xigee','xxxxrrrrreezz<br/><html>alert("hello");</html>alert <hal;ej¶Ô·½µÄ˵·¨z',to_date('2007-08-03 22:24:29','yyyy-mm-dd HH24-mi-ss'),to_date('2005-02-12 23:24:25','yyyy-mm-dd  HH24-mi-ss'),1,1);


Ïà¹ØÎĵµ£º

ORACLEËÀËø²éѯ¼´´¦Àí

¹ØÓÚÊý¾Ý¿âËÀËøµÄ¼ì²é·½·¨
Ò»¡¢         Êý¾Ý¿âËÀËøµÄÏÖÏó
³ÌÐòÔÚÖ´ÐеĹý³ÌÖУ¬µã»÷È·¶¨»ò±£´æ°´Å¥£¬³ÌÐòûÓÐÏìÓ¦£¬Ò²Ã»ÓгöÏÖ±¨´í¡£
¶þ¡¢        
ËÀËøµÄÔ­Àí
µ±¶ÔÓÚÊý¾Ý¿âij¸ö±íµÄijһÁÐ×ö¸üлòɾ³ýµÈ²Ù×÷£¬Ö´ÐÐÍê±Ïºó¸ÃÌõÓï¾ä ......

linuxϵͳÖÐÅäÖÃoracle¿ª»ú×ÔÆô¶¯

Centos  redhat ,oracle10g,oracle11g¾ùÊÊÓÃ
 
1.       ±àд½Å±¾£º
# vi  startoracle.sh
#11gµÄ»°Ö»ÊÇÕâ¸öĿ¼ÓÐËùÇø±ð
ORACLE_HOME=/home/oracle/product/10.2.0/db_1;export ORACLE_HOME
 
ORACLE_SID=orcl;export ORACLE_SID #ÕâÀïÅäÉÏÄãµÄ±¾µØÊ¾ÀýÃû
&nbs ......

oracleº¯Êý´óÈ« Êý×Ö´¦Àíº¯Êý


oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3    Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l         ABS
Óï·¨:   ABS(x)
¹¦ÄÜ:   µÃµ½xµÄ¾ø¶ÔÖ ......

APACHE PHP5 ORACLEÉèÖÃ

ÔÚwindows ÏÂÅäÖÃPHPʹÓÃORACLEÊý¾Ý¿âÒªµã
ÔÚwindowÏ£¬¾­³£ÓÃapache + PHP À´×öÓ¦ÓÃÆ½Ì¨£¬µ«ÊÇÈç¹ûʹÓÃoracle×öºǫ́Êý¾Ý¿â£¬µ«ÓÖûÓа²×°ÓÐoracle¿Í»§¶Ë£¬ÏÂÃæµÄÅäÖÿÉÒԲο¼
1¡¢ÔÚûÓа²×°oracleµÄ»úÆ÷ÉÏ£¬PHPÎÞ·¨¼ÓÔØphp_oci8.dllÄ£¿é£¬Ô­ÒòÊÇphp_oci8.dllÒÀÀµµÄÏà¹Ø×é¼þûÓÐÕÒµ½¡£
     ÄãÕýÈ·ÉèÖÃÁË ......

linux¹ØÓÚ$ORACLE_HOME/root.shºÍ/etc/oratab

1.°²×°Ê±ÒªÖ´ÐÐÁ½¸ö½Å±¾£¬root.shÊÇÆäÖÐÒ»¸ö¡£
   ÐèÒªÓÃrootÓû§Ö´ÐÐroot.shÈ¥Éú³É/etc/oratabÎļþ¡£————1.dbcaÖв»»áÓÐɾ³ýÑ¡Ïî(ÒòΪÔËÐÐʱÐèÒª/etc/oratab)
                   & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ