The Artima Developer Community
Sponsored Link

Ruby Buzz Forum
PostgreSQL 1, Oracle 0

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Daniel Berger

Posts: 1383
Nickname: djberg96
Registered: Sep, 2004

Daniel Berger is a Ruby Programmer who also dabbles in C and Perl
PostgreSQL 1, Oracle 0 Posted: Feb 24, 2006 10:10 AM
Reply to this message Reply

This post originated from an RSS feed registered with Ruby Buzz by Daniel Berger.
Original Post: PostgreSQL 1, Oracle 0
Feed Title: Testing 1,2,3...
Feed URL: http://djberg96.livejournal.com/data/rss
Feed Description: A blog on Ruby and other stuff.
Latest Ruby Buzz Posts
Latest Ruby Buzz Posts by Daniel Berger
Latest Posts From Testing 1,2,3...

Advertisement
I'm having to deal with some LONG string data in an Oracle database. It's raw XML, and there are cases where we need to parse out the value of a specific tag, replace that value, then insert it back into the database.

I forgot just how awful Oracle's string handling functions are. No regular expressions. We have to resort the tried and true method of INSTR() + SUBSTR() combinations. What should be a single line is now five. Blech. I know there's an XML package in Oracle, but it looks even more difficult to parse data than the method we used. Double blech.

Needing to check the data afterwards, I tried to run a LIKE on a LONG datatype. Whoops! You can't do that in Oracle. You'll have to create a temporary LOB table and search against that. How 1980's of them.

PostgreSQL, on the other hand, has a plethora of string functions and allows regular expressions in its substring() function.

Yay, PostgreSQL!

Read: PostgreSQL 1, Oracle 0

Topic: Chapter 10 Previous Topic   Next Topic Topic: Chapter 9

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use