Click vs Type…Again.

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 […]

Similar Posts by Subject Areas: , , ,

Just another GIF: Debugging PL/SQL

Start a debug session…step over some code…look at a variable…run to a breakpoint…investigate the data in a PL/SQL table…step into another program…check out the callstack. Just another day in animated GIFs and showing you what SQL Developer is capable of. If you’re curious or want more info, hit the ‘debug’ link at the end of […]

Similar Posts by Subject Areas: , , ,

More on XML Extensions in Oracle SQL Developer

I’ve written a few posts on this subject… Intro to Extensions Adding Synonym Support with Extensions Adding an Error page for Views with an Extension Also, there’s two VERY nice resources for you that I recommend: My predecessor Sue Harper talks extensions in Oracle Magazine Mike Smithers has an exhaustive blog post on adding context […]

Similar Posts by Subject Areas: , , ,

Oracle SQL Developer Code Reports

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 […]

Similar Posts by Subject Areas: , , ,

30 SQL Developer Tips in 30 Days, Day 20: See, Click, Goto Error Messages

This question comes up very frequently: Why can’t I see my compilation errors when I’m working with PL/SQL? Because you are either: using the wrong editor, or not asking to see the errors SQL Developer is the PL/SQL IDE for the database. So we obviously need to have those ‘fancy’ IDE features like a debugger, […]

Similar Posts by Subject Areas: , , , ,

Oracle SQL Developer v4.0: Breadcrumbs

Hansel and Gretel are in the forest and don’t want to get lost, so Gretel leaves a trail of white pebbles to mark their way. In future adaptations of this Bros. Grimm story, the white pebbles have become ‘breadcrumbs.’ So what does this have to do with SQL Developer? When working with large bits of […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,