File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Extracting table from Oracle database

 
Raju Venuturupalle
Greenhorn
Posts: 5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 104
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Raju Venuturupalle
Greenhorn
Posts: 5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic