Sample Header Ad - 728x90

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

0 votes
1 answer
425 views
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?
Asked by Gustavo (173 rep)
Aug 13, 2021, 02:14 AM
Last activity: Aug 13, 2021, 02:33 PM