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

LeightonLNelson
Hi,
First I recommend to remove your hostname information from the output of your post.
From the output it seems to indicate that your OMS is down. Could you please verify that the OMS in question is up using emctl status oms.
What command did you use to remove the plug-in? Does emcli list_plugins_on_server show the deployed plug-in?

Thanks,
Leighton
EdSpn
Hi Leighton,

Thanks for the feedback. I just checked status oms and it seems fine:
[oracle@dwbi-durl-oel agent_inst]$ $OMS_HOME/bin/emctl status oms
Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
WebTier is Up
Oracle Management Server is Up
Yes, my plugin is still listed. I always use the following commands to undeploy:
emcli delete_target -name="$TARGET_NAME"    -type="$TARGET_TYPE_NAME"
emcli undeploy_plugin_from_agent  -plugin="$PLUGINID" -agent_names="$AGENT_NAME"
emcli undeploy_plugin_from_server -plugin="$PLUGINID" -sys_password="$SYSPWD"
I think the issue may be caused by another plugin. Will dig further.

Thanks,
Ed

PS That hostname slipped through into the post. Just removed it :)
EdSpn
To complete the thread:

I have found the offending plugin, and undeployed it (using the OEM UI in browser).
After this, the issue was resolved, and I could successfully undeploy my own plugin.

Regards,
Ed
Which plugin did you undeployed ?
EdSpn
It was not an Oracle provided plugin, but one of our own.
1 - 5
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,823 views