Inthirties OracleÂÛ̳ÈÕ¶ÀÁ¢IPÍ»ÆÆ200
Inthirties OracleÂÛ̳ÈÕ¶ÀÁ¢IPÁ¬ÐøÒ»ÖÜÍ»ÆÆ200 http://www.inthirties.com
Ò²Ðí200¸ù±¾¾ÍºÜÉÙ£¬µ«ÊǶÔÓÚinthirtiesÀ´Ëµ£¬ÒѾÊÇÒ»¸öºÜÐÀοµÄÊÂß·¡£ ÔÙ½ÓÔÙÀ÷£¬°ÑInthirties OracleÂÛ̳°ì³ÉʵÓõÄѧϰOracleµÄÂÛ̳¡£
Ïà¹ØÎĵµ£º
-- ±Ê¼ÇÖв¿·ÖÄÚÈÝ
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 ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
¹ØÓÚµ¼³ö
¡¡¡¡ÔÀí
¡¡¡¡Í¨¹ýsqlplusµÄµÄ±¨±í¹¦ÄÜÉú³ÉÎı¾Îļþ£¬µ«²úÉúµÄÎı¾ÎļþÒò·ÖÎöÔÒò´æÔÚ¿ÕÐÐÏÖÏó£¨Ö»ÓлسµÃ»ÓÐÆäËü£©£¬¿ÉÒÔͨ¹ýµÚÈý·½·½Ê½´¦ÀíÒ»ÏÂÉú³É±ê×¼Îı¾
¡¡¡¡A ѧϰ¹ý³Ì
¡¡¡¡1¡¡½¨±í
¡¡¡¡
¡¡¡¡SQL>CREATE TABLE TESTINOUT(ID NUMBER(10), USERNAME VARCHAR2(10), DATE1 DATE, MONEY NUMBER(6 ......