Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

oracle Êý¾Ý¿â»¥·ÃµÄÎÊÌâ

¸÷λ´óϺ£¬Ð¡µÜ¸Õ½Ó´¥oracleÊý¾Ý¿â£¬ÏÖÔÚҪʵÏÖA¡¢BÁ½¸öÊý¾Ý¿â»¥Ïà·ÃÎÊ£¬Á½¸öÊý¾Ý¿â·Ö±ð²¿ÊðÔÚÁ½Ì¨·þÎñÆ÷ÉÏ£¬ÓÐûÓÐÀàËÆdb2ÄÇÑùͨ¹ýÁª°î¹ØÏµÊµÏÖ£¿£¿ÇóÏêϸʵÏÖ²½Ö裬ллÁË£¬×ø×ŰåµÊµÈ¸÷λ´óϺ£¡£¡£¡£¡
create database link linkfwq
¡¡¡¡ connect to fzept identified by neu
¡¡¡¡ using '(DESCRIPTION = ......

Oracle database ¸ßÈ˳öÏÖ°É¡£¡£¡£¡£

¹ØÓÚ×öÊý¾Ý¿â¹¤×÷¿¼Ê²Ã´UNIX²Ù×÷ϵͳÈÏÖ¤±È½ÏºÃ£¿
´ó¼ÒÓ»Ô¾·¢ÑÔ£¬¸øµãÒâ¼û £¬Ð¡µÜÔٴθÐл£¬

IBM -AIX?
ºìñ-RHCE?
PH UnixµÄÈÏÖ¤£¿

Õ¼¸ö×ù£¬¿´¸ßÈË·¢ÑÔ¡£¡£¡£


¾­Ñé×îÖØÒª...

...

ºìñ-RHCE?
ÓõĶà


ÆÚ´ý. ´ó¼ÒÓ»Ô¾·¢ÑÔ

¾­Ñé×îÖØÒª ²»¹ý¿¼Ö¤¿ÉÒÔ´Ù½øÑ§Ï°

ÒªÏòÊý¾Ý¿â·½Ï ......

´´½¨ÊýOracleÊý¾Ý¿âµÄ±í¿Õ¼ä

´´½¨ÊýOracleÊý¾Ý¿âµÄ±í¿Õ¼ä£¬Ä¬ÈÏÊÇÔÚsystemÏ£¬ÏëÒªÖ¸¶¨Ò»¸öÌØ¶¨µÄÓû§Ï£¬ÈçºÎ´´½¨
Ëæ±ãÒ»ÃÅÈëÃÅÊé¼®É϶¼ÓÐ˵µÄ!


´´½¨Óû§²¢Ö¸¶¨±í¿Õ¼ä¡£

SQL code:

//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace user_temp
tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf'
size 50m
autoextend on
......

OracleÊý¾Ý¿â ÀàÐÍdateÔõôµÄµ±Ç°ÈÕÆÚ--ÔÚÏßµÈ

¸÷λ ÎÊÏÂÔÚ.netÖÐ ÔõôµÃµ½µ±Ç°ÈÕÆÚÁË  СµÜÁ¬½ÓµÄÊÇOracleÊý¾Ý¿â Òª²åÈëÒ»ÌõÊý¾ÝµÃµ½µ±Ç°ÈÕÆÚ

string insertdate = DateTime.Now.ToLongTimeString();

µÃµ½µÄÈ´ÊÇ10:49:32 ÊÇÔõô»ØÊÂÁË  ÎÒÏëÈÃËüµÃµ½2009-11-16  »ò2009-11-16-10:49:32 Ó¦¸ÃÔõôдÁË£¿£¿
ÔÚÏßµÈ

DateTime.Now.ToSh ......

Ò»Ìõoracle ÖеÄsqlÓï¾ä£¿

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ÏÂÔØµØÖ·]

Âé·³´ó¼ÒÁË
ÎÒÕâ¸öÈËÓ¢Óï²»ºÃ£¬¹Ù·½¸øµÄOracleµÄÏÂÔØµØÖ·¶¼ÊÇÓ¢ÎÄµÄ ÎÒ¿´²»¶®£¬ÎÒÏÖÔڵIJÙ×÷ϵͳÊÇ£ºMircosoft Windows XP Professional °æ±¾ 2002 Service Pack 3
Çë´ó¼Ò¸ø¸öÕâ¸öϵͳÄÜÓõÄOracleÊý¾Ý¿âÏÂÔØµØÖ·£¬±ð¸øÓкöàÏÂÔØÏîµÄ ÎÒ˵ÁË ÎÒÓ¢ÎÄ¿´²»¶®µÄ ллÄãÃÇÁË
¸ø¸öÄܵã»÷ÏÂÔØ Ö±½Óµ¯³öѸÀ×ÏÂÔØ¿òµÄ
......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [3286] [3287] [3288] [3289] 3290 [3291] [3292] [3293] [3294] [3295]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ