ORACLE (185)

At Oracle Code One this past September, I was inspired to do up a special edition of my SQL Developer tips & tricks talk.

So here’s an entire 30 minutes on

While porting my Oracle code to PostgreSQL I encountered a little quirk. It’s probably not a quirk except for the fact that I’ve worked in Oracle so long. Oracle implicitly type

I’m working on items for migrating my database class from Oracle to PostgreSQL. I ran into an interesting limitation when I tried using the COPY command to read an external CSV

Time flies so quickly. And in case you wondered about the silence on the blog and on twitter, I was either traveling the past weeks or on holidays. But it’s November.

Earlier I showed how to write an anonymous block in PostgreSQL PL/pgSQL to drop routines, like functions and procedures. However, it would only work when they’re not overloaded functions or procedures.

While building my PostgreSQL environment for the class, I had to write a couple utilities. They do the following:

  1. Drops all the tables from a schema.
  2. Drops all the sequences from a schema

I wanted to get Java working with PostgreSQL to test some GUI interfaces on Linux. Figuring out the necessary JAR file for the JDBC was my first hurdle. I found it

I’m migrating my database classes from the Oracle database to the PostgreSQL database. Using the Oracle Express Edition has always required a virtualized image because students use Windows and Mac OS.

Did you know that the website has video content on YouTube? I know that many of your are forbidden from having fun at work learning via video, but rest assured

Page 1 of 14