ÎÒÔÚÖ´ÐÐselect Óï¾äʱ,ÏëÔÚnull ×Ö¶ÎÏÔʾ³öÎÒÏë²éѯµÄÊý¾Ý,µ«ÊÇ ³öÏÖÁËÏÂÃæµÄ´íÎó
¾ßÌåÓï¾äÊÇselect null from dual
expression must have same datatype as corresponding expression
to_char(info_date, 'yyyy-mm-dd hh24:mi:ss')
Èç¹ûÎÒÏëÕý³£ÏÔʾ,ÔõôÔÚnull ×öת»»
ÄãÖ´ÐеÄÊÇʲô ......
Êý¾Ý¿âÓõÄÊÇOracle8.0£º
ÓÐÁ½ÕÅͬÃûµÄ±í£¬¾É±íºÍÔھɱí»ù´¡ÉϼÓÉ϶à¸ö×ֶεÄÐÂ±í£¬ÏÖÔÚ¿Í»§ÒªÇó°Ñ¾É±íÖеÄÊý¾Ý·Åµ½Ð±íÖÐÈ¥£¬µ«Á½ÕűíµÄ½á¹¹²»Í¬(бí×ֶΰüÀ¨¾É±í×Ö¶Î)£¬Êý¾Ý´ó¸ÅÓÐ4ÍòÌõ×óÓÒ¡£
ÎÒʹÓÃ
insert into user1.db(×Ö¶Î1£¬×Ö¶Î2£¬...) select ×Ö¶Î1£¬×Ö¶Î2£¬... from us ......
ÎÒ´´½¨µÄÒ»Õűía,ÆäÖÐijһ×Ö¶Îzt¶¨ÒåΪint,ĬÈÏȡֵ£º0´ú±í¡®ÊÇ¡¯£¬1´ú±í¡®·ñ¡¯£¬
ÎÒÏÖÔÚÒª²éѯÕâÕÅ±í£¬µÃÈçϽá¹û£º
id mc zt
1 ´ð¶ÔÁË ÊÇ
Çë½Ì¸÷λ¸ÃÈçºÎʵÏÖ£¿
select id,mc,decode(zt,0,'ÊÇ',1,'·ñ') from a;
select id,mc,decode(zt,1,'ÊÇ ......
¸ÕÏÂÁËÒ»¸ö11gµÄ·þÎñÆ÷¶Ë³ÌÐò£¬°²×°ºÃÏñҲûÐèÒªÊÚȨÂëÖ®À࣬ÄѵÀÊÇÃâ·ÑµÄ£¿»¹ÊÇÓÐÒ»¶¨Ê±¼äµÄÊÔÓÃÆÚ£¿
ÕâÄêÍ·Ãâ·ÑµÄ¶«Î÷ÓÃ×ÅÒ²²»·ÅÐÄ£¬Òª²»oracleͨ¹ýʲô·½Ê½ÕõÇ®
Èç¹û²»ÊÇÉÌÒµ£¬¾Í²»ÐèÒªÊÚȨÂë
¿ÉÒÔÖ±½ÓÓõģ¬ÉÌÓõϰÊÇͨ¹ý·þÎñºÍÐí¿ÉÖ¤Êշѵ쬏öÈËÓÃûÊ£¬Ö»ÊÇû·þÎñ¡£
Õý°æµÄºÜ¹óµÄ£¬°´cpuËã»òÕß°´Á¬½Ó ......
admin ¡¢ora92 ¡¢ oradata ÕâÈý¸öÎļþ¼Ð¶¼ÓУ¬µ«ÊÇÊý¾Ý¿âÓ¦ÓóÌÐòÐ¶ÔØÁË£¬ÔÚ²»ÖªµÀÔ¶À´Êý¾Ý¿âµÄÕ˺ÅÃÜÂëµÄÇé¿öÏ£¬ÈçºÎ°²×°Oracle9i ²¢ÄÜ´ò¿ªÔÓеÄÊý¾Ý¿â£¿Ã»¶àÉÙ·Ö£¬ÕâЩ·ÖÉٵ㣬û°ì·¨°¡
ÓûùÓÚÀ䱸·ÝµÄ»Ö¸´·½Ê½À´½øÐлָ´¡£
°²×°ÒÔǰµÄĿ¼£¬°²×°Í¬°æ±¾µÄoracleÊý¾Ý¿â¡£
½¨Á¢Í¬sidµÄÊý¾Ý¿âʵÀý¡£¹ ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIPµØÖ·£¨Õâ¸öÎÒûÊÔ¹ý ²ÂµÄ ¾õµÃ¶Ë¿ÚºÅÓ¦¸Ã²»Í¬°É£©
ÒýÓÃ
ËûÃǵĶ˿ÚÊDz»Ò»ÑùµÄ
D:\oracle\product\10. ......