Thursday, May 03, 2007

Very Neat Trick Part II

Thanks to Laurent Schneider - even cooler...

POST A COMMENT

9 Comments:

Anonymous Anonymous said....

what version of oracle can one use this? Regex in database. Sounds great..mm

Thu May 03, 10:52:00 AM EDT  

Blogger Thomas Kyte said....

Regular expressions are a 10g new feature.

Thu May 03, 10:56:00 AM EDT  

Anonymous Anonymous said....

What is this obfuscated SQL context? What is wrong with

select EMPNO||';'||DEPTNO||';'||JOB||';'||MGR||';'||HIREDATE||';'||SAL
from emp

Thu May 03, 01:34:00 PM EDT  

Blogger Joel Garry said....

This comment has been removed by the author.

Thu May 03, 01:46:00 PM EDT  

Blogger Joel Garry said....

Whenever one is dealing with delimited formats, one must deal with special characters, including quotes and delimiters, in the data.

This has been well known at least since Captain Crunch was phone-phreaking.

Thu May 03, 01:48:00 PM EDT  

Blogger Eriks said....

I would never never use that approach - it's 100% unmaintainable code. Simple dbms_sql.parse, dbms_sql.column_value can do the job just fine without this xml nonsense.

Tue May 08, 01:58:00 PM EDT  

Anonymous Anonymous said....

eriks, you are absolutely right.

using XML here is pure nonsense
dbms_sql - that's the way to go

Thomas:
how can this be posted on May, 03, 09:23 AM and pointing to a blog entry
"posted on Monday, May 7th, 2007 at 12:33" ?

That's real magic

Tue May 08, 03:25:00 PM EDT  

Blogger MWrynn said....

Anonymous (Can't you just say your name is Steve or something? I hate addressing "Anonymous" :)): Looks like Tom edited his previous entry from the 3rd rather than posting a new one.

I too think this function is ugly. It would be nice to have a simple built-in function that accomplishes the same thing...

Mark

Tue May 08, 03:47:00 PM EDT  

Blogger Linh Travel said....

Your post's very good. I like it.
-----------------------
Vietnam travel agency
Vietnam travel
Vietnam holiday
Vietnam tour
Vietnam tour operator

Fri May 11, 12:41:00 PM EDT  

POST A COMMENT

<< Home