Shulou(Shulou.com)06/01 Report--

1. When the environment variables are configured, click the command # > sqlplus

two。 Enter user name / password to log in oracle # > by default, we will use it first. User name: scott, password: tiger login

3.

a. When logging in, you can just click sqlplus and enter your user name / password as prompted, 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. To view several tables below scott users, use the following sql. After writing sql in black frequency, you need to add ";" semicolon, otherwise you will think that sql is not finished: (user name capitalized)

# > select table_name from all_tables where owner = 'SCOTT'

d. To view all the tables in the current database:

# > select * from tab

e. Exit the black screen:

# > exit

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.