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
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
http://download.oracle ......
»¹ÊǽèÖú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± ......
1.2.1 OracleÓëAIXµÄ½ÇÉ«
OracleÔËÐÐÔÚAIXÉÏ£¬Ìṩ×ÅÊý¾ÝµÄ´æ´¢ºÍ¹ÜÀí·þÎñ¡£Êý¾Ý¼´ÐÅÏ¢£¬OracleÊý¾Ý¿â¾ÍÊÇÓ¦ÓÃϵͳÖд洢Êý¾ÝÐÅÏ¢µÄÒ»¸ö¼¯Öд洢λÖá¢Ò»ÖÖ´æÈ¡·½·¨µÄÉÌÆ·»¯ÊµÏÖ¡£AIXÊdzÐÔØOracleÔËÐеĵײãƽ̨£¬½øÐÐ×ÅCPUµ÷¶È¡¢ÄÚ´æµ÷¶È¡¢´æ´¢¹ÜÀí¡¢Îļþ¹ÜÀí¡¢ÍøÂçÇý¶¯µÈϵͳÔËÐкÍά»¤¹¤×÷¡£
×÷Ϊ¶ÔÓ¦ÓÃϵͳµÄÖ§ ......
ÒòΪǿÖƹػú£¬¿ª»úµÄʱºò½øÈëÊý¾Ý¿â±¨´í£º
ora_01034:oracle not available
ora_27101:shared memory realm does not exit
½â¾ö·½·¨£º
1.´ò¿ªCMD
2.ÊäÈë sqlplus "/as sysdba"
3.»Ø³µ
4.ÊäÈë startup
5.½áÊø ......
1 - / , . ; :
"text" ʱ¼ä·Ö¸ô·ûºÅ£¬³ýÁ˱ê×¼µÄ¼¸¸ö£¬»¹ÔÊÐíÓÃÎÄ×Ö×÷Ϊ·Ö¸î·ûºÅ¡£
ÀýÈç to_char(sysdate,'YYYY"Äê"mm"ÔÂ"dd"ÈÕ"')=2008Äê04ÔÂ24ÈÕ
2 AD
A.D. ¼´À¶¡ÎÄAnno DominiµÄ¼òд£¬±íʾ¹«Ôª.»á¸ù¾ÝnlsµÄ²»Í¬×ª»»Îª¹«Ôª»òÕßadµÈ
ÎÞÌØÊâ×¢ÒâÊÂÏî
3 AM
A.M. ÉÏ ......