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
Last activity: Aug 13, 2021, 02:33 PM