Skip to Main Content
Forums

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!

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.

Display output in horizontal rows

711216Dec 23 2009 — edited Dec 23 2009
Hello all,

Please help me how to display the out put of count of the below queries in horizontal rows.

select count(*) "test1" from oe_headers_all where customer_po_number like 'consign-%'

select count(*) "test2" from oe_headers_all where customer_po_number like 'non-consign-%'

select count(*) "test3" from oe_headers_all where customer_po_number like 'REGULAR%'

select count(*) "test4" from oe_headers_all where customer_po_number like 'NON-REGULAR%'


tes1 test2 test3 test4
---- ----- -------- ------
20 50 30 40

Regards,
Kiran

Comments

Holger.Lehmann

Yo mean to run the applet lke before? No.

why don't you use FSAL technology to run forms ?

Holger

Marwim

Because it is a lot of work. Not FSAL as such but:

The difference is between persuading an admin to change a setting and persuading many managers through different hierarchies that their staff has to test a new way to do the same thing.

Edit: And it's not about running an applet but Webstart.

Holger.Lehmann

hm, ok.

and what about downloading and saving the jnlp file to the client  once?

and executing with a double click.

I don't know any way to get it work with Edge, as it always asks to download it.

Marwim
Answer

I found a simpler solution:

instead of calling http://my_formsserver/...config=xy you can call jnlp://my_formsserver/...config=xy

Edge chrome will warn you that a website wants to open Web Launcher. If you accept it will run like before.

Marked as Answer by Marwim · Sep 27 2020
1 person found this helpful
Holger.Lehmann

I think in newer Java version this solution won't work anymore because of desupport of Java Web Start.

and what then ?

Michael Ferrante-Oracle

The JNLP and JNLPS protocols, which are configured when the JRE is installed on Windows automatically are planned to be supported through the life of Java 8 along with Java Web Start.  Currently, JWS is planned to be supported at least until 2030.

Here are some helpful references:

https://www.oracle.com/java/technologies/java-se-support-roadmap.html

https://docs.oracle.com/javase/8/docs/technotes/guides/javaws/developersguide/setup.html

(Java 10 Guide, but this applies to Java 8 too):

https://docs.oracle.com/javase/10/deploy/overview.htm#JSDPG-GUID-E2442793-A04A-4F07-8BFB-50A6E983F78A

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

Post Details

Locked on Jan 20 2010
Added on Dec 23 2009
12 comments
1,512 views