BLOBs are cool. Optimized such that you can store files basically in the database, with the power of SQL AND no performance hit. That sounds like a pretty good deal. I get asked questions a lot about accessing BLOBs once they’re in the database. And that’s led to quite a few posts here on the […]
Oracle SQL Developer Reporting 101
150 of my closest friends, or some random people on the Internet, joined me today while we talked all about SQL Developer’s reporting feature. Did you miss it? If so, I’m guessing you’re not a member of ODTUG. They put on free webcasts for everyone in the Oracle technology space. If you’re a member, you […]
Video: Completion Insight in Oracle SQL Developer v4.0.2
I said earlier today that version 4.0.2 of SQL Developer consisted on ONLY bug fixes. I should have said MOSTLY bug fixes. There was also one minor tweak, although it was a minor tweak to a major feature: Completion Insight. This is the feature that kicks in while you are typing – suggesting column or […]
Oracle SQL Developer & Data Modeler v4.0.2 Are Now Available
As of late yesterday afternoon, we have two new updates for you: Oracle SQL Developer v4.0.2 – bug fixes only Oracle SQL Developer Data Modeler v4.0.2 – bug fixes and a few tweaks You can read the release notes to see exactly what’s changed. For SQL Developer, the major things are an update to fix […]
How Can I See Tables from Two Different Connections in Oracle SQL Developer
A customer wanted to know how they could quickly see what tables were in one database, but not in another. They don’t want to run a DIFF, they just want to click-click-click-BAM! So, we want to go from here: to here: Here’s what I’m doing: Open A Schema Browser Float it Repeat as desired And […]
Oracle SQL Developer Picture Puzzle: What is that?
Sometimes while I’m demonstrating Oracle SQL Developer, something on the screen catches the eye of someone in the audience, and they just have to know ‘what is that?’ So I put together the image you see above with a few key features highlighted. These might be things you’ve missed because they’re not default preferences or […]
How To Add Custom Actions To Your User Reports
I’ve shown you and more than a few customers how to customize your Monitor Sessions page/report. If you need a refresher, that’s here. But basically it comes down to this: Copy the report from the Database Administration section of the Reports panel Paste it to the User Defined Reports section Edit to your heart’s delight […]
How to Preserve System Generated Constraint Names in Oracle SQL Developer Data Modeler
The risk of posting a question here, is that I might take it and turn it into a blog post. And that’s where today’s topic comes from. I imported data dictionary into SQL data modeler and cannot found out how to disable predefined constraint names. Table “T” was created in database without specifying primary key […]
Unit Testing Your PL/SQL with Oracle SQL Developer
If you want to unit test your PL/SQL, then Oracle SQL Developer can help make that easier for you. I’m not going to try to convince you to test your code, but if you’re already rearing to go, then read on. So I have a long history with unit testing tools for PL/SQL, but I […]
Oracle SQL Developer: Configuring Object DDL Scripts
One of the more popular features in SQL Developer is the ability to generate the CREATE DDL script for any object. If you open an object editor, the SQL page shows this script. Now, what many of you don’t realize is that the way this code can be generated is configurable. The requests I am […]
SQL Developer Quick Tip: Extended Paste
Someone on the Twitters was lamenting they had accidentally clobbered their code when they ‘copied over it’ in their clipboard. So basically you cut your code – it goes to clipboard, you copy something else, the :new replaces the :old. But. SQL Developer keeps an Extended Clipboard. It’s just what it sounds like. We keep […]
Oracle SQL Developer: Extending a Tablespace
I get asked this question a LOT (especially from people looking to switch tools) – can your product help me extend a tablespace, i.e. make it bigger? But then, I also get this: we hate tools because the Junior DBA pages us at 3 in the morning when the tablespace is full, and they can’t […]
Oracle SQL Developer’s Best Kept Secret: Reports
The feature that everyone knows about yet does not use? That would be the reports. I say that everyone knows about them because we throw them in your face..at least in terms of the user interface. It’s feature prominently next to where you see your database connections and objects. Yet, when I ask a room […]
Product Name Challenge!
We have to rename Oracle SQL Developer – there’s not enough ‘Oracle’ in the name! So, I’d like to crowdsource some ideas. Here’s a few to get you started: Oracle SQL Developer for Oracle Oracle SQL Developer Unbreakable Oracle We Can’t Believe It’s Not Chargeable SQL Developer Yes, it’s April Fool’s Day, again. Yes, I’m […]
Oracle SQL Developer: Query Builder Video Demonstration
I’ve talked about the query builder a bit here on these pages, but sometimes a quick video can do a much better job demonstrating these concepts. The video is about 8 minutes and covers: writing a query the old-fashioned way writing a query with drag-and-drop from the tree using the Query Builder At about 5 […]
Twitter
RSS
GooglePlus
Facebook