ORACLE ´´½¨Êý¾Ý¿âÁ¬½ÓDBLink
CREATE PUBLIC DATABASE LINK ASXT_LINK ;
CONNECT TO ASXT IDENTIFIED BY PASSWORD ;
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = AAA)))';
Ïà¹ØÎĵµ£º
·½·¨Ò»£º
SQL>create table aa(a number);
´´½¨³É¹¦¡£
SQL> select * from aa;
A
--------
2
SQL>
SQL> insert all
2 into aa values(1)
3 into aa values(2)
4 select * from dual;
ÒÑ´´½¨2ÐС£
SQL> commit;
Ìá½»Íê³É¡£
SQL> select * from aa;
A
----------
2
1
2
·½·¨¶þ£º
S ......
×Ô¼º¾õµÃ¶ÔOracle»¹ÕÆÎյò»´í£¬²»¹ý×òÌì¸ô±ÚʵÑéÊÒµÄͬѧÎÊÁËÎÒÒ»¸öÎÊÌâÈÃÎÒÓôÃÆÁËÒ»°Ñ¡£ËýÔÚÒ»¸öÊý¾Ý¿âÀï°ÑÒ»¸öÓû§AµÄÔÚ±í¿Õ¼äAAÉϵıí
ÓÃexpµ¼³öµ½exp.dmpÎļþÖУ¬ÔÙ°ÑËüµ¼Èëµ½Áíһ̨»úÆ÷ÉϵÄÊý¾Ý¿âÀÕâʱËýÓõÄÊÇÓû§B£¬Ä¬Èϱí¿Õ¼äÊÇBB£¬µ«ÊÇÓÃimpµ¼ÈëʱÎÒÃÇ·¢ÏÖ±íÊǵ¼Èë
µ½ÁËBÓû§Ï£¬µ«ÊÇ»¹ÊÇ´æÔÚÁËAA±í¿Õ¼äÀïÃæ ......
ÔÚÒ»¸ö»ùÓÚTCP/IPÐÒéµÄÍøÂç»·¾³ÖУ¬oracleÊý¾Ý·þÎñÆ÷ÔÚһ̨¼ÆËã»úÉÏ£¬¿Í»§¶ËÔÚÁíÍâһ̨¼ÆËã»úÉÏ£¬¿Í»§¶ËÒªÁ¬½Óµ½oracle·þÎñÆ÷ÎÒÃǾ³£»áÊäÈ룺"C£º\sqlplus scott/tiger@shanghai"£¬ÕâÊÇoracle¿Í»§¶ËÁ¬½Ó·þÎñÆ÷ʱʹÓõÄÁ¬½ÓÃüÁÆäÖÐsqlplusÊÇoracle¿Í»§¶Ë³ÌÐò£¬scott/tigerÊǵǽ·þ ......
Ò»¡¢ Êý¾Ý¿â ORACLE
ËäÈ»ÕâЩÌâÄ¿¶¼¿ÉÒÔGµ½£¬µ«»¹ÊÇÒª¿¼²ìÒ»ÏÂÄúÏÖÔڵij£Ì¬Ë®Æ½£¬£º£©
T±í£º£¨×ֶΣºID£¬NAME£¬ADDRESS£¬PHONE£¬LOGDATE£©
E±í£º£¨×ֶΣºNAME£¬ADDRESS£¬PHONE£©
1£® ½«±íTÖеÄ×Ö¶ÎLOGDATEÖÐΪ2001-02-11µÄÊý¾Ý¸üÐÂΪ2003-01-01£¬Çëд³öÏàÓ¦µÄSQLÓï¾ä¡££¨¸Ã×Ö¶ÎÀàÐÍΪÈÕÆÚÀàÐÍ£©
2£® Çëд³ö½«±íTÖÐNAME ......
TO_DATE¸ñʽ
Day:
dd number 12
dy abbreviated fri
day spelled out friday
ddspth spelled out, ordinal twelfth
Month:
mm number 03
mon abbreviated mar
month spelled out march
Year:
yy two digits 98
yyyy four digits 1998
24Сʱ¸ñʽÏÂʱ¼ä·¶Î§Îª£º 0:00:00 - 23:59:59....
12Сʱ¸ ......