Oracle Åú´¦ÀíÆô¶¯¹Ø±Õ·þÎñ
OracleÔÚ×Ô¼º»úÆ÷ÉÏ×°Ò»¸öÓбØÒªµÄ£¬±Ï¾¹ÓÐʱºòÐèÒª×Ô¼ºÔÚ¼ÒѧϰһÏ£¬µ«µçÄÔ²»ÊÇ×Ô¼ºÓõģ¬»¹ÊÇд¸öÅú´¦Àí½â¾öһϣ¬ÐèÒªµÄʱºòµã»÷Ò»ÏÂÆô¶¯£¬²»ÐèÒª¾ÍÍ£Ö¹£¬ºÜ·½±ã¡£ÕâÀォ½Å±¾¸ø´ó¼Òдһ¸ö£¬»¶Ó´ó¼ÒÕ³Ìù¿½±´¡£
Ê×ÏÈ£¬×Ô¼ºÏȽ«×Ô¼ºµÄ×Ô¶¯Æô¶¯·þÎñ¹Ø±Õ£¬²¢¼Ç¼һÏ£¬È»ºóÌæ»»½Å±¾ÖÐÏàÓ¦µÄ·þÎñÃû³Æ¼´¿É¡£×Ô¼ºÕ³Ìù³öÈ¥±£´æΪ“Oracle·þÎñÇл».bat”¼´¿É
echo off
cls
color 2e
echo. ©¦©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤ ©¦
echo. ©¦ ©¦
echo. ©¦ Ðì×Ó焜ÖÆ×÷ ©¦
echo. ©¦ blog.csdn.net/xzknet ©¦
echo. ©¦ ©¦
echo. ©¦ Ò»¼üÇл»OracleÆô¶¯·þÎñ ©¦
echo. ©¦ OracleServiceKENDB ΪÎÒµÄOracle·þÎñÃû£ºKENDB ©¦
echo. ©¦ ×¢Òâ¸ü»»ÄúµÄ·þÎñ ©¦
echo. ©¦ £¨±¾½Å±¾Çë·ÅÐÄʹÓã© ©¦
echo. ©¦ ©¦
echo. ©¦ 1.Æô¶¯ 2.Í£Ö¹ ©¦
echo. ©¦ ©¦
echo. ©¦©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¤©¦
:F
set zcyh=
set /p zcyh=È·¶¨ÒªÆô¶¯Oracle(1,2)
if /i "%zcyh%"=="1" goto START_ORACLE
if /i "%zcyh%"=="2" goto STOP_ORACLE
:START_ORACLE
echo È·¶¨ÒªÆô¶¯OracleÂð£¿
pause
net start OracleOraHome81Agent
net start OracleOraHome81DataGatherer
net start OracleOraHome81TNSListener
net start OracleServiceKENDB
ECHO ORACLE Æô¶¯³É¹¦¡£
goto PATCH_END
:STOP_ORACLE
echo È·¶¨ÒªÍ£Ö¹OracleÂð£¿
pause
net stop OracleOraHome81Agent
net stop OracleOraHome81DataGatherer
net stop OracleOraHome81TNSListener
net stop OracleServiceKENDB
ECHO ORACLE ÒѾֹͣ
goto PATCH_END
:PATCH_END
ECHO ¾´ÇëʹÓã¡×÷Õß Ðì×Ó焜 2009-11-14 °´È·¶¨ºóÍ˳ö
pause
exit
Ïà¹ØÎĵµ£º
INºÍEXISTSÇø±ð
in ÊÇ°ÑÍâ±íºÍÄÚ±í×÷hash join£¬¶øexistsÊǶÔÍâ±í×÷loop£¬Ã¿´ÎloopÔÙ¶ÔÄÚ±í½øÐвéѯ¡£
Ò»Ö±ÒÔÀ´ÈÏΪexists±ÈinЧÂʸߵÄ˵·¨ÊDz»×¼È·µÄ¡£
Èç¹û²éѯµÄÁ½¸ö±í´óСÏ൱£¬ÄÇôÓÃinºÍexists²î±ð²»´ó¡£
Èç¹ûÁ½¸ö±íÖÐÒ»¸ö½ÏС£¬Ò»¸öÊÇ´ó±í£¬Ôò×Ó²éѯ±í´óµÄÓÃexists£¬×Ó²éѯ±íСµÄÓÃin£º
ÀýÈ磺±íA£¨Ð¡±í£©£¬±íB ......
fmobileÊäÈë²ÎÊý£¬msgÊä³ö²ÎÊý
--·½·¨1
variable msg varchar2(100)
variable fmobile varchar2(100):='13424242890'
exec smsrun.PKG_SETNEIZHI.p_Whynomt(fmobile,msg)
print msg
--·½·¨2
set serveroutput on;
declare
FMOBILE varchar2(100):='13424242890';
msg varchar2(100):= ......
×÷Õߣº ÈÕÆÚ£º2005-12-8 1:43:32 À´Ô´£ºInternet µã»÷£º´Î ÆÀÂÛ
¡¡¡¡±¾ÎÄÖ»ÌÖÂÛOracleÖÐ×î³£¼ûµÄË÷Òý£¬¼´ÊÇB-treeË÷Òý¡£±¾ÎÄÖÐÉæ¼°µÄÊý¾Ý¿â°æ±¾ÊÇOracle8i¡£
¡¡¡¡Ò». ²é¿´ÏµÍ³±íÖеÄÓû§Ë÷Òý
¡¡¡¡ÔÚOracleÖУ¬SYSTEM±íÊÇ°²×°Êý¾Ý¿âʱ×Ô¶¯½¨Á¢µÄ£¬Ëü°üº¬Êý¾Ý¿âµÄÈ«²¿Êý¾ ......
Ŀ¼
======================================================
1.ʹÓÃrownumΪ¼Ç¼ÅÅÃû
2.ʹÓ÷ÖÎöº¯ÊýÀ´Îª¼Ç¼ÅÅÃû
3.ʹÓ÷ÖÎöº¯ÊýΪ¼Ç¼½øÐзÖ×éÅÅÃû
Ò»¡¢Ê¹ÓÃrownumΪ¼Ç¼ÅÅÃû£º
¡¾1¡¿²âÊÔ»·¾³£º
SQL> desc user_order;
Name   ......
OracleµÄÍâ¼üÓÃÀ´ÏÞÖÆ×Ó±íÖвο¼µÄ×ֶεÄÖµ£¬±ØÐëÔÚÖ÷±íÖдæÔÚ¡£¶øÇÒÔÚÖ÷±íµÄ¼Ç¼·¢Éú±ä»¯µ¼ÖÂÍâ¼ü²Î¿¼Î¨Ò»Ô¼ÊøÖµ·¢ÉúÁ˱仯ʱ£¬¶¨ÒåÁËһϵÁеĶ¯×÷¡£
ÔÚSQL92±ê×¼Öж¨ÒåÁ˼¸ÖÖÍâ¼ü¸Ä±äºó£¬ÈçºÎ´¦Àí×Ó±í¼Ç¼µÄ¶¯×÷£¬ÆäÖаüÀ¨£º
ÏÞÖÆRestrict£ºÕâÖÖ·½Ê½²»ÔÊÐí¶Ô±»²Î¿¼µÄ¼Ç¼µÄ¼üÖµÖ´Ðиüлòɾ³ýµÄ²Ù×÷£»
ÖÃΪ¿ÕSet to nu ......