Very Neat Trick Part II
Thanks to Laurent Schneider - even cooler...
posted by Thomas Kyte at 9:23 AM
Thursday, May 03, 2007
About Me
- Name: Thomas Kyte
- Location: Round Hill, Virginia
The views expressed are my own and not necessarily those of Oracle and its affiliates. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine. I've been using Oracle since 1988. I've been working at Oracle since 1993 (version 7.0). I spend way too much time working on asktom.oracle.com...
Previous Posts
- 1TB
- Version 42 has gone production...
- How not to ask 20 questions...
- How not to ask a question...
- Share and Share alike...
- Sharing SQL...
- A quick Advert...
- A reader asks...
- Why understanding...
- What is old is new again...
9 Comments:
what version of oracle can one use this? Regex in database. Sounds great..mm
Regular expressions are a 10g new feature.
What is this obfuscated SQL context? What is wrong with
select EMPNO||';'||DEPTNO||';'||JOB||';'||MGR||';'||HIREDATE||';'||SAL
from emp
This comment has been removed by the author.
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.
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.
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
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
Your post's very good. I like it.
-----------------------
Vietnam travel agency
Vietnam travel
Vietnam holiday
Vietnam tour
Vietnam tour operator
POST A COMMENT
<< Home