Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Query builder

2635274May 5 2014 — edited May 5 2014

Hi,

I'm using Jdev version 11g

I need to design UI for a query builder in ADF. Sort of like the query UI in a view object. The tables of the Database should come in a drop down box and their columns in another drop down box whenever a table is selected. These columns should add to the select box in the UI.

I've started to build version 1 of it in which I'm testing with 2 tables and their columns. It's just a simple UI with Select, From and Where text boxes where in the column names can be dragged and dropped/ or the selected column names from the drop down list box be added in the select box automatically.

Any pointers to any helpful source on how to go about building this interface or some hints on what things to keep in mind while building this would be very helpful.

Thanks in advance!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 2 2014
Added on May 5 2014
1 comment
263 views