@thatjeffsmith Great blog! Is there a way to display DB Doc in SQL Developer like in Java IDEs with Java doc while being in Code editor?
— Sebastian Köll (@s_koell) December 1, 2016
And here’s the answer – Yes!
First, let’s talk about PLDoc, and how it works in SQL Developer.
All caught up? Great.
Now let’s show you how to preview your fancy code doc before you go to generate the HTML.
Put your cursor on the item you want to see the doc on.
Right click, and select ‘Quick Documentation.’
But. Maybe you don’t want to have to click around – you want to see EVERYTHING.
But your cursor up top on the object name in the CREATE line.
Pretty cool, right?
Same for testing…
If you looked closely at the code editor context menu, there’s a ‘Test Query’ item on there.
Let’s say you have a cursor…and you’re too lazy to copy/paste it to a SQL Worksheet.
Highlight it, right click, Test Query.
Here’s the plan.
While this is a nice feature – I would recommend copying it to the SQL Worksheet if you’re going to do any serious work on it. Eventually you’ll exhaust the usefulness of the ‘Test Query’ dialog. But for quick and dirty – it works pretty well.