ÔÚORACLEºÍsql serverÖмòµ¥±¸·ÝtableµÄ·½·¨
Èç¹ûtemp_t1²»´æÔÚ£¬
oracle:
create table temp_t1
as
select * from t1
sql server:
select * into temp_t1 from t1
Èç¹ûtemp_t1´æÔÚ£¬
oracle:
insert into table temp_t1
select * from t1
sql server:
insert into table temp_t1
select * from t1
Ïà¹ØÎĵµ£º
¹Ø¼ü×Ö: oracle
Oracle°²×°ÖеÄDHCPÎÊÌâ
1.Linux
ÐÞ¸ÄhostsÎļþ ½«ipµØÖ·ÓëlocalhostÉ趨¾Í¿ÉÒÔÁË£¬ÈçÏÂ
vi /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
192.168.193.129 www.myzhtc.com
192.168.193.129 localhost myzhtc.com
......
²éѯ£ºselectÓï¾ä£¬¶à±í²éѯ£¬group by ·Ö×飬having ¶Ô·Ö×éºóµÄÿһ¸ö×é½øÐйýÂË£¬order by ÅÅÐò¡£(selectÓï¾ä¶à±í²éѯÕâ¸ö×îÖØÒª)
DMLÓï¾ä£ºinsert into emp() values(),insert into emp (select * from emp2),
delete from emp where...
update emp set sal =.. where ..
rollback;»Ö¸´ ......
oracleÈÏÖ¤·½Ê½·ÖΪ²Ù×÷ϵͳÈÏÖ¤ºÍ¿ÚÁîÎļþÈÏÖ¤2ÖÖ·½Ê½£¬²Ù×÷ϵͳÈÏÖ¤ÓÐʱºòÒ²½Ð±¾µØÈÏÖ¤¡£
££²Ù×÷ϵͳÈÏÖ¤:¼´oracleÈÏΪ²Ù×÷ϵͳÓû§Êǿɿ¿µÄ£¬¼´¼ÈÈ»Äܵǽµ½²Ù×÷ϵͳÄÇôoracleÊý¾Ý¿âÄãÒ²Äܵǽ
££¿ÚÁîÎļþÈÏÖ¤£ºoracleÈÏÖ¤ÈÏΪ²Ù×÷ϵͳÓû§ÊDz»¿ÉÐÅÈεģ¬Èç¹ûÒª·ÃÎÊÊý¾Ý¿â£¬±ØÐë½øÐÐÔÙ´ÎÈÏÖ¤¡£
¾ßÌåʵÏÖÈçÏ£º
......
ÕâÀï½éÉÜsql server2005ÀïÃæµÄÒ»¸öʹÓÃʵÀý£º
CREATE TABLE tb(province nvarchar(10),city nvarchar(10),score int)
INSERT tb SELECT 'ÉÂÎ÷','Î÷°²',3
UNION ALL SELECT 'ÉÂÎ÷','°²¿µ',4
UNION ALL SELECT 'ÉÂÎ÷','ººÖÐ',2
UNION ALL SELECT '¹ã¶«','¹ãÖÝ',5
UNION ALL SELECT '¹ã¶«','Ö麣',2
UNION ......
1. SQLÓÅ»¯µÄÔÔòÊÇ£º
½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£
µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺
¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ
¼ì²é×Ó²éѯ ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½Óµ ......