The programmers of oracle database normally used the sqlplus to write and execute commands like;
SQL > select * from tab;
To display fileno, name, we have to write the command;
SQL > select file_no,name from emp;
If we have to add another column, we have to write the whole command again;
SQL > select file_no,name,sal from emp;
In sql plus, it is not possible to change/edit the previous commands easily. We have to write the whole command completely or we use the note pad to edit the commands.
on Wed, 2012-05-30 23:11