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

ÔÚ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°²×°ÖеÄDHCPÎÊÌâ

 ¹Ø¼ü×Ö: 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
......

oracle×ܽá

²éѯ£º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ÖУ¬Óû§×÷ΪSYSDBA¿ÉÒÔÒÔÈκÎÃÜÂëµÇ¼

oracleÈÏÖ¤·½Ê½·ÖΪ²Ù×÷ϵͳÈÏÖ¤ºÍ¿ÚÁîÎļþÈÏÖ¤2ÖÖ·½Ê½£¬²Ù×÷ϵͳÈÏÖ¤ÓÐʱºòÒ²½Ð±¾µØÈÏÖ¤¡£
£­£­²Ù×÷ϵͳÈÏÖ¤:¼´oracleÈÏΪ²Ù×÷ϵͳÓû§Êǿɿ¿µÄ£¬¼´¼ÈÈ»Äܵǽµ½²Ù×÷ϵͳÄÇôoracleÊý¾Ý¿âÄãÒ²Äܵǽ
£­£­¿ÚÁîÎļþÈÏÖ¤£ºoracleÈÏÖ¤ÈÏΪ²Ù×÷ϵͳÓû§ÊDz»¿ÉÐÅÈεģ¬Èç¹ûÒª·ÃÎÊÊý¾Ý¿â£¬±ØÐë½øÐÐÔÙ´ÎÈÏÖ¤¡£
¾ßÌåʵÏÖÈçÏ£º
......

sqlС¼Æ»ã×Ü rollupÓ÷¨ÊµÀý·ÖÎö

 ÕâÀï½éÉÜ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 ......

SQLÓï¾äЧÂÊÎÊÌâµÄ¼¸µã×ܽá

1. SQLÓÅ»¯µÄÔ­ÔòÊÇ£º
  ½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£  
  µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺  
  ¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ  
  ¼ì²é×Ó²éѯ   ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½Óµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ