Data Conversion

LewisC's An Expert's Guide to Oracle Technology I needed to update some files and that meant updating some utility functions that I haven't looked at in a long time. I decided to share a few of them today. One of the most important aspects of PL/SQL...

LewisC's An Expert's Guide To Oracle Technology I will be presenting at the Virginia Oracle User Group (VOUG) user conference on Oct 9 & 10. The conference is being held at the Omni Richmond Hotel in Richmond, VA. It looks like it will be a good conference with plenty

LewisC's An Expert's Guide To Oracle Technology My friends at the Suncoast Oracle User Group sent an email last night about an Oracle Developer Day event coming to town in a couple of weeks. The last Developer Day I attended was, I think anyway, on SOA and BPEL.

LewisC's An Expert's Guide To Oracle Technology In December 2006, I wrote an entry called Oracle Streams Configuration: Change Data Capture. That entry turned out to be very popular. It's had a lot of comments. I've also

LewisC's An Expert's Guide To Oracle Technology Today I will be writing about triggers. One of the questions I get fairly often is "what is the difference between a function, a procedure and a trigger?" I already wrote about functions and procedures in Learn

LewisC's An Expert's Guide To Oracle Technology My previous list of tips seems to be popular so I thought I would add a few more database specific tips. I'm keeping this list database agnostic. These 10 should apply to any database

LewisC's An Expert's Guide To Oracle Technology The question I am most frequently asked is a variation of "How can I become a DBA or developer?" or "How can I learn x database?". There are so many places to start and so many options when you do start that it can be very confusing. I got a couple of questions this weekend that made me

LewisC's An Expert's Guide To Oracle Technology Ok, I know you you've heard of them. Heck, in some cases, you've been beaten over the head with them. So why aren't you using them? I've heard some people saying that it's easier to code without bind variables. Really? Concatenating strings, potentially with

The solution is called Heterogeneous Services Generic Connectivity. I usually just call it HS links. Basically, you configure an ODBC data source and then create a database link against that source. You can run DML against the source just as you would against an Oracle database.

LewisC's An Expert's Guide To Oracle Technology This falls under the heading, "Learn something new every day!" You can grant access to objects via synonyms. I swear I have never done that and didn't know you could. Oracle will automatically pass the grant on to the underlying schema object. I'm not sure I like