• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Complex SQL Statements

 
Steve Dyke
Ranch Hand
Posts: 1616
1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 20493
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is your database? Oracle has stored functions that can be used in queries.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic