oracleÁ¬½ÓÔ¶³ÌÊý¾Ý¿â
D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN
6¡¢ÐÞ¸Äoracle°²×°Â·¾¶ÏÂD:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.oraµÄtnsnames.oraÎļþ£¬Ìí¼Ó
XXX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.42)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = poµÄ)
)
)
×¢£ºÒòoracleµÄ°²×°Â·¾¶²»Í¬£¬ÉÏÊö·¾¶¿ÉÄܲ»Í¬£¬ÊÓÇé¿ö¶ø¶¨¡£
CPSΪPL/SQL DeveloperÁ¬½ÓÔ¶³ÌÊý¾Ý¿âʱǰ̨ÏÔʾµÄÊý¾Ý¿âÃû³Æ£¬¿ÉÈÎÒⶨÒå
192.168.12.42 ΪҪÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄIPµØÖ·
portal ΪԶ³ÌÁ¬½ÓÊý¾Ý¿âµÄʵÀýÃû³Æ
Ïà¹ØÎĵµ£º
»¹ÊǽèÖú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Ö´Ðмƻ®µÄһЩ»ù±¾¸ÅÄ¹©Ñ§Ï°Ó¦Óá£
Ò»£®Ïà¹ØµÄ¸ÅÄî
RowidµÄ¸ÅÄrowidÊÇÒ»¸öαÁУ¬¼ÈÈ»ÊÇαÁУ¬ÄÇôÕâ¸öÁоͲ»ÊÇÓû§¶¨Ò壬¶øÊÇϵͳ×Ô¼º¸ø¼ÓÉϵġ£¶Ôÿ¸ö±í¶¼ÓÐÒ»¸örowidµÄαÁУ¬µ«ÊDZíÖв¢²»ÎïÀí´æ´¢ROWIDÁеÄÖµ¡£²»¹ýÄã¿ÉÒÔÏñʹÓÃÆäËüÁÐÄÇÑùʹÓÃËü£¬µ«ÊDz»ÄÜɾ³ý¸ÄÁУ¬Ò²²»ÄܶԸÃÁеÄÖµ½øÐÐÐ޸ġ ......
Îҵݲװ¹ý³Ì
1¡¢±à¼ /etc/apt/sources.list £º
sudo cp /etc/apt/sources.list /etc/apt/sources.list.bak #±¸·Ý
sudo gedit /etc/apt/sources.list
¼ÓÈëÏÂÃæÕâ¸öÔ´£º
deb http://oss.oracle.com/debian unst ......
1 - / , . ; :
"text" ʱ¼ä·Ö¸ô·ûºÅ£¬³ýÁ˱ê×¼µÄ¼¸¸ö£¬»¹ÔÊÐíÓÃÎÄ×Ö×÷Ϊ·Ö¸î·ûºÅ¡£
ÀýÈç to_char(sysdate,'YYYY"Äê"mm"ÔÂ"dd"ÈÕ"')=2008Äê04ÔÂ24ÈÕ
2 AD
A.D. ¼´À¶¡ÎÄAnno DominiµÄ¼òд£¬±íʾ¹«Ôª.»á¸ù¾ÝnlsµÄ²»Í¬×ª»»Îª¹«Ôª»òÕßadµÈ
ÎÞÌØÊâ×¢ÒâÊÂÏî
3 AM
A.M. ÉÏ ......
Ë÷Òý
ΨһË÷Òý£º
ÁÐÖÐÎÞÖظ´Öµ£¬Î¨Ò»Ô¼Êø¡£
oracle×Ô¶¯ÎªÖ÷¼üºÍΪһ¼üÁд´½¨Î¨Ò»Ë÷Òý
Óï·¨£ºcreate unique index Ë÷ÒýÃû on ±íÃû(ÁÐÃû);
×éºÏË÷Òý£º
ÔÚ±íÖжà¸ö×Ö¶ÎÉÏ´´½¨µÄË÷Òý
Áа´ÈÎÒâ˳ÐòÅÅÁÐ
where×Ó¾äÖаüº¬¶à¸öÁеIJéѯ£¬¿ÉÌá¸ß·ÃÎÊËٶȡ£
Óï·¨£ºcreate index Ë÷ÒýÃû on ±íÃû(ÁÐÃû1,ÁÐÃû2,...,ÁÐÃûn)£º
·´ ......