oracleµ¼³öÎÊÌâ - Oracle / ¿ª·¢
¿Í»§¶ËÊÇoracle9i,Ô¶³Ì·þÎñÆ÷¶ËÊÇoracle11g
ʹÓÃtoad µ¼³öÔ¶³Ì·þÎñÆ÷ÉϵÄÊý¾Ýʱ ±¨´íORA-01017: invalid username/password; logon denied
µ¼³öµÄÈÕÖ¾:
EXP-00056: Óöµ½ ORACLE ´íÎó 1017
ORA-01017: invalid username/password; logon denied
EXP-00030: ¶ÁÈ¡ÊäÈëֵʱ³öÏÖÒâÍâµÄ EOF
EXP-00000: µ¼³öÖÕֹʧ°Ü
ÓÃÕâ¸öÓû§ÃûºÍÃÜÂëÁ¬½ÓÕý³£Âð£¿
ÎÒ¿ÉÒÔÁ¬½ÓÉÏ ¶øÇÒÔÚtoadºÍplÀïÃæ¿ÉÒÔ½øÐÐÔöɾ¸Ä²éµÄ²Ù×÷ µ¹ÊÇÎÞ·¨µ¼³öÊý¾Ý
Ïà¹ØÎÊ´ð£º
Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£»
......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
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='µÚÒ»°Ù¸öÐÕÃû'
......