oracle ÈÕÆÚÏÔʾӢÎĸñʽ
ÎÒÃdzõѧÕß°²×°oracleµÄʱºò£¬×Ö·û¼¯Ñ¡ÔñµÄÒ»°ãÊǼòÌåÖÐÎĵĸñʽ£¬Õâ·½±ãÎÒÃÇÓ¢ÎIJ»ºÃµÄ²ËÄñ£¬³ö´íµÄʱºò¶¨Î»´íÎ󣬵«ÊÇÓÐÒ»¸öÎÊÌâ°éËæ³öÏÖ£¬ÎÒÃÇд¹ØÓÚÈÕÆÚµÄsqlµÄÓï¾ä£¬ÎÒÃÇÏëÒªÓ¢ÎĵĸñʽÔõô°ì£¿ÏÂÃæÓÐÁ½¸ö°ì·¨£º
1. Á¬½Óµ½Êý¾Ý¿âºó£¬ÎÒÃÇʹÓÃÈçÏÂÓï¾ä
ALTER SESSION SET NLS_DATE_LANGUAGE='AMERICAN' ÐèҪעÒâµÄÊÇ£¬¶Ï¿ªÊý¾Ý¿âÁ¬½Óºó£¬×Ö·û¼¯»á»¹Ôµ½Ä¬ÈÏÖÐÎÄ×Ö·û¼¯
2.ÎÒÃǶ¨ÒåÈÕÆÚ¸ñʽµÄʱºò£¬Ò²¿ÉÒÔÀûÓÃÓï¾äʹÓÃÓ¢Îĸñʽ£¬µ«ÊÇ×÷Ó÷¶Î§½öÏÞÓÚ±¾Ìõ¶¨Òå¡£
È磺 to_char('18-dec-2009','dd-mon-yyyy','nls_date_language=american')
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
2009Äê12ÔÂ15ÈÕ5:25:47
Äã²»µÃ²»³ÐÈÏË÷ÒýµÄÇÉÃî×÷ÓÃ,ÓÉÓÚÓбíµÄÖ÷¼üΨһ±êʶ,ʹµÃÎÒÃÇÔÚ¼ìË÷±íÖÐÊý¾Ýʱ,ËÙ¶ÈÉÏ´øÀ´µÄÌáÉý,ÊÇÏÔ¶øÒ×¼ûµÄ.±ÈÆðÎÒÃÇûÓÐË÷ÒýÏàͬÁ¿µÄ±í,´øÓÐË÷ÒýµÄ±íÃ÷ÏÔÓÐËÙ¶ÈÉϵÄÌáÉý.[¶ÁÕß¿ÉÒÔµ¼ÈëÒ»ÕÅ300~400ÍòµÄÊý¾Ý¼ì²âÒ»ÏÂ.]
Ë÷ÒýÊDZíµÄÒ»¸ö¸ÅÄ·Ö,ÓÃÀ´Ìá¸ß¼ìË÷Êý¾ÝµÄÐ ......
¹Ø¼ü´Ê£ºwith read only
×÷ÓãºÓÃÓÚÖ¸¶¨Ëù´´½¨µÄÊÔͼ²»¿ÉÒÔͨ¹ý±¾ÊÓͼ¸üбí
Ö´ÐÐÒ»ÏÂSQL£¬´´½¨±íT£¬ºÍÁ½¸öÊÔͼV1£¬V2£º
CREATE TABLE T(ID INTEGER);
CREATE VIEW V1 AS SELECT * from T;
CREATE VIEW V2 AS SELECT * from T WITH READ ONLY;
Ö´ÐÐSQL:
INSERT INTO V1 VALUES(1);
--------------------
1 row cre ......
¿Î³Ì¸ÅÒª
¿Î³Ì±àºÅ
£ºXY-DB-V01
ÅàÑøÄ¿±ê
£º¾ß±¸Êµ¼Ê²Ù×÷ÄÜÁ¦µÄ Oracle Êý¾Ý¿â¹ÜÀíÔ±
רעOracleʵսÄÜÁ¦µÄÇ¿»¯£¬ÍêÈ«¸²¸ÇOCP¿Î³ÌÄÚÈÝ£¬¾ßÓиü´óµÄѧϰǿ¶ÈºÍ¸ü³¤µÄѧϰʱ¼ä¡£
ÈëѧÌõ¼þ
£º¶ÔOracle»òÆäËü¹ØÏµÊý¾Ý¿âÓÐÒ»¶¨µÄ»ù´¡Õß
°à±ð¼°ÊÚ¿Îʱ¼ä
£ºÍѲú°àÀúʱ1¸öÔ£¬1 ......
ÎÒÃÇÔÚ´´½¨±í½á¹¹µÄ¹ý³ÌÖУ¬¿ÉÄÜ»áÓÉÓÚʧÎó£¬Ôì³É±íÖÐÁÐÃû´íÎó£¬ÈçºÎ¸ü¸ÄÄØ£¬Äã¿ÉÄÜ»á»Ø´ð£¬Ê¹ÓÃOEM»òÕßPL/SQL£¬³ýÁËÕâÁ½ÖÖ·½·¨£¬ÎÒÃÇ¿ÉÒÔʹÓÃÃüÁ
ALTER TABLE ±íÃû rename column ÁÐÃû to ÐÂÁÐÃû ×¢ÒâcolumnÊǹؼü×Ö /*ÖØÃüÃûÁÐÃû*/
ALTE ......