wood burning stoves*
The moose likes JDBC and the fly likes Complex SQL Statements Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Complex SQL Statements" Watch "Complex SQL Statements" New topic

Complex SQL Statements

Steve Dyke
Ranch Hand

Joined: Nov 16, 2004
Posts: 1393
I have a report using jasperreports(itext)

Is there any way to have a function in the SQL statement as a column and have that function run a seperate SQL statement?

Somthing like "Select f1, myfunction(f1) As f2 From mytable"
Rob Spoor

Joined: Oct 27, 2005
Posts: 19651

I have done similar things quite often:
Of course this function can have only a single row in the result set.

Moving to the JDBC forum.

How To Ask Questions How To Answer Questions
Jan Cumps

Joined: Dec 20, 2006
Posts: 2491

What is your database? Oracle has stored functions that can be used in queries.

OCUP UML fundamental and ITIL foundation
youtube channel
subject: Complex SQL Statements
Similar Threads
Issue with float to binary
sql query error
increment field...
how to return the index by variable from pl/sql to java
access control