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!

Hide a column with SQLCL (COLUMN xxx NOPRINT) ?

User_RQ34CApr 15 2022

Hello all,

I am trying to hide a column in a result file. For example :

COLUMN test NOPRINT
select '039' test, 'toto' from dual;

In SQLPlus or SQLDevelopper it work.
But in an execution from SQLCL with .sql file, i have not an error with COLUMN xxx NOPRINT, but in my result, the column Test is present.

SQLCl ignore NOPRINT without error ? Or did i forgot a thing ?

SQLCL.png

Thanks for your help,
Regards,
Loïc

This post has been answered by User_H3J7U on Apr 15 2022
Jump to Answer

Comments

Processing

Post Details

Added on Apr 15 2022
2 comments
722 views