Filter
Top Products
SQL>select * from persnl.employee;
....
Pressing Enter executes the corrected SELECT statement.
• Correct an SQL statement that you entered incorrectly by using more than one editing
command:
SQL>selt * fromm persnl.employee;
*** ERROR[15001] A syntax error occurred at or before:
selt * fromm persnl.employee;
^
*** ERROR[8822] The statement was not prepared.
SQL>fc
SQL>selt * fromm persnl.employee;
.... iec// d
SQL>select * from persnl.employee;
....
Pressing Enter executes the corrected SELECT statement.
• Modify a previously executed statement by replacing a value in the WHERE clause with
another value:
SQL>select first_name, last_name
+>from persnl.employee
+>where jobcode=111;
--- 0 row(s) selected.
SQL>fc
SQL>select first_name, last_name
....
SQL>from persnl.employee
....
SQL>where jobcode=111;
450
....
SQL>where jobcode=450;
....
Pressing Enter lists the first and last names of all of the employees whose job code is 450.
• Modify a previously executed statement by replacing a column name in the select list with
another column name:
SQL>select first_name, last_name
+>from persnl.employee
+>where jobcode=450;
FIRST_NAME LAST_NAME
--------------- --------------------
MANFRED CONRAD
WALTER LANCASTER
JOHN JONES
KARL HELMSTED
THOMAS SPINNER
--- 5 row(s) selected.
SQL>fc
SQL>select first_name, last_name
.... R empnum,
SQL>select empnum, last_name
....
SQL>from persnl.employee
....
FC Command 89