I have signed up with a new service, Job-a-matic, to list and promote Oracle related jobs. Why would you want to list your jobs here?

Post a Job!
$75 for 30 days

• This is a job listing that targets Oracle professionals. As such, you can target your Oracle needs to a very specific market.
• It’s easy to post jobs to Oracle-Jobs using Job-a-matic’s four step process.
• Your jobs will also be posted across the entire Simply Hired jobs network, which includes sites like MySpace Jobs, LinkedIn, MyWay and, of course, Simply Hired.
• I will promote and high-light weekly job offers.
• At $75/month per listing, it’s a darn good deal!
• Do you really need Oracle-savvy talent? Give Oracle-Jobs a try.

oracle jobs listing employer

I am now listing Oracle Jobs here on the Oracle DB News blog. You can click the banner above or on the list of jobs to the right.

You can also click this banner:

Post a Job! $75 for 30 days

If you need a job, think about going this route.

LewisC

oracle jobs

I am reading up on MySQL Proxy and find it to be very interesting. It looks like the proxy is a network layer between clients and servers. A client may think it is connecting to a single server but in reality, the client’s query could be running against multiple distributed servers.

Another nice feature is the ability to monitor and secure data at the query and result level. A client can send a query and the proxy can log that query. When the results come back, the proxy could strip out data (or mangle it) before it goes back to the client.

A neat article in the September 2007 issue of VARBusiness. The article is titled: EnterpriseDB Offers Options To Oracle Lock-In. Not a lot of new info here but there were several good points.

The mention the EnterpriseDB ROI calculator,

EnterpriseDB provides a calculator on its Web site where prospective customers can compare Oracle licensing costs to EnterpriseDB subscription fees.

I blogged about this a while back, EnterpriseDB – Measure ROI versus Oracle.

They also talk about how most of EnterpriseDB sales are direct but EnterpriseDB expects,

that partners could account for as much as 30 percent to 40 percent of EnterpriseDB’s sales by the end of next year.

It’s actually fairly easy to create a function using PLpgSQL, especially if you are coming from a database background like Oracle or DB2. Both have procedural languages that look a lot like PLpgSQL.

I’ll go ahead and show you the code for a very basic function and then I’ll explain the steps individually.

CREATE OR REPLACE FUNCTION func_1()
  RETURNS CHAR VARYING(25)
AS $$
DECLARE
  local_char_var CHAR(30);
BEGIN
  SELECT datname
    INTO local_char_var
    FROM pg_database
    LIMIT 1;

  RETURN local_char_var;
END;
$$ LANGUAGE plpgsql;

Ok.

I was browsing around YouTube tonight and ran across this video of a webinar that Steve Feuerstein did back in 2005. It’s about an hour long. He covers various pl/sql tips that for the most part you should know by now unless you are just starting out. It is probably a good refresher for someone who doesn’t spend most of their time coding PL/SQL.

Some of the things he calls mistakes, I would not. Some are just preference issues. Worth watching though.

LewisC

oracle video pl/sql tips