If you have problems in your PL/SQL program that prevent compilation and execution of said program, then that is reported back as an ‘error.’ It could be as simple as missing a semicolon – When you run this through SQL Developer, an error message is returned a la Well that’s an easy fix. We’re all Continue reading →
Database Stuff
Substitution Variables & HTML Reports in SQL Developer
Martin asks – I am searching for any method to pass any table name to a sql statement in a self-written report. My initial response was to quote Lewis’ article in Oracle Magazine where he discusses bind variables, Making the Most of Oracle Developer Reports. So binds work, but what about SQL*Plus Substitution Variables? You’ve Continue reading →
SQLDev Trick: SHIFT+Hover to Peek Into a Stored Proc
I’m poking around an unfamiliar schema or environment. I’m not sure what these procedures do. I could open them, but I’m lazy and I don’t want the tool to open another document/window. The ‘mystery’ code: These programs are self-documenting as they have the most awesome names ever! I’m guessing that one package will blast my Continue reading →
ODTUG SQL Developer Tips & Tricks Presentation
I’ve been fine-tuning my SQL Developer Tips presentation, having given it at RMOUG and now electronically for ODTUG. Still a lot of work to do until it is ‘perfect,’ but folks already seem to enjoy it (if not me.) What I have left to do is trim the fat so I can shove as many Continue reading →
Let SQL Developer Normalize Your Tables For You
SQL Developer is a pretty mouse-heavy tool. By that I mean that many of the functions are accessed via mouse-clicks. When browsing tables in the tree you may have noticed that you can expand a table node to display the table columns. There are some pretty cool features available under the context menu when clicking Continue reading →
How to Disable ‘Save Password’ in Oracle SQL Developer
Oracle SQL Developer allows a user to save their passwords for their Oracle database connections. I don’t want to continue the ‘is it bad to save passwords’ debate, but I will share a ‘trick’ for making some of you a bit happier. Just add the following line to your ‘sqldeveloper.conf’ file, which lies in the Continue reading →
Twitter
RSS
GooglePlus