Tuesday, April 19, 2011

Oracle SQLPlus



  1. Connect to sqlplus: sqlplus => system => password1 OR sqlplus system/password1@sonlmdb


  2. Show current user: show user;


  3. Show current database: select * from global_name;


  4. OR select instance_name from v$instance;


  5. Create user: create user identified by ;


  6. Grant permission for user: grant connect,resource to ;

No comments:

Post a Comment