Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Oracle ÈçºÎʹÓÃ×Ô´øµÄscottÓû§£¿

ÈçÌ⣬ÎÒÒѾ­°²×°ºÃÁËOracle,ÒòΪÊÇ×Ôѧ£¬²»¶®oracleºÜ¶à¶«Î÷£¬ÇëÎÊÈçºÎʹÓÃËü×Ô´øµÄscottÓû§£¿ÒòΪÎÒÒªÀûÓÃËü×Ô´øµÄ±í×öһЩÁ·Ï°¡£µ«ÊÇÎÒ×öÕâÑùµÄÁ´½ÓºóËüΪʲô˵²»ÔÙÁ¬½Óµ½Oracle?Õâ¸ö¶ÔSCOTTÓû§ÓÐÓ°Ïìô£¿
ÎÒÓ¦¸ÃÔõÑùÕýÈ·µÇ½µ½scottÓû§£¿

SQL> conn scott/tiger;
ERROR:
ORA-01017: invalid username/password; logon denied


¾¯¸æ: Äú²»ÔÙÁ¬½Óµ½ ORACLE¡£
SQL> alter user scott account unlock Enter;
SP2-0640: δÁ¬½Ó
SQL> conn System/password;
ÒÑÁ¬½Ó¡£
SQL> alter user scott account unlock Enter;
alter user scott account unlock Enter
                                *
µÚ 1 ÐгöÏÖ´íÎó:
ORA-00922: Ñ¡Ïîȱʧ»òÎÞЧ


SQL>
»¹ÓÐÎÊһϣ¬ÎÒÖªµÀ·²³õѧoracleµÄʱºò£¬¶¼ÓÐ×öÁ·Ï°ÀûÓÃscottÓû§×Ô´øµÄ±íemp,ÇëÎÊ£¬Èç¹ûÎÒÔÚÁíÍâÒ»¸öн¨µÄÓû§wepullÖÐÌí¼ÓempÕâÕűíµÄ»°£¬ÎÒÒѾ­Ð´ºÃ×Ö¶ÎÖ®ÀàµÄ£¬½ÓÏÂÀ´¾ÍÊÇÍù×Ö¶ÎÀïÌí¼ÓÊý¾ÝÁË£¬±È·½ËµÎÒÈçºÎÒ»´ÎÐÔÌí¼ÓºÃ£º
ename:ÕÅÈý£¬age:18Ë꣬dept:XX, deptno:10;Ö®ÀàµÄ£¬Èç¹ûÒ»¸ö×Ö¶ÎÒ»¸ö×ֶεÄÌí¼ÓÕâЩ£¬´úÂëÒªÔõÑùд£¿ÐèҪעÒâʲôÂð£¿
create table
insert
commit
update
...
Â¥Ö÷»ù±¾µÃÏÈ¿´¿´¡£


ÄãҪʹÓÃscottÓû§ÐèÒª¶ÔscottÓû§½âËø£¬ÒòΪOracleĬÈÏÇé¿öÏÂÊǶÔscottÓû§¼ÓÁËËøµÄ¡£
ʹÓÃÃüÁÀïÃæµÄtigerÊÇscottÓû§µÄĬÈÏÃÜÂ룩£º
alter user scott identified by tiger account unlock;

Äãµ


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

pl/sql - Oracle / ¿ª·¢

СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿

3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ