ORACLE ºÁÃëת»»ÎªÈÕÆÚ ÈÕÆÚת»»ºÁÃë
--ÈÕÆÚת»»ºÁÃë
SELECT TO_NUMBER(TO_DATE('2005-03-29 12:30:45', 'YYYY-MM-DD HH24:MI:SS') -
TO_DATE('1970-01-01 8:0:0', 'YYYY-MM-DD HH24:MI:SS')) * 24 * 60 * 60 * 1000
from DUAL;
--ºÁÃëת»»ÈÕÆÚ
SELECT TO_CHAR(1112070645000 / (1000 * 60 * 60 * 24) +
TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD HH:MI:SS') AS CDATE
from DUAL;
Ïà¹ØÎĵµ£º
Create [or replace] trigger [ģʽ.]´¥·¢Æ÷Ãû
Before| after |instead of insert|delete|(update of ÁÐÃû)
{insert|delete|(update of ÁÐÃû) }
On ±íÃû|ÊÓͼ|ģʽÃû|Êý¾Ý¿âÃû
[for each row]
When Ìõ¼þ
PL/SQL¿é
˵Ã÷£º
......
1.×¼±¸¹¤×÷£º
°²×°32λ»ò64λRHEL5.4£¬°²×°Ïòµ¼Öв»ÐèҪѡÈκÎ×é¼þ£¬²»ÐèÒªÔ¤ÅäÖÃÈκÎÓû§£¬IPÊÇDHCP»ò¾²Ì¬½Ô¿É¡£
°²×°ºóÅäÖöîÍâ×é¼þ£º
yum -y install libXp,make,binutils,gcc,kernel-headers,glibc-headers,glibc-devel,libgomp
ÔÚx86_64ÉÏ»¹ÐèÒªcompat-libstdc++-33.x86_64
¶Ôx86£¬ÉÏ´«²¢½âѹ10201_database_lin ......
¹¦ÄÜ£ºOracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓëoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£´ó¶àÇé¿ö¶¼¿ÉÒÔÓÃOracleÊý¾Ýµ¼Èëµ¼³öÍê³ÉÊý¾ÝµÄ±¸·ÝºÍ»¹Ô£¨²»»áÔì³ÉÊý¾ÝµÄ¶ªÊ§£©¡£
¡¡¡¡OracleÓиöºÃ´¦£¬ËäÈ»ÄãµÄµçÄÔ²»ÊÇ·þÎñÆ÷£¬µ«ÊÇÄã×°ÁËoracle¿Í»§¶Ë£¬²¢½¨Á¢ÁËÁ¬½Ó £¨Í¨¹ýnet8 assistantÖб¾µØ——>·þÎñÃüÃû Ìí¼ÓÕýÈ·µÄ·þÎñÃüÃû
¡¡¡¡Æ ......
Oracle JDeveloper 10g Release Download
Oracle JDeveloper 10g (version 9.0.5.1, build 1605) for Windows NT/2000/X, Linux, Solaris, and HP-UX.
http://download.oracle.com/otn/java/jdeveloper/905/jdev9051.zip
http://download-east.oracle.com/otn/java/jdeveloper/905/jdev9051.zip
http://download-west ......
×Ô¼ºÕûÀíÁËÏÂOracleµÄÊý¾Ý¿â±¸·Ý·½°¸,ÓùýÀ䱸·Ý¡£ÆäËûûÓвâÊÔ¹ý
Ò»¡¢ µ¼³ö/µ¼Èë(Export/Import)
¡¡¡¡ÀûÓÃExport¿É½«Êý¾Ý´ÓÊý¾Ý¿â
ÖÐÌáÈ¡³öÀ´£¬ÀûÓÃImportÔò¿É½«ÌáÈ¡³öÀ´µÄÊý¾ÝËͻص½Oracle
Êý¾Ý¿âÖÐÈ¥¡£
¡¡¡¡1¡¢ ¼òµ¥µ¼³öÊý¾Ý(Export)ºÍµ¼ÈëÊý¾Ý(Import):
¡¡¡¡OracleÖ§³ÖÈýÖÖ·½Ê½ÀàÐ͵ÄÊä³ö£º
¡¡¡¡(1)¡¢±í·½Ê½(T·½ ......