Oracle 12c Release 2 - How to get SQL Plus command history

preview_player
Показать описание

Want to go retrieve and edit previous commands in SQL Plus without using things like rlwrap ? easy in 12.2

========================================­­­­==============
Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Рекомендации по теме
Комментарии
Автор

Does this not work in version 11.2.0.3.0?

COKEDUDEUSF
Автор

I'm running 12c, and I'm not sure why, but the history command does not work. I get SP2-0042" unknown command "history". Any idea why this command would be missing, and how to add it?

nickpohl
Автор

What did you press at 1:05? I press enter and it goes to a new line.

InspirePeakYT
Автор

Big deal. SQLcl has a real history capability, not a command, just up and down arrow.

johnflack
Автор

Really? It's that bad? Why not simply press cursor up and down? And why can I not go left and right to change a typo? Wow... This adds all up to my hate to Oracle DB. But the graphical setup was the worst on a headless machine in a LXC container...

NicosLeben
join shbcf.ru