ÈçºÎ½«oracleÖеÄÊý¾Ýµ¼Èëµ½excleÖÐ
¹¤×÷¹ý³ÌÖÐÐèÒª½«oracleÖеÄÊý¾Ýµ¼Èëµ½excleÖУ¬×Ô¼º×öÁËһϣ¬ÏȽ«·½·¨½éÉÜÈçÏ£¬
Äã¿ÉÒÔ¸ù¾Ý×Ô¼ºµÄʵ¼ÊÇé¿ö£¬×ö³ö¸ü¸Ä¡£
1,½¨Á¢Ò»¸öemp.sqlÎļþÎÒµÄÊÇÔÚF :\SQL\EMP.SQL
set line 120
set pagesize 100
set feedback off
--¹Ø±ÕÀàËÆÓÚ“ÒÑÑ¡11ÐДÕâÑùµÄÊä³ö·´À¡£¬ÒÔ±£Ö¤spoolÊä³ö¶¨ÒåµÄ--ÎļþÖÐÖ»ÓÐÎÒÃÇÏëÒªµÄÊý¾Ý
spool f:\excels\emp
select * from emp;
spool off
2 ÒÔscottÓû§µÇ¼£¬
Ö´ÐÐ 1Öн¨Á¢µÄemp.sql
ÔÚ f:\excels\emp ÖÐÉú³Éemp.lstÎļþ
3 ÔÚexcle ´ò¿ª ²½Öè2ÖÐÉú³ÉµÄemp.lstÎļþ
4£¬Ò»Ö±µãÏÂÒ»²½¾ÍºÃÁË£¬Ö±µ½Íê³É¡£
5½á¹û£º
Ïà¹ØÎĵµ£º
1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊ ......
¾ßÌå²½Öè¾Í²»¶à˵ÁË £¬Òªµ¼³öµÄSQLSERVER±í½Ð LDJCUS£¬Ö÷¼ü Uid (int ×Ô¶¯Ôö³¤ÁÐ)£¬µ¼Èëµ½Oracle×ܱ¨´í£º¶ÔÏóÃûÎÞЧ £¬È¥µôÖ÷¼üÁоͿÉÒÔ£¬²»ÖªµÀΪʲô£¿ÄѵÀ×Ô¶¯Ôö³¤µÄÖ÷¼üÁоͲ»Äܵ¼Èëµ½OracleÖУ¿£¿£¿Òɻ󡣡£¡£¡£ ......
½Å±¾1£º
SELECT NAME
,value
,description
from ( --GV$SYSTEM_PARAMETER
SELECT x.inst_id as instance
,x.indx+1
,ksppinm as NAME
,ksppity
,ksppstvl as value
,ksppstdf as isdefault& ......
distinctÕâ¸ö¹Ø¼ü×ÖÀ´¹ýÂ˵ô¶àÓàµÄÖظ´¼Ç¼ֻ±£ÁôÒ»Ìõ£¬µ«ÍùÍùÖ»Óà ËüÀ´·µ»Ø²»Öظ´¼Ç¼µÄÌõÊý£¬¶ø²»ÊÇÓÃËüÀ´·µ»Ø²»ÖؼǼµÄËùÓÐÖµ¡£ÆäÔÒòÊÇdistinctÖ»ÓÐÓöþÖØÑ»·²éѯÀ´½â¾ö£¬¶øÕâÑù¶ÔÓÚÒ»¸öÊý¾ÝÁ¿·Ç³£´óµÄÕ¾À´Ëµ£¬ÎÞÒÉÊÇ»áÖ±½ÓÓ°Ï쵽ЧÂʵġ£
ÏÂÃæÏÈÀ´¿´¿´Àý×Ó£º
table±í
×Ö¶Î1 ×Ö¶Î2
&nbs ......