It’s so much more fun to watch users demo and brag about your software than it is to get up and do it yourself. For one thing, it means a lot more coming from real people than it does coming from someone PAID to talk it up.

Today, about 40 of us in Raleigh/Durham watched David Mann [Twitter] demonstrate lots of fancy SQL Developer reports at the East Coast Oracle Conference.

Before he started, he had a quick question for me:

What are the ‘Code’ reports for?

What's this do?
What’s this do?

And of course, I couldn’t remember.

But I knew that I USED to know.

And here’s the answer: it’s nicely formats your CODE. So if your query returns PL/SQL for example, you get keyword highlighting, etc.

Like so…

This child report returns PL/SQL code - let's take a look...
This child report returns PL/SQL code – let’s take a look…
I'm querying one of the SOURCE views, appending TEXT to the LINE value - I like line numbers :)
I’m querying one of the SOURCE views, appending TEXT to the LINE value – I like line numbers 🙂

If I got industrious, I’d write a UNION query to grab the first line and prefix a ‘CREATE OR REPLACE’ to the code, but I’m not…so you can use your imagination.

Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

2 Comments

  1. Marcelo Carrasco Reply

    Hi Jeff,

    Is there any way to obtain the source code of the existing reports in sqldeveloper?

    Thk.

    • Paolo Sberna

      In the Reports tree right click on the report you are interested, then on Save As.

Reply To Marcelo Carrasco Cancel Reply