SQL statements for Oracle

Login without password: sqlplus/as sysdba

View all current databases: select name from V$database;

View current database connection User: Show user

View all tables for the current user: Select table_name from All_tables;

View table structure: DESC table name

New Database User: Create user username indentified by ' password '

Authorization: Grant permissions/role to user name

Change database user password: Alter user username identified by ' new password '

View all users within the database: SELECT * FROM Dba_users

View all users that can be managed: SELECT * from All_users

View Current User information: SELECT * FROM User_users

Export table structure and data: Exp username/password @ network connector file=d:\daochu.dmp full=y

Import table structure and data: IMP username/password @ network connector file=d:\daochu.dmp

This article is from "Little bin 30" blog, please be sure to keep this source http://xiaobin30.blog.51cto.com/9438146/1791966

SQL statements for Oracle