Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Inthirties OracleÂÛ̳ÈÕ¶ÀÁ¢IPÍ»ÆÆ200

 Inthirties OracleÂÛ̳ÈÕ¶ÀÁ¢IPÁ¬ÐøÒ»ÖÜÍ»ÆÆ200  http://www.inthirties.com
Ò²Ðí200¸ù±¾¾ÍºÜÉÙ£¬µ«ÊǶÔÓÚinthirtiesÀ´Ëµ£¬ÒѾ­ÊÇÒ»¸öºÜÐÀοµÄÊÂß·¡£ ÔÙ½ÓÔÙÀ÷£¬°ÑInthirties OracleÂÛ̳°ì³ÉʵÓõÄѧϰOracleµÄÂÛ̳¡£


Ïà¹ØÎĵµ£º

ORACLE 10g Öлָ´ÒÑɾ³ýµÄ±í_flashback


-- ±Ê¼ÇÖв¿·ÖÄÚÈÝ
SQL> create table tt2 as select * from employee;
Table created.
SQL> drop table tt2;
Table dropped.
SQL> select * from tt2;
select * from tt2
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> flashback table tt2 to before drop;
Flashback comp ......

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracleÎı¾Îļþµ¼Èëµ¼³ö(sqlldr&&spool)

 ¹ØÓÚµ¼³ö
¡¡¡¡Ô­Àí
¡¡¡¡Í¨¹ýsqlplusµÄµÄ±¨±í¹¦ÄÜÉú³ÉÎı¾Îļþ£¬µ«²úÉúµÄÎı¾ÎļþÒò·ÖÎöÔ­Òò´æÔÚ¿ÕÐÐÏÖÏó£¨Ö»ÓлسµÃ»ÓÐÆäËü£©£¬¿ÉÒÔͨ¹ýµÚÈý·½·½Ê½´¦ÀíÒ»ÏÂÉú³É±ê×¼Îı¾
¡¡¡¡A ѧϰ¹ý³Ì
¡¡¡¡1¡¡½¨±í
¡¡¡¡
¡¡¡¡SQL>CREATE TABLE TESTINOUT(ID NUMBER(10), USERNAME VARCHAR2(10), DATE1 DATE, MONEY NUMBER(6 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ