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

Extracting table from Oracle database

Raju Venuturupalle
Greenhorn

Joined: Mar 29, 2001
Posts: 5
Hi all
I am extracting a table from oracle database and displaying on a JSP. I am successful in doing this.
My problem is I want to extract only some particular columns on to the jsp.
Can anybody give me a solution to this.
Rgds
Raju
Suresh Selvaraj
Ranch Hand

Joined: Nov 14, 2000
Posts: 104
Hi,
You may refer to one of my previous posts.
Change the '*' in the select statement to whatever columns you need to extract from the table.
Ex: Select col1, col3, col5, col9 from .....
http://www.javaranch.com/ubb/Forum3/HTML/000712.html
Hope this helps.
-
Suresh Selvaraj


Suresh Selvaraj, (author of JQuiz)<br />SCJP2<br /><a href="http://www.decontconsulting.com" target="_blank" rel="nofollow">www.decontconsulting.com</a>
Raju Venuturupalle
Greenhorn

Joined: Mar 29, 2001
Posts: 5
Hi Suresh
thanx for ur response.
But I do not know thw column names as the table is being generated at dynamically.
there are different column names in different tables.
Pl. assist.
Rgds
Raju
 
Consider Paul's rocket mass heater.
 
subject: Extracting table from Oracle database