wood burning stoves 2.0*
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Extracting table from Oracle database
 
Similar Threads
display records page by page
tomcat and oracle 8i.
How to Print Serial number on jsp?
File instead of Database table
File instead of Database table