Search

Subscribe

Enter your email address to subscribe to this blog.

Recent Comments

Intro to Spring Security Core for Grails
Eric Pierce said: Thanks for these screencasts, Dan! You made it crazy simple to get up and running w/security core h... [More]

Removing duplicates from an array of objects
Arvind said: Great tip, can't thank you enough for this. [More]

Intro to Spring Security Core for Grails
Santosh said: Thanks much for putting up these screencasts. As the others here I'm a beginner and I've been having... [More]

Grails Spring Security Plugin - Logout postOnly setting
eriihine said: I still had some issues with this one. It seems that the href link is always generating a GET method... [More]

Intro to Spring Security Core for Grails
Dan Vega said: Just a heads up but I decided to write up a quick post on your question just in case it trips up any... [More]

Oracle default Date Format

Today I was trying to run this very basic query. When I ran the query I got the following error.

>[Error] Script lines: 1-4 -------------------------- ORA-01843: not a valid month 
For whatever reason it did not like the month. A little hunting around and I found some information about date formats in Oracle. Unless you set some type of client environment variable it will run off of the database default. If you need to find out what that is you can run the following sql. Looking at the session parameters I was able to identify that the default NLS_DATE_FORMAT was set to 'DD-MON-RR'. As I said before, I think you can change this in your environment but I just updated my query. If anyone has something to add to this please feel free, I am a complete newb when it comes to Oracle.

 
 

Oracle on the fly

When I started my job the one thing that was new to me was Oracle. As a developer I am hear to tell you that you don't need to be scared to learn it. While there are some major differences (especially in 8i) there is nothing overwhelming to learn. I am speaking from a developers standpoint, I am sure that a DBA would tell me its a different world but I am no DBA and I don't even play one on TV.

The first thing I had to get used to was some terminology. If there was a physical database machine and I created different databases I would refer to each instance as a database. I guess its more common in this world to refer to each as a Schema. Again, maybe someone could fill me in on this but its just what I am noticing here. The first thing you need to do if find yourself a tool to manage your schema's in. I am coming from the world of MSSQL so I am really use to enterprise manager. Here are some alternatives that can get you up and going quickly.

  • Oracle Developer - This is a free tool from oracle and it has a nice familiar feel to it.
  • Orace SQL Plus - Another free tool from Oracle, its a command line only tool
  • TOAD - A commercial tool that is quite popular. I installed it and it just seemed a little over the top for me.
  • Aqua Data Studio This is easily my favorite new tool in my tool belt and I plan on devoting a whole writeup on it so stay tuned.

I have a ton of things that you might run into as a developer so stay tuned for some tips.