Console access to Oracle commands

Console access to Oracle:
Windows platform Keyboard window+r input cmd Enter sqlplus enter prompt you enter username and password and then enter

Desc: View Table structure
Desc + table Name

set Line[size]{80|n}:size value defaults to 80 if the screen is large enough to set any value
Set Line 100

l and N text: L display the previous SQL N text to modify the previous SQL error (table person has name,age,sex,height these columns)
For example, the previous SQL is:
Select Name,age,sex
from xxx
where age>20
The order by height can see that the From XXX is incorrectly written
You can modify this SQL by entering L to view this SQL and then entering 2 from the person
　　
　　

Run
Combination L and N text use modified after input/can run modified statements

Console access to Oracle commands