oracle²éѯ½¨±íʧ°Ü

ÓÃORACLE½¨±äµÄ²éѯºÜ¿ì³ö½á¹û£¬µ«Êǽ¨±íûÓз´Ó¦£¬ÊÇÔõô»ØÊÂà«£¿
ÀýÈç
CREATE TABLE TMP_TEST1 AS
SELECT * from AAA;
Õâ¸öÓï¾äÖ´Ðв»³öÀ´£¬µ«ÊÇÖ´ÐÐ
SELECT * from AAA;
ºÜ¿ì¾ÍÄܳö½á¹û

---

±íAAAÊý¾ÝÁ¿´óÂð£¿

---

¿´¿´²úÉúºÎÖֵȴýʼþ£¿

---

ÒýÓÃ

ÓÃORACLE½¨±äµÄ²éѯºÜ¿ì³ö½á¹û£¬µ«Êǽ¨±íûÓз´Ó¦£¬ÊÇÔõô»ØÊÂà«£¿
ÀýÈç
CREATE TABLE TMP_TEST1 AS
SELECT * from AAA;
Õâ¸öÓï¾äÖ´Ðв»³öÀ´£¬µ«ÊÇÖ´ÐÐ
SELECT * from AAA;
ºÜ¿ì¾ÍÄܳö½á¹û

Ö´Ðв»³öÀ´£¬ Õâ¸öµÄ±íÏÖÊÇʲô£¿ÊDZ¨´í£¿»¹ÊÇSQL ²»ÄܽáÊø£¬Ò»Ö±ÔÚÔËÐУ¿¡¡¡¡ÏÖÔÚµÄÓû§Óд´½¨±íµÄȨÏÞÂ𣿠


------------------------------------------------------------------------------ 
Blog£º http://blog.csdn.net/tianlesoftware 
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net 
Ïà¹ØÊÓƵ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx 
DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977

---

SELECT * from AAA;
ºÜ¿ì¾ÍÄܳö½á¹û¡£

ÊdzöÀ´ËùÓÐÊý¾Ý£¬»¹ÊDz¿·ÖÊý¾Ý£¿


´óÊý¾ÝÁ¿±í£¬´Ó¿ªÊ¼·µ»Ø½á¹û£¬µ½½á¹ûÈ«²¿·µ»Ø£¬ÐèÒªÏ൱³¤Ê±¼ä¡£


½¨±í±ØÐë°ÑËùÓй¤×÷È«²¿Íê³É£¬²Å»áÌáʾÄã´´½¨³É¹¦~

---

ÄãÊÔÒ»ÊÔÕâ¸öcreate table new_demo as select * from demo where 1=0;

---

Ò»Ö±Ö´Ðв»½áÊø
Ò²²»±¨´í
½á¹û¼¯Ö»Óв»µ½60WµÄÊý¾Ý

---

Ò»Ö±Ö´Ðв»½áÊø
Ò²²»±¨´í
½á¹û¼¯Ö»Óв»µ½60WµÄÊý¾Ý
ÊÇÓÐȨÏÞ½¨±íµÄ
{