www.eimhe.com/bbs/search.php
oracle比较好的:吉林大学远程教育学院计算机分院;oracle9i ocp教程
ORACLE的用户: SYS(系统的最高权限) SYSTEM
如果有实例则有HR用户
SQL登陆方式:SQL>conn sys/admin@test as sysdba
启动:startup pfile=[P文件]
关闭:shutdown immediate|force|normal|tanscational
启动和关闭时,必须用SYS AS SYSDBA才能执行
创建用户:
CREATE USER USERNAME IDENTIFIED BY ABCD
GRANT CONNECT,RESOURCER TO USERNAME
删除用户 drop user username
锁定用户 alter user username account unlock
解锁用户 alter user username account unlock
显示用户的所有表:select table_name from user_tables
显示表结构desc user_tables
缩小行距 col
开发人员最常用的授权命令grant connect,resource to username
delete要记日志
trancate 不要记日志,速度较快
序列:ORACLE的特色
create sequence sq_account increment by 1 start with 100
create table mytb(id int not null primary key,name char(22))
insert into mytb values(sq_account.nextval,'hello')
select sq_account.currentval,sq_account.nextval from dual
ejb3交流群:3700164
e_mail :javatech001@163.com
bbs:www.eimhe.com