how to add ; at the end of last line

Shell Programming and Scripting
1

hi,
i have file which is having large sql query
eg :

i am executing this sql file but now i want to add ; after query on same line
i.e. i should look like

any idea how to achieve it ?

2

I am really not sure what you are asking. Could you provide a bit more detail, such as a few lines from the current file (or mock ups), and what you want them to look like ?

3

just wanted to add ; at end of last line !

is it possible via shell script?

4

Yes:

sed '$s $ ; ' infile > _tmp_ && mv _tmp_ infile

Some sed implementations support in-place editing with the -i switch:

sed -i '$s $ ; ' infile

And, of course, you can use Perl:

perl -i.orig -pe's/$/;/ if eof' infile
5

ohk good...does it replaces EOF with ; ?
does it means EOF does not exists in updated file ...then i cant read it right ?

6

Just run the commands and check the file content.

7 
echo "select * from tab" |awk '{print $0";"}'