The following describes how to use the Oracle sqlplus statement to edit commands. If you are interested in the Oracle sqlplus statement Editing Command, take a look.
First, enter the following command:
SELECT emp_id, emp_name
FROM Employees
The input command can be followed by a statement. For example, after the preceding statement is run, enter:
Input WHERE emp_age> 30
You can get the following command:
SELECT emp_id, emp_name
FROM Employees
WHERE emp_age> 30
The ln command is used to specify the nth line of the statement to be input. For example, after the preceding statement is run, enter:
L1 indicates that the currently selected statement line is
SELECT emp_id, emp_name
The statement is prefixed)
Command a is used to directly add characters at the end of the current line. For example, after the preceding statement is run, enter:
A, emp_dept
The executed command is:
SELECT emp_id, emp_name, emp_dept
FROM Employees
WHERE emp_age> 30
The c command is used to modify the characters in the current statement. For example, after the preceding statement is run, enter:
C/emp_name/emp_age:
SELECT emp_id, emp_age, emp_dept
FROM Employees
WHERE emp_age> 30
The del n command is used to delete the nth line of command. For example, after the preceding statement is run, enter:
DEL 3
The executed command is:
SELECT emp_id, emp_age, emp_dept
FROM Employees
Statement of Oracle cyclic statements
Three methods for Oracle Authentication
Oracle Default User Password Problems
Common Oracle cursor attributes
Use instances of Oracle stored procedures