Hi everyone.

I have a rather complex Oracle-based SQL query, with a Union in it and many subqueries and conversions for output and readability, and so it's rather huge, so I won't even post it here.

It includes 4 tables all inner joined together (although a 5th one (actually a view) is used in several subqueries), and it has 6 variables that the user is asked to define as a set of search criteria.

e.g. User opens client, opens this big script, executes it ("PL/SQL Developer" then opens a mask asking for all variables to be filled out, or some of them). And then the result frame of the client program shows the listing as queried for.

Up to now everyone was simply running it inside of this developer client.
So now, I want to transfer this query into JDeveloper, to make an actual application out of it, utilizing JSF or JSP.

I tried using one of their (Oracle's) tutorials, but these are trimmed for simple 2-table queries, without any extra hoo-haa, like what I have.

Ideally I would like to just define my query as an existing view, or something pre-defined, that JDeveloper just needs to execute and I define which result column goes into which JSF widget, for example.

Does anyone know how to do that? Or maybe, where I can find an explanation on any of the clever Oracle/Java interwebs?