• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

sql in aix

How can we see the previously used commands in sql prompt in aix.
0
vangogpeter
Asked:
vangogpeter
1 Solution
 
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
 
Wasim Akram ShaikCommented:
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now