-
sql plus QUESTION
I AM USING sql*plus and have come across a dilemma
At the SQL PROPMT after typing a query without a semi-colon at the end, I press "RETURN". The next line is waiting for the next command {i.e. ';' or '/' } to complete the query.
When I press "RETURN", the SQL PROMPT takes me to a new line because I did not finish the query. Is there some way to set the SQL PLUS environment to not go to a new PROMPT, and even after I press "RETURN", to continue with the query.
For exp:
SQL > select sysdate from dual
2
SQL >
-
The query is not "lost", if you enter RETURN twice, it will go to new line.
To continue last query just enter "i". :rolleyes:
Or to edit query enter "ed". ;)
-
Thanx for the reply
Here is the problem. A script is set to run these queries.
SQL> grant select on xxx to xxx;
SQL> grant select on xxx to xxx
SQL> grant select on xxx to xxx;
The first & last two processed but the second will not because it is missing the ';'
In addition, we received no notification that second statement was not processed, therefore, it seemed the entire script was processed.
Besides adding the ';' is there any way to change the SQL*PLUS environment to show the second query was not processed.
Thanx again
-
You should have gotten an Oracle error "ORA-nnnnn".
(Normally: *
ERROR at line 2:
ORA-00933: SQL command not properly ended)
:D