Column Offset problem using sqlplus from Command Prompt

[mivey4]

Okay,

Here's the problem.

I quite often use sqlplus from a command console for obvious benefits that aren't available using the sqlplus windows application. Such as storing the previous commands in the buffer so I don't have to re-type an entire statement repetitively to acquire the results or recieving an real-time horizontal scroll of the results and etc.

My concern is that I've noted an apparent offset of the column headings to their corresponding underlying content when there are many columns in a table. This offset doesn't seem to occur using the windows-based sqlplus program though.

Does anyone know of a way to correct or compensate the offset problem from the console or am I pretty much left with a catch 22 decision of trading off the benefits of the console to use the windows app to correct the column alignments?

I hope I have described the problem well enough for anyone to understand.

Thanks!

[Dave44]

Okay,

Here's the problem.

I quite often use sqlplus from a command console for obvious benefits that aren't available using the sqlplus windows application. Such as storing the previous commands in the buffer so I don't have to re-type an entire statement repetitively to acquire the results or recieving an real-time horizontal scroll of the results and etc.

My concern is that I've noted an apparent offset of the column headings to their corresponding underlying content when there are many columns in a table. This offset doesn't seem to occur using the windows-based sqlplus program though.

Does anyone know of a way to correct or compensate the offset problem from the console or am I pretty much left with a catch 22 decision of trading off the benefits of the console to use the windows app to correct the column alignments?

I hope I have described the problem well enough for anyone to understand.

Thanks!

not really sure on your issue, havent noticed it yet, but if you have set an editor for the windows sqlplus it keeps the last statement you have run. you just type ed and hit enter then it pops open notepad or whatever editor you have set.
unfortunately it only keeps the last statement ran though.

[mivey4]

not really sure on your issue, havent noticed it yet, but if you have set an editor for the windows sqlplus it keeps the last statement you have run. you just type ed and hit enter then it pops open notepad or whatever editor you have set.
unfortunately it only keeps the last statement ran though.

Sweet! I wasn't aware of that feature in sqlplus.
I suppose it won't remedy my issue from a command console but that will help a bit when using the sqlplus editor.

Thanks for the tip