I loved Fred Rogers. He helped raise me. Nicest guy ever? So what does he have to do with Oracle SQL Developer Data Modeler? One word, ‘neighbors.’ I got a good question from a new user yesterday: Is there a quick way to add all the tables (to a subview) directly related to a specific table? First, you know what a SubView is, yes? It’s what we call a ‘sub model’ – or a subset…
I’m not sure why, but it appears many of you wish you could take back your SQL queries. It’s like that one time you posted that picture on Facebook and immediately (3 days later) you realized it wasn’t a great career move. Maybe that data you asked for wasn’t going to be that helpful if it took 3 hours for it to come back. This reminds me of the weather forecasting models can that could…
Yes, it’s true. Some people export their data to formats other than Excel. Another popular format is ‘delimited,’ where fields are defined by a delimiter. The most famous of these is CSV, a comma separated values file. So your data can be read by another program quite easily because it knows where one field stops and the next begins. A quick example: But I Don’t Want to Use Commas! Ok, well no need to shout.…
Full Disclaimer: I’m speaking at KScope. When I talk about how awesome the speakers are, I’m excluding myself, naturally. ODTUG USED to stand for ‘Oracle Developer Tools Users Group.’ Their scope has broadened to include more than just the developer audience, but it’s nice to remember this was and mostly still is a group FOR developers BY developers. For as long as I can remember, OK since 2005 or 2006, the best speakers and experts…
Software development never really stops. The development cycle is truly a circle. Once a release is ready, the developers don’t go on break awaiting orders. There’s always the next sprocket to build or widget to refactor. And so comes one of the best parts of my job: helping figure out what those widgets and sprockets will be. And while we don’t comment on new features or release dates of our products, I will give you…
Oracle’s free data modeling solution, Oracle SQL Developer Data Modeler, has been updated with the release of version 3.3. I’ve already previewed a few of the new features here, and I’ll continue to talk more about the latest and greatest features. You can see the full list of new features and download the tool on our official OTN Product Page. A Few Housekeeping Notes We’re updating Oracle SQL Developer Data Modeler today, but as many…
The Oracle SQL Developer family currently has two ‘SQL Developer’ branded products: Oracle SQL Developer Oracle SQL Developer Data Modeler Oracle SQL Developer is the database IDE and Oracle SQL Developer Data Modeler is our dedicated data modeling solution. Where it gets interesting is that the entire Data Modeler product also runs inside of SQL Developer. When I do demo’s of building quick ad hoc models in SQL Developer, I’m frequently asked to ‘back up’…
An interesting question came up on the ORACLE-L mailing list this morning regarding table comments: Just wanted to get a general opinion on using comments in the database. For example COMMENT ON COLUMN table.column “No comment”. Does anyone do this as a regular best practice? I would prefer to see this abstraction in a data model, maybe not pushed to the database layer, especially since not all RDBMS engines have “comment” functionality. The thought is…
Post updated November 12, 2018. The answer is simple – you can’t see any tables, because you don’t OWN any tables. I hate to be the bearer of bad news, but you don’t have any tables. What you mostly likely DO have are SYNONYMS that point to tables in an application schema. When you log on to Oracle, you are seeing this: But wait you say – I queried something called ‘EMPLOYEES’, I should be…
Getting the Windows ‘busy’ hourglass cursor is sure to raise anyone’s blood pressure. Sometimes you’re left there waiting because a resource you’re attempting to access is already being used by someone else. So you get to WAIT. You are being BLOCKED because what you want is LOCKED. How can you see what the hold-up is? And more importantly, how can we figure out who or what is causing the delay so we can go KILL…