Command window: table column name/data pair marking does not work when preceeded by SQL*Plus command

[Claus Pedersen]

I have a command window with the following code:

prompt Importing table EMP...
set feedback off
set define off

insert into EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)
values (7369, 'SMITH', 'CLERK', 7902, to_date('17-12-1980', 'dd-mm-yyyy'), 800.00, null, 10);

prompt Done.

The marking of pairs of column name and data does not work.
If I add another 'insert' statement after the first, it will work for the second statement, probably because of the semicolon after the first statement.

Note: the code was generated by PLD (SQL window -> right-click in grid -> export results -> SQL file)

 

[Marco Kalter]

The PL/SQL Parser does indeed not know of the SET and PROMPT commands, so it may miss such an insert statement. We'll try to enhance this.

 

[Sailora]

Why I don't know there is this function?

How do you operate "marking of pairs of column name and data"?

 

[Claus Pedersen]

If you have an sql statement like:
"insert into EMP (EMPNO, ENAME, JOB) values (7369, 'SMITH', 'CLERK');"

then when the cursor is on 7369, the column EMPNO will be marked etc.

It is always acive (since version 10?)