Use sqlplusw or sqlplus

When using sqlplusw or sqlplus, the actual number of words without modification sqlplusw is usually a specified number of words in a row by default, resulting in a line of query results, which is inconvenient for us to read data. Two commands: 1. SET the record length displayed on each line: set linesize 300; (but the page is displayed, that is, duplicate table field names ). 2. SET the number of records displayed on each page: set pagesize 30; 2. Run the following command to view all data tables:

Select * from tab;

View the current Login User:

Show user;

After a user logs in, some tables cannot be seen.

Select * from A. B; (A is user A and B is table name)

Database switching users:

Conn scott/tiger

"Connected" is displayed"