Use of .echo ON in SQLite
I know that .echo ON display the command we have written. But Whats its use. Why we will display the command we have already written
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Nov 22, 2011, 4:00 AM
Monika AroraPosted Nov 21, 2011, 4:47 AM
Pravin MorePosted Nov 18, 2011, 12:29 AM
Hi Monika,
if you set echo ON,then output will be SQL script echoed in the CSV file with output.
now lets think of someone who dont have orignal script n have only output file....so he can easily get to know what is flow of output through sql commands,i think thats the use of echo ON.
Note:- you can set it OFF by 2 ways
1.set echo off
2. by calling sqlplus in script with the "silent" option: sqlplus -s
second is nedd when you pass whole script as input to some command like cat,that time 1st not works
Thanks,
Pravin.