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

ʹÓÃPL/SQL Developer¹¤¾ßµ¼ÈëexcelºÍµ¼³öexcel

µ¼³ö:
1.Ö´ÐÐ
select Óï¾ä²éѯ³öÐèÒªµ¼³öµÄÊý¾Ý.
2.ÔÚÊý¾ÝÁбíÖÐÓÒ¼ü,Ñ¡Ôñsave
results.±£´æÎª.csvÎļþ,È»ºóÒÑexcel·½Ê½´ò¿ª¾ÍOKÁË.¿ÉÒÔÁí´æÎªxsl¡£ÐèҪעÒâµÄÊÇÈç¹ûÁÐÄÚÈÝÊÇ´¿Êý×Ö
µÄ»°£¬µ¼³öʱ»á×Ô¶¯°ÑÇ°ÃæµÄ0È¥µô£¬ÏëÒªµ¼³öÍêÕûµÄÁÐÄÚÈÝ£¬×îºÃÕâÁеÄÄÚÈÝÆ´Ò»¸ö×Ö·ûÈ磺select  ‘#’||Column from table¡£
µ¼Èë:
ÔÚµ¥¸öÎļþ²»
´óµÄÇé¿öÏÂ(ÉÙÓÚ100000ÐÐ)£¬²¢ÇÒÄ¿µÄ±í½á¹¹ÒѾ­´æÔÚµÄÇé¿öÏ¡£
²Ù×÷²½ÖèÈç
ÏÂ:
1 ¿ÉÒÔȫѡexcelÊý¾Ý¸´ÖÆ£¬
2 ÔÚPL/SQL DeveloperµÄsql windowÀïÊäÈëselect * from
tablename for update;
3 °´F8Ö´ÐÐ;
4 ´ò¿ªËø, ÔÙ°´Ò»Ï¼ӺÅ.
Êó±êµãµ½µÚÒ»ÁеÄÁÐÍ·£¬Ê¹È«ÁгÉÑ¡ÖÐ״̬£¬È»ºóÕ³Ìù[ÕâÑù¿ÉÄܻᶪʧµÚÒ»ÁÐÊý¾Ý£¬¿ÉÒÔÔÚexcelµÚÒ»ÁÐǰÔö¼ÓÒ»¸ö¿ÕÁÐÀ´½â¾ö]£¬×îºócommitÌá½»¼´
¿É¡£


Ïà¹ØÎĵµ£º

¶ÀÁ¢µÄSQL ½Å±¾¹¤¾ß:QweryBuilder

ÍøÕ¾£ºhttp://werysoft.com/
Èç¹ûÄú±ØÐë¹ÜÀí»·¾³ÖеĶàÖÖÀàÐ͵ÄÊý¾Ý¿â·þÎñÆ÷£¬ÔòʹÓü¯ÖÐʽ¹¤¾ßµ÷ÕûËùÓÐÊý¾Ý¿â¿ÉÄÜ»á±È½Ï·½±ã¡£Werysoft µÄ QweryBuilder Ö¼ÔÚΪÄúÌṩ´ËÏÄÜ¡£Äú¿ÉÒÔʹÓÃËü´Óͬһ GUI Á¬½Óµ½ Microsoft SQL Server¡¢Sybase ASE¡¢SQL Anywhere ºÍ Oracle ʵÀý£¬È»ºó²é¿´¡¢´´½¨¡¢¸üкÍɾ³ýÊý¾Ý¿â½Å±¾¡¢¼Ü ......

Ò»¸öÌâÄ¿Éæ¼°µ½µÄ50¸öSqlÓï¾ä

Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
  select a.S# from (select s#,score from SC where C#='001') a,(select s#,score
  fr ......

SQLÐÐתÁÐ ÁÐתÐÐ


--ÐÐÁл¥×ª
/****************************************************************************************************************************************************** 
ÒÔѧÉú³É¼¨ÎªÀý×Ó£¬±È½ÏÐÎÏóÒ×¶® ÕûÀíÈË£ºÖйú·ç
(Roy) 
ÈÕÆÚ
:2008.06.06 *************************************** ......

SQLÈ¡ÈÕÆÚ

SQLÈ¡ÈÕÆÚ
SQL Server 2009-11-19 15:07:30 ÔĶÁ7 ÆÀÂÛ0 ×ֺţº´óÖÐС
·½·¨Ò»:
select CONVERT(varchar, getdate(), 120 )
2004-09-12 11:06:08
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),\'-\',\'\'),\' \',\'\'),\':\',\'\')
20040912110608
select CONVERT(varchar(12) , getdate( ......

»ñµÃÊý¾Ý¿âÃû³Æ///////²éѯÊý¾Ý¿âÀïËùÓбíµÄsqlÓï¾ä£¡

select   name   as   ¿âÃû   from   master..sysdatabases   where   dbid>=7 »ñµÃÊý¾Ý¿âÃû³Æ
select * from sysobjects where xtype='u' or xtype='v' ²éѯÊý¾Ý¿âÀïËùÓбíµÄsqlÓï¾ä£¡
select name from sysobjects where type='u' ²éѯһ¸ö¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ