It’s a relational database, so it’s only a matter of time before you stumble across an object that’s dependent on another object, right? If you are looking at a table in the browser, be sure to check out the ‘Dependencies’ page. This page displays the database objects that will be upset if the selected table [...]
tips
Scheduling Jobs with Oracle SQL Developer
DBMS_SCHEDULER is awesome. It’s flexibility is remarkable. From setting up execution windows to remote execution to automatic notifications, there is a LOT to like. That doesn’t mean it’s perfect. For developers and DBAs, it can be a real pain to type out 2000+ characters to simply create a job. Being able to have such a [...]
SQL Developer Quick Tip: BLOBs and Images
Binary Large Objects – otherwise known as BLOBs. You’ve also got large objects which are composed of text – that would be a CLOB. If you hear people talk about LOB storage, they are referring to how the data in these fields are stored – outside the space reserved for the regular segments (table data.) [...]
Top 10 Preferences to Tweak when using SQL Developer
There are too many options in our every day lives. We love asking for more options, but I often find myself being overwhelmed by the number of questions I have to answer before I can accomplish very mundane tasks. Do you want your latte ‘skinny’ or your cappuccino ‘wet?’ Waffle House customers are probably familiar [...]
How To: Configure TABs in SQL Developer
As often happens, my ideas for blog posts are provided by end users asking for help. Sometimes I know the answer, sometimes I don’t. This is one of the latter cases. Chet AKA @oraclenerd asked me: ‘Tell me how to find the preference in sqldev to make a tab 2 spaces?’ I knew it had [...]
Twitter
RSS
GooglePlus
Facebook