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£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......