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!

Sqlcl Repeat command question: how to break out in the middle of loop?

User_A36HOOct 2 2017 — edited Oct 2 2017

Hello,

Let's say i am in "sqlcl" and issued REPEAT command:

SET sqlformat ansiconsole

SELECT systimestamp FROM dual;

repeat 15 120

But then i want to break out of this loop and get the SQL> prompt back.

How does this work?

I was trying different combinations of Ctrl-C, Ctrl-\,etc. - none of these worked to allow me get out of the REPEAT command.

Please advise.

Best,

Added on Oct 2 2017

2 comments

589 views