How to set echo in Sqlplus
732607Dec 17 2009 — edited Dec 17 2009Hi,
when I write a script to execute in sqlplus I put on head the SET ECHO ON for reporting the statements executed, but the problem is I can't get the whole statement.
I mean, I've written the script
SET ECHO ON;
UPDATE PRODUCT SET CUSTOMER = 'XXXX' WHERE CUSTOMER = 'YYYY' AND COMPANY = 'ZZZZ';
When I execute the script on sqlplus I get:
SQL> UPDATE PRODUCT SET CUSTOMER = 'XXXX' WHERE CUSTOMER = 'YY
1 rows updated.
How can I get the entire statement? Do I have to use SET LINESIZE or ARRAYSIZE or what else?
Thanks!
Edited by: user12180597 on 17-dic-2009 7.55