Shell Programming and Scripting

I found out that it's because of a '$' being generated automatically; which I do not know how or why.

The code that I've used is shown above. Post #10
Our OS is Linux with x86_64 GNU/Linux version. (Is this correct? I generated it using uname -a command)

I saw the unnecessary $ upon using vi, set list command. The script is creating an extra '$' character after 1100 characters.

Moderator's Comments:

Posts have been approved. Please start using [CODE] tags when posting source code, pre-formatted text like console output, ...

---------- Post updated at 05:11 PM ---------- Previous update was at 09:40 AM ----------

Hi, I got a preview of what's the problem by viewing the entire output/file using UltraEdit.

The problem is that the csv is inserted with '$' hidden charactr every after 1100 characters. Say for example: 1 character = 1 column, column 1101 is inserted with '$' character whereas I still have data to print after that column. I can't remove all the '$', I need it for proper printing of rows.

Does your Oracle SQL*Plus program contain a "set linesize" command?

Do you have default values set for SQL*Plus which might include a "set linesize" command? Look for login.sql in your home directory or glogin.sql in the Oracle tree.

Code:

$ORACLE_HOME/sqlplus/admin/glogin.sql

Oh, that's it! The linesize on sql.

Thank you so much!