Advertisement

06.11.2007 at 06:15AM PDT, ID: 22625799
[x]
Attachment Details

Oracle 9i - SQL query - Alpha Numeric string manipulation

Asked by philsivyer in Oracle 9.x

Tags: oracle, sql, string, query, 9i

I posted this query earlier concerning sql server - then realised I also need it for Oracle
I need to manipulate numbers in a string - for example my table would be as follows:
col_1    
VOL 6 ISS 2
VOL7 ISS 11
VOL 446 ISS 8
VOL 446 ISS 14
My result set following the query would need to read as follows
col_1
602
711
44608
44614
Note that any numbers less than 10 after the ISS part of the string needs a 0 inserted
Any help much appreciatedStart Free Trial
[+][-]06.11.2007 at 06:37AM PDT, ID: 19257953

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.11.2007 at 06:50AM PDT, ID: 19258046

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.11.2007 at 07:13AM PDT, ID: 19258240

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.11.2007 at 07:15AM PDT, ID: 19258266

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.11.2007 at 07:19AM PDT, ID: 19258297

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle 9.x
Tags: oracle, sql, string, query, 9i
Sign Up Now!
Solution Provided By: jwahl
Participating Experts: 3
Solution Grade: A
 
 
[+][-]06.11.2007 at 07:23AM PDT, ID: 19258332

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2007 at 12:54AM PDT, ID: 19264260

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2007 at 01:04AM PDT, ID: 19264295

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.12.2007 at 05:09AM PDT, ID: 19265322

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.12.2007 at 05:14AM PDT, ID: 19265342

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32