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!

How to "where any of(b,c,d,e,f,g,h..) is null" with SQL(not PL/SQL)

426850Sep 7 2007 — edited Sep 8 2007
With the combinations of case, decode and coalesce function this can be done via pl/sql function, but is it possible to do it with SQL(any similar operator for this need I mean).

This need is because this is a report and the data processed is large so if this can be done within SQL engine it may help with performance.

Best regards.

Comments

Whether you are installing in a vm or a native environment, the requirements will be the same. I recommend using a static address and ensuring it is noted in the hosts file. For example: 
127.0.0.1  localhost
192.168.0.100   myvmbox
I also recommend carefully reviewing the Sys Requirements doc as it covers most of the "gotcha" topics.

http://docs.oracle.com/html/E25460_01/r2_fr_requirements.htm

Without the complete failure information, it is difficult to offer more than that. Also, note that VirtualBox is not a supported vm environment. Take a look at the following:

http://www.oracle.com/technetwork/middleware/ias/oracleas-supported-virtualization-089265.html
978099
Thanks for the response. I'll check the links. Last configuration attempt failed with the following details from the out log under oraInventory:

opmnctl start: failed.
java.lang.Exception: oracle.as.provisioning.exception.ASProvisioningException
at oracle.as.install.classic.ca.standard.InstanceProvisioningTask.doExecute(InstanceProvisioningTask.java:222)
at oracle.as.install.classic.ca.standard.StandaloneTool.execute(StandaloneTool.java:50)
at oracle.as.install.classic.ca.standard.StandardProvisionTaskList.execute(StandardProvisionTaskList.java:61)
at oracle.as.install.classic.ca.ClassicConfigMain.doExecute(ClassicConfigMain.java:124)
at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:339)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:87)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:104)
at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)
at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:63)
at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:158)
at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:81)
at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:83)
at java.lang.Thread.run(Thread.java:662)
Caused by: oracle.as.provisioning.exception.ASProvisioningException
at oracle.as.provisioning.engine.Config.executeConfigWorkflow_WLS(Config.java:872)
at oracle.as.install.classic.ca.standard.InstanceProvisioningTask.doExecute(InstanceProvisioningTask.java:218)
... 12 more
Caused by: oracle.as.provisioning.engine.CfgWorkflowException
at oracle.as.provisioning.engine.Engine.processEventResponse(Engine.java:596)
at oracle.as.provisioning.fmwadmin.ASInstanceProv.createInstance(ASInstanceProv.java:178)
at oracle.as.provisioning.fmwadmin.ASInstanceProv.createInstanceAndComponents(ASInstanceProv.java:116)
at oracle.as.provisioning.engine.WorkFlowExecutor._createASInstancesAndComponents(WorkFlowExecutor.java:523)
at oracle.as.provisioning.engine.WorkFlowExecutor.executeWLSWorkFlow(WorkFlowExecutor.java:439)
at oracle.as.provisioning.engine.Config.executeConfigWorkflow_WLS(Config.java:866)
... 13 more
Caused by: oracle.as.provisioning.util.ConfigException:
Error creating ASInstance asinst_1.
Cause:
An internal operation has failed: Error in starting opmn server
Operation aborted because of a system call failure or internal error
There are a few known issues that might cause this error:

1. TMP not accessible or not enough space
2. Machine not configured with static IP address or address already in use on network
3. Invalid or missing hostname or hostname already in use on network
978099
Thanks again for response . Hosts file currently looks like this:
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.0.198 ol6-forms.localdomain ol6-forms

The ol6-forms entry is an additional host entry and doesn't really appear to serve any purpose. The hostname is set to localhost.localdomain. The /etc/resolv.conf has the following entries:
; generated by /sbin/dhclient-script
search group.net
nameserver 172.20.142.1
nameserver 172.20.56.13
nameserver 172.20.24.13
nameserver 172.20.11.18
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 6 2007
Added on Sep 7 2007
23 comments
5,434 views