This week's book giveaway is in the Java in General forum.
We're giving away four copies of Think Java: How to Think Like a Computer Scientist and have Allen B. Downey & Chris Mayfield on-line!
See this thread for details.
Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General 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