Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is >.... in SQLcl

AboMohammedJul 4 2022

Hi,
When I past a long procedure to sqlcl it folds some lines and give me this sign >....
Is there a way to stop this behavior.
It is really annoying.

Comments

Paavo

Hi
Copy-pasting large snippets sounds like you could benefit of using editor instead?
It is possible to define editors like: emacs, vi, visual studio code.
For vcode:
--open terminal in vcode and use sqlcl and e file.sql and / commands and enjoy
define _EDITOR=code -w -r
rgrds Paavo
ps. have a look on @thatjeffsmith-oracle blogs e.g. http://www.thatjeffsmith.com/archive/2016/05/multiple-ways-to-edit-in-sqlcl/

AboMohammed

Thanks for your response.

I will definitely try it.

1 - 2

Post Details

Added on Jul 4 2022
2 comments
209 views