Oracle常用命令及sql语句

1

startup

1

shutdown immediate

1

lsnrctl start

1

sqlplus / as sysdba

1

select * from tab;

1

select name from v$datafile;

1

show parameter service;

1

select instance_name from v$instance;

1

select name from v$database;

1

select * from dba_users;

1

select username,password from dba_users;

1

select * from v$pwfile_users;

1

select * from dba_ustats;

1

select * from user_sys_privs;

1

select * from user_role_privs;

1

select * from dba_sys_privs;

1

select * from v$version;

1

select * from user_views;

1

create directory directory_name as '/etc/test';

1

select * from all_directories;

1

select userenv('language') from dual;

1

select name,log_mode from v$database;

1

 select name from v$datafile;

1
2
3

 create user test identified by bnsbdl;

 grant connect, dba to test;