OracleÊý¾Ý¿â½â³ýscottÓû§Ëø
1¡¢µÇ¼·½·¨:£ºsys or systemµÇ¼
Õ˺ţºsystem
ÃÜÂ룺system as sysdba---------¡·ÃÜÂë+as sysdba
conn system/password as sysdba
ʹÓÃÃüÁ
sql>alter user scott account unlock;
sql> commit;
Í˳öºóÓÃscott µÇ¼sqlplusʹÓÃÃÜÂëtiger£¬µÇ¼ºó»áÈÃÄãÌîдеÄÃÜÂë¡£
Ïà¹ØÎĵµ£º
--´´½¨ÐòÁÐ
create sequence innerid
minvalue 1
maxvalue 999999999
start with 1
increment by 1
cache 20
order;
--´´½¨±í
create table users(
userid int primary key,
username varchar2(20),
userpwd varchar2(20)
);
select * from users;
insert into users values( ......
¡¡ SQLÖеĵ¥¼Ç¼º¯Êý
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO   ......
Oracleɵ¹ÏÊÖ²á
¡¡¡¡
¡¡¡¡Oracle8ÒÔ8.1.5Ϊ½ç·ÖΪÆÕͨ°æ±¾ºÍinternet°æ±¾¡£ÆÕͨ°æ°æ±¾ºÅ8.0.x£¬½Ó´¥½Ï¶àµÄÊÇ8.0.5£»internet°æ°æ±¾ºÅ°üÀ¨8.1.5£¨Release 1£©£¬8.1.6£¨Release 2£©£¬8.1.7£¨Release 3£©¡£ÆÕͨ°æ¼ò³ÆOracle 8£¬internet°æ¼ò³ÆOracle 8i¡£¼ÙÈç²»×÷·Ç·²ËµÃ÷£¬ÎÄÖз²³öÏÖOracle 8i¾ùÖ¸8.1.7°æ¡£
¡¡¡¡Oracle9 ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
DOSÖп ......