sql in aix

How can we see the previously used commands in sql prompt in aix.
vangogpeterAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Wasim Akram ShaikConnect With a Mentor Commented:
also to add .. if you have logged in aix via putty.exe then you could do setting to increase scroll back so as you can always go up and check what you have typed

can be done by clicking on settings and  increase the scrollback by selecting the Window options category and changing the Lines of scrollback option.
This will increase your visibility on terminal window for a limited period but as such with history,  not much can be done as our experts suggested

alternatively spool sql in text file to maintain a history. . not a goodand convenient option though
0
 
slightwv (䄆 Netminder) Commented:
If you mean sqlplus: you can't.  sqlplus doesn't have a command history.

You can only see what is currently in the buffer with a list (or single l) command.
0
 
DavidSenior Oracle Database AdministratorCommented:
There may be a after-market product floating around, but a fast/cheap alternative is to pick up a GUI tool such as Oracle's SQL*Developer, or Dell/Quest's TOAD; there are others, of course.

Within the CLI, I've had limited success just doing a manual copy/paste into a text editor -- or if desperate, a series of screen snapshots using the MS snipping tool.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.