By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,070 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,070 IT Pros & Developers. It's quick & easy.

Column Offset problem using sqlplus from Command Prompt

P: 37
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!
Mar 19 '07 #1
Share this Question
Share on Google+
2 Replies


100+
P: 153
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.
Mar 19 '07 #2

P: 37
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
Mar 19 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.