Skip to Main Content

SQL Developer

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 Developer: Input parameters dialog

2933482Apr 20 2015 — edited Apr 20 2015

Hello!

For different purposes I need to use any well-known tool to explain some details to our students about particular DB structure. It should be preferably free tool, like SQL Developer.

This tool has a lot of facilities, and that's why I try to adapt it for my needs.

When we input queries with parameters, SQLDeveloper asks us to input them by meaning of standard input dialog. (I mean "where field=:parameter" syntax).

Is it possible to modify this dialog by creating an extension or by configuring smth in SQLDeveloper?

My goal is to prepare training work place for students. They have to study particular queries to our database. I want to give them comfortable tool which will allow them to be focused on the query, not on additional tasks like UI.

Built-in dialog is good, but I prefer to amend it. For example, may be it is better to create calendar for inputing dates, and so on. If SQL Developer had any abilities to do that, it would be very fine.

Comments

Matej D.

Did you install full stack or just forms builder?

Regards

Dan Andro-Oracle

Hi,

Report builder is not available there. If you followed the steps from Oracle Reports 12c: First Step to Complete After a New Forms/Reports 12c Install and Configuration Environment(Doc ID 2072671.1), then you can start the reports builder by running the rwbuilder.bat file from DOMAIN_HOME/reports/bin.

Regards,

Dan

User_PWYH0

Hi
What is the new features built in Oracle Report 12C instead of 11G?

User_4BUV0

i opened rwbuilder.bat from the domain but they gave me the cmd screen with below message:

starting report 12c builder…

the input line is too long .

the systax of the command is incorrect.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 18 2015
Added on Apr 20 2015
0 comments
329 views