File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Extracting table from Oracle database