ORACLEµÄÓû§ÃûºÍÃÜÂëÊÇʲô£¿ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒ¸Õ×°ÁËORACLE 11g£¬¿É´ò¿ªSQL PlusʱҪÇóÊäÈëÓû§ÃûºÍÃÜÂë¡£ËüÃÇÊÇʲô°¡£¿
×°µÄʱºò²»ÊǾÍÒªÄãÊäÈëÓû§ÃûºÍÃÜÂëµÄô£¿
ÔÚĬÈÏÇé¿öÏ£¬¼ÙÈçÄãµÇ¼OSµÄÓû§ÊÇDBA×éµÄ£¬¿ÉÒÔÕâÑù£º
sqlplus /nolog
sql>connect / as sysdba
ÕâÑù¾ÍÒÔSYSDBAȨÏÞÁ¬ÉÏÁË£¬È»ºó¿ÉÒÔ¸ÄÆäËüÈκÎÓû§µÄÃÜÂë
Oracle Óû§¼°½ÇÉ« ½éÉÜ
http://blog.csdn.net/tianlesoftware/archive/2009/11/09/4786956.aspx
ÏÂÃæÊÇOracleµÄÓû§ÃûºÍÃÜÂ룬¼°¶ÔÓû§µÄÃèÊö£º
Username
Password
Description
See Also
CTXSYS
CTXSYS
The Oracle Text account
Oracle Text Reference
DBSNMP
DBSNMP
The account used by the Management Agent component of Oracle Enterprise Manager to monitor and manage the database
Oracle Enterprise Manager Grid Control Installation and Basic Configuration
LBACSYS
LBACSYS
The Oracle Label Security administrator account
Oracle Label Security Administrator's Guide
MDDATA
MDDATA
The schema used by Oracle Spatial for storing Geocoder and router data
Oracle Spatial User's Guide and Reference
MDSYS
MDSYS
The Oracle Spatial and Oracle interMedia Locator administrator account
Oracle Spatial User's Guide and Reference<
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test
as
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......
oracleº¯ÊýÈçÏ£º
create or replace function P_WEB_GETCITYID
(
p_mobileNumber in VARCHAR2,
p_cityid out NUMBER
) Return NUMBER
IS
p_areacode varc ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......