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!

Multi-Rows from DUAL

Gerd VolbergApr 3 2007 — edited Nov 19 2010
I need an easy select from DUAL, which gives me more than one row.

e.g. 1000 rows or 4500 rows....


I know that one of the best solutions was something with an CONNECT BY PRIOR and a WHERE ROWNUM <= 1000 e.g.


But what was the complete statement?

thx 4 solutions
Gerd

Comments

Unfortunately Java ME SDK 3.2 is not publicaly available now. Could you please help me to understend why are you asking for such an old version so I might be able to suggest you an alternative solution? What a use case do you have?

gdillen

Hi,

Sorry for the late answer.

Java ME SDK 3.2 is needed to build Eclipse PAHO MQTT library (org.eclipse.paho.mqtt.java.git - MQTT Client Package - Java Language).

From the README file:

Paho Java ME client for MQTT

The Java ME client requires the Oracle J2ME SDK 3.2 (which is only available for windows) and assumes it will be installed in c:/Java_ME_platform_SDK_3.2/

The client jar is built using ant and the build.xml file in org.eclipse.paho.jmeclient.mqttv3/

Sergey.N-Oracle

Hi!

J2ME SDK3.4 is good choice to substitute SDK3.2 without any source and binaries update

/Sergey

gdillen

Hi,

I asked the guys from Eclipse PAHO: Java ME SDK 3.2 is a requirement!

thanks.

Guy

Sergey.N-Oracle

Didn't try to build but reference to SDK3.2 and its library is placed at root/org.eclipse.paho.jmeclient/org.eclipse.paho.jmeclient.mqttv3/build.xml

<path id="lib.path.ref">
<fileset dir="c:/Java_ME_platform_SDK_3.2/lib">
<include name="**/cldc_1.1.jar" />
<include name="**/jsr75_1.0.jar" />
<include name="**/jsr120_1.1.jar" />
<include name="**/jsr172_1.0.jar" />
<include name="**/jsr177_1.0.jar" />
<include name="**/jsr179_1.0.jar" />
<include name="**/jsr280_1.0.jar" />
<include name="**/impng_1.0.jar" />
</fileset>
</path>

Please substitute SDK_3.2 with SDK_3.4

gdillen

Thanks.

I know and I already changed and tried (a while ago) by changing v3.2 in v3.4 in the build.xml; but that doesn't work unfortunately.

Thanks.

Guy

Sergey.N-Oracle

Hi!

May I ask to show error log?

/Sergey

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

Post Details

Locked on Dec 17 2010
Added on Apr 3 2007
49 comments
57,841 views