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

oracleͬÒå´Ê

----------------------------------------------------------------------------
Ïà¹Ø֪ʶ£ºOracle SYNONYM£¨Í¬Òå´Ê£©
----------------------------------------------------------------------------
ÊÇÒ»ÖÖÓ³Éä¹Øϵ£¬¿ÉÒÔÀí½âΪ±íµÄÒ»Ö̶ֹ¨±ðÃû
ͬÒå´ÊµÄºÃ´¦£º½¨Á¢Ò»¸öͬÒå´Ê¿ÉÒÔÅųýÒ»¸ö¶ÔÏóÃû×ÖµÄÏÞÖÆ
Èç¹ûÄãµÄÊý¾Ý¿âÓжà¸öÓû§£¬USER_AÒª·ÃÎÊUSER_BµÄTABLE1,Ö»ÄÜʹÓÃUSER_B.TABLE1
½¨Ò»¸öͬÒå´ÊabcÖ¸ÏòUSER_B.TABLE1,ÄÇÄã¾Í¿ÉÒÔselect * from abcÁË,¶øÇÒpublicµÄͬÒå´Ê»áÖ±½Ó³öÏÖÔÚËùÓÐÓû§µÄÃæÇ°,ÓÐʱºò¿ÉÒÔ·½±ã¿ª·¢
´´½¨Í¬Òå´Ê£ºcreate public synonym synonym_name for user.table_name
ɾ³ýͬÒå´Ê£ºdrop public synonym synonym_name


Ïà¹ØÎĵµ£º

oracle 9i/10g°²×°°üºÍPATCHÏÂÔصØÖ·»ã×Ü

oracle 9i/10g°²×°°üºÍPATCHÏÂÔصØÖ·»ã×Ü
°ÑÏÂÃæµÄµØÖ·¸´ÖƵ½Ñ¶À×Àï¾Í¿ÉÒÔÏÂÔØ.
---------------------------------------------------------------------------------------------------
ORACLE 9i
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle ......

±±´óÇàÄñoracleѧϰ±Ê¼Ç3


»¹ÊǽèÖúoracle sql developerÀ´²Ù×÷oracle£¬sql plus»¹ÊÇÂé·³Ò»µã¡£
¼òµ¥¿´ÁËһϣ¬Óï¾ä»ù±¾É϶¼ºÍÆäËûÊý¾Ý¿âµÄsql²î²»¶à£¬¼Ç¼һϲ»Í¬µÄµØ·½¡£
ÈÕÆÚÀàÐͱ༭
update student set stu_birthday = to_date('2010-03-06 13:14:20','yyyy-MM-dd HH24:mi:ss');
ÐèҪʹÓÃto_date()º¯Êý£¬SQLÖв»Çø·Ö´óСд£¬MMºÍmm± ......

OracleÓëAIXµÄ½ÇÉ«

1.2.1  OracleÓëAIXµÄ½ÇÉ«
OracleÔËÐÐÔÚAIXÉÏ£¬Ìṩ×ÅÊý¾ÝµÄ´æ´¢ºÍ¹ÜÀí·þÎñ¡£Êý¾Ý¼´ÐÅÏ¢£¬OracleÊý¾Ý¿â¾ÍÊÇÓ¦ÓÃϵͳÖд洢Êý¾ÝÐÅÏ¢µÄÒ»¸ö¼¯Öд洢λÖá¢Ò»ÖÖ´æÈ¡·½·¨µÄÉÌÆ·»¯ÊµÏÖ¡£AIXÊdzÐÔØOracleÔËÐеĵײãƽ̨£¬½øÐÐ×ÅCPUµ÷¶È¡¢ÄÚ´æµ÷¶È¡¢´æ´¢¹ÜÀí¡¢Îļþ¹ÜÀí¡¢ÍøÂçÇý¶¯µÈϵͳÔËÐкÍά»¤¹¤×÷¡£
×÷Ϊ¶ÔÓ¦ÓÃϵͳµÄÖ§ ......

ora_01034:oracle not available±¨´í ½â¾ö·½·¨

ÒòΪǿÖƹػú£¬¿ª»úµÄʱºò½øÈëÊý¾Ý¿â±¨´í£º
ora_01034:oracle not available
ora_27101:shared memory realm does not exit
½â¾ö·½·¨£º
1.´ò¿ªCMD
2.ÊäÈë sqlplus "/as sysdba"
3.»Ø³µ
4.ÊäÈë startup
5.½áÊø ......

OracleÖÐto_char()²ÎÊýÏê½â

 1 -  /  ,  . ; :
"text" ʱ¼ä·Ö¸ô·ûºÅ£¬³ýÁ˱ê×¼µÄ¼¸¸ö£¬»¹ÔÊÐíÓÃÎÄ×Ö×÷Ϊ·Ö¸î·ûºÅ¡£
ÀýÈç to_char(sysdate,'YYYY"Äê"mm"ÔÂ"dd"ÈÕ"')=2008Äê04ÔÂ24ÈÕ
 2 AD
A.D.  ¼´À­¶¡ÎÄAnno DominiµÄ¼òд£¬±íʾ¹«Ôª.»á¸ù¾ÝnlsµÄ²»Í¬×ª»»Îª¹«Ôª»òÕßadµÈ
ÎÞÌØÊâ×¢ÒâÊÂÏî
 3 AM
A.M.  ÉÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ