Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!
A question that comes up fairly frequently revolves around how to see your errors when working with PL/SQL in SQL Developer. Most folks are probably working in the worksheet – this is the default editor for your connection. Let’s take a look at this sample program 1554257083673fdcf4a511c_000000 If we were to create this procedure, we would probably expect some errors. So let’s run this in the Worksheet. I’m using Ctrl+Enter to execute this single statement.…
New for version 3.1, currently available as a EA download, when defining the queries used to populate views, the modeler can generate JOINs using either Oracle’s or the standard ANSI compliant syntax. Let’s step back a second. When working with a VIEW defined in a relational model, the modeler has twp choices for defining the driving SQL statement that is used to populate the contents of the view. They can code it by hand -…
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 fine level of control over the execution of a job has led to a very complex mechanism and infrastructure. This…
Updated June 2015, current for version 4.1 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 with ‘capped, covered, smothered, & covered’ routine. Do you want a receipt with…
I’m lazy. If I can drive a screw with my cordless drill in 5 seconds vs 60 seconds, but have to walk to the garage to get it, I’ll pick the drill over the screwdriver every time. Probably because after I’m finished with that screw, my foreman will walk over and decide she wants the wall ornament moved a few micrometers to the left. I think the best developers are lazy. I say this, but…
Image Left, Text Right It starts out OK, even fine really. Text here, should be up top and from the left, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah,…
Ever seen a table with so many columns you wonder if the designer had fallen out of the de-normalization tree and had hit every branch on the way down? Oracle currently allows a max of 1,000 columns per table. Please do not test this limit. Maybe you do need that many columns, but I doubt it. If you were to visualize this data model, imagine how easily you might be overwhelmed with all the white-noise,…
View – Recent Objects will show you a list of objects you have click into via the explorer. If you need to keep a diary of objects you’ve messed with for the day, then this might do the trick. No, it doesn’t track what you did to the objects, but it does leave some bread crumbs for you to snack on later. You can invoke the object action lists directly from the panel, or if…
So you’re in Tweetdeck and someone mentions you in Portuguese or Swedish. You have no idea what it says, but you’re pretty sure it’s not a compliment. Thank goodness there’s the one-click ‘translate’ feature to bail you out. It’s often saved me from my elementary Spanish. How many times have you used Google’s translation services for help getting something from Korean to English? I have many times. Now, how nice would it be if you…