aspose file tools*
The moose likes Oracle/OAS and the fly likes sql query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "sql query" Watch "sql query" New topic
Author

sql query

phani ravinutala
Greenhorn

Joined: Jun 25, 2009
Posts: 26
hi all,


I need help for querying the bleow data

table 1: column: price_rs

price_rs
cd:435
cd:425
cd:465


table 2: column: error, message



Can anyone help me to query for the below data?

I want to display the data like below


thanks,
anvi


Sridhar Gudipalli
Ranch Hand

Joined: Nov 02, 2005
Posts: 120
What is the relationship between these two tables? No primary key/foreign key relationship?
How the rows are guaranteed to be unique??


Sridhar Gudipalli|SCJP 6.0
SCWCD objectives
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30938
    
158

Kal,
The first thing is to figure out what to join on. It looks like that would be the number. Can you find the Oracle functions to convert "cd:XXX" into a number? (hint: substring and to number)


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
 
subject: sql query