¸÷λ´óϺ£¬Ð¡µÜ¸Õ½Ó´¥oracleÊý¾Ý¿â£¬ÏÖÔÚҪʵÏÖA¡¢BÁ½¸öÊý¾Ý¿â»¥Ïà·ÃÎÊ£¬Á½¸öÊý¾Ý¿â·Ö±ð²¿ÊðÔÚÁ½Ì¨·þÎñÆ÷ÉÏ£¬ÓÐûÓÐÀàËÆdb2ÄÇÑùͨ¹ýÁª°î¹ØÏµÊµÏÖ£¿£¿ÇóÏêϸʵÏÖ²½Ö裬ллÁË£¬×ø×ŰåµÊµÈ¸÷λ´óϺ£¡£¡£¡£¡
create database link linkfwq
¡¡¡¡ connect to fzept identified by neu
¡¡¡¡ using '(DESCRIPTION = ......
¹ØÓÚ×öÊý¾Ý¿â¹¤×÷¿¼Ê²Ã´UNIX²Ù×÷ϵͳÈÏÖ¤±È½ÏºÃ£¿
´ó¼ÒÓ»Ô¾·¢ÑÔ£¬¸øµãÒâ¼û £¬Ð¡µÜÔٴθÐл£¬
IBM -AIX?
ºìñ-RHCE?
PH UnixµÄÈÏÖ¤£¿
Õ¼¸ö×ù£¬¿´¸ßÈË·¢ÑÔ¡£¡£¡£
¾Ñé×îÖØÒª...
...
ºìñ-RHCE?
ÓõĶà
ÆÚ´ý. ´ó¼ÒÓ»Ô¾·¢ÑÔ
¾Ñé×îÖØÒª ²»¹ý¿¼Ö¤¿ÉÒÔ´Ù½øÑ§Ï°
ÒªÏòÊý¾Ý¿â·½Ï ......
´´½¨ÊýOracleÊý¾Ý¿âµÄ±í¿Õ¼ä£¬Ä¬ÈÏÊÇÔÚsystemÏ£¬ÏëÒªÖ¸¶¨Ò»¸öÌØ¶¨µÄÓû§Ï£¬ÈçºÎ´´½¨
Ëæ±ãÒ»ÃÅÈëÃÅÊé¼®É϶¼ÓÐ˵µÄ!
´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä¡£
SQL code:
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace user_temp
tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf'
size 50m
autoextend on
......
¸÷λ ÎÊÏÂÔÚ.netÖÐ ÔõôµÃµ½µ±Ç°ÈÕÆÚÁË Ð¡µÜÁ¬½ÓµÄÊÇOracleÊý¾Ý¿â Òª²åÈëÒ»ÌõÊý¾ÝµÃµ½µ±Ç°ÈÕÆÚ
string insertdate = DateTime.Now.ToLongTimeString();
µÃµ½µÄÈ´ÊÇ10:49:32 ÊÇÔõô»ØÊÂÁË ÎÒÏëÈÃËüµÃµ½2009-11-16 »ò2009-11-16-10:49:32 Ó¦¸ÃÔõôдÁË£¿£¿
ÔÚÏßµÈ
DateTime.Now.ToSh ......
select * from table1 where a in (b)
ÆäÖÐa ÊDzÎÊý ¸ñʽ£º1
bÊDZíÖеÄÒ»×Ö¶Î ¸ñʽΪ£º1,2,3,4
Ҫȡ³öb×Ö¶ÎÖаüº¬aµÄ¼Ç¼
лл¸÷λ
select *
from table1
where instr(','||b||',',','||a||',')>0
......
Âé·³´ó¼ÒÁË
ÎÒÕâ¸öÈËÓ¢Óï²»ºÃ£¬¹Ù·½¸øµÄOracleµÄÏÂÔØµØÖ·¶¼ÊÇÓ¢ÎÄµÄ ÎÒ¿´²»¶®£¬ÎÒÏÖÔڵIJÙ×÷ϵͳÊÇ£ºMircosoft Windows XP Professional °æ±¾ 2002 Service Pack 3
Çë´ó¼Ò¸ø¸öÕâ¸öϵͳÄÜÓõÄOracleÊý¾Ý¿âÏÂÔØµØÖ·£¬±ð¸øÓкöàÏÂÔØÏîµÄ ÎÒ˵ÁË ÎÒÓ¢ÎÄ¿´²»¶®µÄ ллÄãÃÇÁË
¸ø¸öÄܵã»÷ÏÂÔØ Ö±½Óµ¯³öѸÀ×ÏÂÔØ¿òµÄ
......