¹ØÓÚoracleµÄһЩÔÓÆßÔӰ˵IJÙ×÷
1¡¢¸ü¸Ä±íÃû/ÁÐÃû
Ê×ÏÈ£¬ÒªÒÔsysdbaÉí·ÝµÇ¼£¬²ÅÄܶԱíÃû/ÁÐÃû½øÐиü¸Ä£º
(1)µÇ½sqlplus£¬¿ÉÒÔÒÔnolog·½Ê½µÇ½£¬¹ØÓÚÕâÖֵǽ·½·¨£¬¿ÉÔÚsqlplusµÄͼ±êÉÏÓÒ¼ü£¬µã»÷ÊôÐÔ£¬ÔÚ"Ä¿±ê"À¸¸ÄΪ£º"D:\oracle\product\10.2.0\client_1\BIN\sqlplusw.exe /nolog"£¬È»ºóÔÙË«»÷sqlplusͼ±ê¾Í¿É½øÈë¡£
ÓÐʱoracle²¢²»ÔÚ±¾µØµçÄÔÉÏ£¬µ±ÎҵĵçÄÔÉÏÖ»×°ÁËoracle clientʱ£¬¾ÍÐèÒªÔ¶³ÌÁ¬½ÓoracleÁË£¬Á¬½Ó·½Ê½Îª£º
Óû§Ãû/ÃÜÂë@Ô¶³ÌÁ¬½Ó
SQL>connect sys/bsrs@bsrs_server309 as sysdb£»
(2)·ÃÎÊÖ¸¶¨±í¿Õ¼äµÄ±í£¬ÐÎʽΪ£º
Óû§Ãû.±íÃû
SQL>select * from cyy.stu;
(3)¸Ä±íÃû/ÁÐÃû
SQL>alter table cyy.stu rename to student;
SQL>alter table cyy.student rename column Name to StudengName;
Ïà¹ØÎĵµ£º
ÔÀ´ÓõÄSQL server£¬Ö÷ÒªÓÐÁ½ÖÖ·ÖÒ³·½·¨£ºÓαêºÍÆ´×Ö·û´®£¬Óα귨̫Âý£¬Æ´´®·¨Ò²ÓÐһЩȱÏÝ¡£
ÏÖÔÚÕÒµ½ÁËÒ»¸öOracleµÄ·ÖÒ³·½·¨£¬Ò²¿ÉÒÔ˵ÊÇÆ´×Ö·û´®£¬µ«ÊÇÓÃÆðÀ´¾Í±ÈSQL serverµÄÒª·½±ã£¬Ã»ÓÐ֮ǰµÄÎÊÌ⣺
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
W ......
ÓÐʱºòÎÒÃÇ¿ÉÄܲ»ÖªµÀÒ»¸öÓû§µÄÃÜÂ룬µ«ÊÇÓÖÐèÒªÒÔÕâ¸öÓû§×öһЩ²Ù×÷£¬ÓÖ²»ÄÜÈ¥Ð޸ĵôÕâ¸öÓû§µÄÃÜÂ룬Õâ¸öʱºò£¬¾Í¿ÉÒÔÀûÓÃһЩСÇÏÃÅ£¬À´Íê³É²Ù×÷¡£
¾ßÌå²Ù×÷¹ý³ÌÈçÏ£º
SQL*Plus: Release 9.2.0.5.0 - Production on ÐÇÆÚÈÕ 11ÔÂ 21 13:32:34 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reser ......
Ç°ÑÔ£º
OracleµÄ¶Ô±í²Ù×÷ÖÐÓÐÒ»ÖÖÀàËÆÓÚDataSetµÄ¶ÔÏó²Ù×÷·½·¨CURSOR£¬Ëü¿ÉÒÔͨ¹ý½¨Á¢±íµÄ²Ù×÷¶ÔÏó»òÕß˵±íµÄÖ¸Õë¶ÔÏóÀ´´ïµ½´Ó±íÀïÃæÌáÈ¡Êý¾ÝµÄ²Ù×÷¡£
˵Ã÷£º
Ò»°ãͨ¹ýSQLÓïÑÔ¿ÉÒÔÕë¶Ôij¸ö±íµÄijһÐлò¶àÐÐÊý¾Ý½øÐвÙ×÷±ÈÈç˵SELECT£¬UPDATEµÈ¡£ÕâЩ²Ù×÷±ØÐëÒÔSQLÓï¾äµÄÓï·¨¸ñʽÀ´±»½âÊÍÆ÷½âÊͲ¢Ö´ÐС£ÔÚʵ¼ ......
ÔÎĵØÖ·£ºhttp://www.cnblogs.com/chinhr/archive/2009/04/22/1440914.html
·½·¨Ò»£º
ÔÚÄ¿Ç°¾ø´ó²¿·ÖÊý¾Ý¿âÓзֲ¼Ê½²éѯµÄÐèÒª¡£ÏÂÃæ¼òµ¥µÄ½éÉÜÈçºÎÔÚoracleÖÐÅäÖÃʵÏÖ¿ç¿â·ÃÎÊ¡£
±ÈÈçÏÖÔÚÓÐ2¸öÊý¾Ý¿â·þÎñÆ÷£¬°²×°ÁË2¸öÊý¾Ý¿â¡£Êý¾Ý¿âserver AºÍB¡£ÏÖÔÚÀ´ÊµÏÖÔÚA¿âÖзÃÎÊBµÄÊý¾Ý¿â¡£
µÚÒ»²½¡¢ÅäÖÃA·þÎñÆ÷¶ËµÄtnsnam ......