This might sound preachy, but it’s mostly not intentional, mostly.

You might really enjoy the flexibility of the PL/SQL APIs the database provides for things like Resource management, the Scheduler, Data Pump. You might even have memorized the PL/SQL function/proc names and arguments required to create a job, or change up a resource.

But do you really want to spend that much time typing?

So.

While I can show DBAs, over and over again, how easy SQL Devleoper makes using this features, I’m never going to convince them to give up ‘control.’

But can you have your cake and eat it, too?

I say ‘yes.’

EVERY panel/wizard in SQL Developer will show you the SQL or PL/SQL generated to satisfy your request. Once you get that, send it to a worksheet or file. Then add/remove/change whatever you like. Then go run that in SQL*Plus or SQLcl.

Let us at least help get the ball rolling with your big anon PL/SQL block.
Let us at least help get the ball rolling with your big anon PL/SQL block.

And then when you’ve got your code all nice and ready, go run it wherever you want.

It won't hurt, I promise.
It won’t hurt, I promise.
thatjeffsmith
Author

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

2 Comments

  1. Re: EVERY panel/wizard in SQL Developer will show you the SQL or PL/SQL generated to satisfy your request.

    Where do I find the generated SQL or PL/SQL for the Database Copy wizard? Thanks.

    • thatjeffsmith

      That’s what I get for saying ‘EVERY.’ In this case the wizard is going to run a bunch of code that then generates more code, which is then executed.

      You can see it as it runs in the View > Log > Statements panel.

      When it’s finished, you also get a log in your editor which shows all the object creation and alter statements.

Write A Comment