Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Extracting table from Oracle database

 
Raju Venuturupalle
Greenhorn
Posts: 5
  • 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
  • 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
  • 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic