Skip to Main Content

SQL & PL/SQL

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!

Queries have different plan with UNION

User505978 - OracleJun 5 2013 — edited Jun 6 2013
I have 2 query like this:

select * from emp where emp_no=2;

select * from emp where emp_no=3;

when i look at their execution plan seperately, it works fine and no problem but,

when i do this;

select * from emp where emp_no=2
union
select * from emp where emp_no=3;

i see different plan for both.

Is there a way to make use their own plan independently in union statement?

Comments

Rajagopalan-Oracle
Answer

Java JNLP is not certified / supported to work with Forms 10g --->
Forms 11.1.2.2 client and Java Web Start, JNLP (Doc ID 2081779.1)
Running the Oracle Forms applet via Java Web Start and/or JNLP is ** NOT ** supported in Forms 11.1.2.2. However, Web Start and/or JNLP is supported from Oracle Forms version 12.2.1.
More details about the 12.2.1 forms client deployment options can be found in Document:2066505.1

Marked as Answer by Suresh Sangaran-Oracle · Sep 27 2022
User_WPTHP

Thank you for your comments Sir.
I try to run my form in Java web start through JNLP File its works fine my form is running successfully but the report is not running, when on internet explorer i run my form and report both working fine but in JNLP File only forms work.

Jiju Mathew

I try to run my form in Java web start through JNLP File its works fine my form is running successfully but the report is not running, when on internet explorer i run my form and report both working fine but in JNLP File only forms work.

I also facing same issue. please help me.

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

Post Details

Locked on Jul 4 2013
Added on Jun 5 2013
13 comments
12,038 views