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!

sqlcl equivalent of sqlplus set sqlnumber off?

wadams5 hours ago

When loading apex applications using sqlcl (25.1), it spits out > 100k lines of output due to it printing out every line number of all the plsql blocks. In sqlplus, you can suppress this with the “set sqlnumber off” setting/command. But this doesn't seem to exist in sqlcl? Is there some other way of suppressing the line number output of plsql blocks?

Thanks

Wayne

Comments
Post Details
Added 5 hours ago
0 comments
11 views