You can save query results or any other grid in SQL Developer as a PDF.
You don’t get much in terms of saying how the generated PDF should look –
Said PDF file:
But I have some important info in here, and it should look a bit nicer.
Save Your Query As A Report
And then format your report, using the PDF properties.
You can set a customer header and footer, define the fonts to be used, if you want shading on the grids, spacing, page orientation, and more.
Once you have it defined – save and refresh your report.
Then run the report, right click in the grid, and export to PDF again.
You’ll notice that the report title, subject, and keywords are already defined.
You can also embed the fonts in case the user getting the report doesn’t have them so it renders as intended.
More importantly – you can set security options like defining a password required to open the report, and whether or not to allow the data to be copied out.
The PDF exports for reports are only available for grid style reports. For reports having child reports, the export will only grab the parent/master report.