Skip to Main Content

Analytics Software

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Prompt values from a SQL as well as a custom value

Hem31Feb 3 2010 — edited Feb 4 2010
Hi,

We have a requirement to put a prompt on State code. We have a master table for State codes. But in Transaction table (which is used in the report column) will have an extra value of State code which will not be in the master table. We want to show all state codes and this extra value in the prompt. How can I do that?

I can not use the transaction table as a prompt source as it may not have all states.

In short the prompt should show following results.

SELECT STATE_CODE FROM STATE_TABLE
+
Additional Values

Edited by: Hem31 on Feb 3, 2010 3:37 PM

Comments

Great article and project! I have a simple question. When you say:

Non-blocking request processing emerges as an effective way to address the problem. Instead of one blocking thread to handle one request, a small number of threads is used to handle a large number of requests asynchronously. This results in more efficient use of CPUs and better scalability, albeit at the cost of increased complexity.

Would you say then that we should not use server-side non-blocking processing if performance is not an issue? For the applications I work on, load is very predictable and low. It seems to me that in these cases the increased complexity is not worth it. (I contrast this to AJAX. AJAX enables web applications to do more work faster and responsively, but even if your web application has very little work to do, the user experience of AJAX applications is often superior to applications that do not use AJAX due to full page refreshes.)

Antón R. Yuste

Superb article, thanks!

user11017489

Thank you for this beautiful summary.

Re Lai-Oracle

Great article and project! I have a simple question. When you say:

Non-blocking request processing emerges as an effective way to address the problem. Instead of one blocking thread to handle one request, a small number of threads is used to handle a large number of requests asynchronously. This results in more efficient use of CPUs and better scalability, albeit at the cost of increased complexity.

Would you say then that we should not use server-side non-blocking processing if performance is not an issue? For the applications I work on, load is very predictable and low. It seems to me that in these cases the increased complexity is not worth it. (I contrast this to AJAX. AJAX enables web applications to do more work faster and responsively, but even if your web application has very little work to do, the user experience of AJAX applications is often superior to applications that do not use AJAX due to full page refreshes.)

Thank you. And yes, I'd think so. Asynchronous programming is harder to reason about.

lprimak

There is more hype in asynchronous / non-blocking programing than is proven by benchmarks or common sense:

Mohan Basavarajappa

Hi @"Yolande Poirier-Oracle"

informative article contributed. provides information on what all NIO frameworks are available and what is the high-level difference. More over it provides the advancements and where platform is headed. Nice samples too to get kick started with learning.

We are in the process of fixing the code layout. Sorry for the convenience.

Redfred Garett

Excellent article. Really very useful. Thanks !!!

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