oracle数据库

user
Schema
Oracle create user dbacreate user
CREATE USER test IDENTIFIED BY test
DERAULT TABKESPACE users_ts
TEMPORARY TABLESPACE temp_ts
QUOTA 3m ON users_ts;

test
test
users_ts
temp_ts
users_ts 3m
create session1,
connect system/manager
grant create session to test
connect test/test
testOracle2 create table
connect system/manager
grant creat table to test
connect test/test
create table ….
testOracle,3
alter user test() identified by test4
alter user test() account unlock 5
alter user test QUOTA 10m on users_ts;6
DROP USER username()
CASCADE,
drop user cascade;
7
grant to
grant create session,create table to test;
test
8
Revoke from
revoke create session,create table from test
test 9
select * from user_sys_privs whe免费云主机域名re grantee=’test’10
select * from session_privs;
1
grant on to connect b/b B
grant select ,insert on tx to A
B.TXA2
connect b/b B
revoke select ,insert on TX from A3 select * from user_tab_privs
USER_TAB_PRIVS
CREATE ROLE test_role
grant create session, create table to test_role;GRANT test_role() TO user_name()
DROP ROLE test_roleuser_role_privs

SELECT USERNAME, GRANTED_ROLE FROM USER_ROLE_PRIVS; SQLSQLDEPTdeptno,dname,loc
EMPempno, ename, job ,mgr, hiredate, sal, comm ,deptno
DEPTEMP1
desc emp;2
selcet * from dept;3
select deptno,dname from dept ;

select sal*12 from empdistinct

select distinct deptno ,job from empwhere select ename, hiredate from emp where to_char(hiredate,’yyyymmdd’)to_char(hiredate,’yyyymmdd’)
select enma ,sal from emp where sal between 0 and 1000;
between and select ename ,sal from emp where ename like ‘%s%’select ename, sal from emp where ename like ‘M%’;
%
%
_where (AND ,NOT, OR)
select ename ,sal from emp where comm is not null;select ename, sal from emp where comm>100 and sal >1000;ORDER BY ASCDESCORDER BY

select ename, sal from emp order by sal desc ;insert insert into emp

相关推荐: sqlserver2008日志收缩的示例分析

这篇文章主要介绍了sqlserver2008日志收缩的示例分析，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。 在sql server2000中收缩日志或数据文件，首先要更改数据库的运行模式为简单…