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£¬Ì¨Ê½»úµÄUbuntu²»Îȶ¨ÀÏ»µ£¬·ÅÆúÁËlinuxÉÏʹÓÃoracleµÄÏë·¨£¬ÔÚ×Ô¼º±Ê¼Ç±¾ÉÏ×°ÁËÒ»¸öoracle 10g express°æ±¾£¬Ñ§Ï°Ò»Ï¡£
±¾À´»¹ÏëÓÃÔÆ¶ËÐéÄ⻯һÏÂoracle£¬ÊµÑéʧ°Ü£¬ÀÏÀÏʵʵÈÃoracleÇÖÈëÎÒµÄϵͳ¡£¡£¡£囧
°²×°Íê ......
sql plus ±£´æsqlÓï¾ä
save 'd:\sql.txt';½«oracle»º´æÇøÖеÄsqlÓï¾ä´æÈëÎļþ¡£
get 'd:\sql.txt';´ËʱsqlÓï¾ä±»¼ÓÔØµ½oracle»º´æÇø£¬Ê¹ÓÃrun;ÃüÁîÖ´ÐÐsqlÓï¾ä¡£
@'d:\sql.txt';¼ÓÔØsqlÓï¾ä²¢Ö±½ÓÖ´ÐС£
oracleÖеĺ¯Êý
1. ת»»º¯Êý
TO_CHAR(number[,format])
½«Ò»¸öÊýֵת»»³ÉÓëÖ®µÈ¼ÛµÄ×Ö·û´®.Èç¹û²»Ö¸ ......
±¾ÎÄÊÇOracle¼¼ÊõÈËÔ±ÇóÖ°ÃæÊÔÌ⼯½õ£¬´ð°¸½ö¹©²Î¿¼……
¡¡¡¡1. ½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
¡¡¡¡½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵãÔÚÓÚµ±±¸·Ýʱ£¬Êý¾Ý¿âÈԾɿÉÒÔ±»Ê¹Óò¢ÇÒ¿ ......
oracle±í·ÖÇø
oracleÔÊÐíÓû§¶Ô±í½øÐнøÒ»²½¹æ»®£¬¼´¶Ô±í½øÐнøÒ»²½²ð·Ö£¬½«±í·Ö³ÉÈô¸É¸öÂß¼²¿·Ö£¬Ãð¸ö²»·Á³ÆÆäΪ±í·ÖÇø
·¶Î§·ÖÇø£º
¸ù¾Ý±íÖÐÁÐÖµµÄ·¶Î§½øÐзÖÇø
Óï·¨£ºPartition by range(×Ö¶ÎÃû)(
Partition ·ÖÇøÃû values less than (60), --60ÒÔÏÂ
Partition ·ÖÇøÃû values less than (75), --60¡«75
......
±í·ÖÇøÎ¬»¤£º
Ìí¼Ó·ÖÇø£º
Alter table student add partition ·ÖÇøÃû values less than(100);
ɾ³ý·ÖÇø£º
Alter table student drop partition ·ÖÇøÃû;
½Ø¶Ì·ÖÇø£º
Alter table student truncate partition ·ÖÇøÃû;
ºÏ²¢·ÖÇø£º
Alter table student merge partitions ·ÖÇøÃû,...,·ÖÇøÃû into partition зÖÇøÃû; ......