How to format the output of query in SQLcl to have no header?

All we need is an easy explanation of the problem, so here it is.

I want to execute a query that will produce an output that are SQL commands too to be executed later. Something like:

SELECT
    'DROP ' || OBJECT_TYPE || ' "' || owner || '"."' || object_name || '";' as command
FROM
    ALL_OBJECTS;

The problem is that the output always have the header. In this case "command".
I tried the documentation, but its very simple and brief in its explanations.

How can I disable the header, or where can I find a more complete documentation on how the formatting in SQLcl works?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

SET HEADING OFF

Very difficult to guess what the 72 system variables of the SQLcl environment do.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply