For the month of September I’m challenging myself to perform two different feats of strength: Do 5,000 push-ups in the month of September Post a SQL Developer Tip or Trick every day for the next 30 days I’ve noticed my posts are starting to go out once or twice a week, and I like to average three. So hopefully this mini-bootcamp of blog posts will me back on schedule. So, without further ado, Tip #1:…
I’ve recently spent a few hours debugging some user defined reports. A post on how to add trace/disconnect context menus to a session report required that I figure out what session my worksheet was running under. The code was easy… 17754663416640044185952_000000 …but I’m lazy. So this: The Setup Open your preferences and go to the SQL Editor Code Templates. As you code these, you recall them from what you label them via the ID, not…
If you’re wondering why I would bore everyone with my pictures and frequent status updates/tweets from the past week – it’s so I could document the process of refurbishing my deck, or what some would call a porch. When my wife and I go to take a vacation, buy a car, do anything – we try to read personal blogs and reviews online to get the real story. I want to pay that treasure trove…
Very quick and short post today. The question: In version 4 of Oracle SQL Developer Data Modeler, how do I get the names of foreign keys to appear on the relational model diagram? First of all, right click in the diagram space: With this on, your diagram will now look like this:
There really are times your tool is smarter than you are. Thank you #SQLDev Code Insight for listing syntax examples. @thatjeffsmith— Amy Caldwell (@amyccaldwell) August 7, 2014 In fairness to Amy, I don’t think SQL Developer is ‘smarter.’ I think it just has faster access to the Oracle Docs than she does. And SQL Developer won’t ask for help. Amy knew HOW and WHEN to ask for help. Now let’s take a look at how…
Oracle Open World is just around the corner. Every year, tens of thousands of Oracle geeks gather in San Francisco for a week for learning, networking, and more than a little bit of fun and socializing. If you’re going to be there, here’s what you need to know about your favorite development tools team 🙂 Fun Stuff 3rd Annual SQLDev Golden Gate Fun Run 5k On Sunday before all the craziness starts, a few of…
Oh, I so DO love hearing about things that ‘we cannot do.’ This morning I read that in an article that Oracle doesn’t allow you to copy data from Excel and paste directly to a table. AHEM. In the video you see me selecting the cells in the Oracle table editor before pasting the new ones in, but you don’t actually need to do that. Just make sure you start the paste from the first…
Instead of having a column of type VARCHAR2 for a ‘Country,’ you might want to create an COUNTRIES type. Said COUNTRY would have an ID, NAME, and LOCATION. To make things even more fun, LOCATION would also be a custom type of LOCATIONS, having even more attributes/columns. To model these from scratch, you would build them in your design as part of the Data Types Model. You could then take advantage of them in your…
Quick Question: Is there a way in SQL Developer to have the DBMS Output window clear when you execute a block? Quick Answer: CLEAR SCREEN [Oracle Docs] SQL Developer supports many, and soon to be ALL, SQL*Plus commands. CLEAR is one of them. So just add this to the top of your script. When you execute your script, the Output Panel will clear. You’ll see there’s the output from the previous run, then we execute,…
I like to experiment and play with new shiny objects. LinkedIn recently added a blogging platform to their site. I’ve decided to publish a little thing on how to do a better job on writing abstracts for conferences. A few disclaimers: I’m no expert, but I write and review a TON of these Many people tell me they want to submit a talk, but don’t have the experience to do it up ‘right’ I mentioned…