Oracle Command line Exercises

1. On the premise that the environment variable is well configured, strike the command #>sqlplus
2. Enter username/password Login Oracle #> default we use first, user name: Scott, password: Tiger login
3.
A. When you log in, you can only tap Sqlplus, enter your username/password at the prompt, or you can:
#> Sqlplus/nolog
#> Conn Scott/tiger
B. If the Scott user is locked, it needs to be unlocked:

#> alter user Scott account unlock;
C. Want to see the current Scott users below a few tables, using the following SQL, in the black frequency to write SQL, need to add ";" Semicolon, otherwise the SQL is not closed: (username uppercase)
#> Select table_name from all_tables where owner = "SCOTT";
D. Want to view all tables for the current database:
#> select * from tab;
E. Exit the black screen:
#> exit

This article is from the "11044693" blog, please be sure to keep this source http://11054693.blog.51cto.com/11044693/1744821

Oracle Command line Exercises