Skip to Main Content
Forums

Oracle Database Discussions

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.

How to convert sql query to oracle query?

955649Sep 13 2012 — edited Sep 13 2012
Hi all,

Hope doing well,

sir i am using oracle database where i am running my sql query in oracle. but this query is not working properly. i used sql developer translation scratch editor to convert that.
it's converted but i am not getting the exact value.
which i was getting in sql server.

here is my query below:

SELECT C.*,ISNULL(P.Comp_Name,'') + ' (' + ISNULL(P.Comp_ID,'') + ')' Parent FROM Comp_Master C LEFT JOIN Comp_Master P ON C.Parent_ID = P.Comp_ID Where C.Comp_ID='C02'

please convert it into oracle so that i can use this query

thanks in advance.

Comments

If you have installed the siebel-determinations-server that comes with OPA Connector for Siebel 10.3 You should be able to see the assessio service and the wsdl from the home page of the siebel-determinations-server. An assessio service is started for each rulebase deployed to the determinations server and the siebel-determinations-server web app comes with the AdminSmokeTest rulebase installed.

The URL for the "Home" page of siebel-determiantions-server is:

http://<server and port>/siebel-determinations-server

And the page should display something like below (you can see the assessio service as the last service in AdminSmokeTest)

>
Server
•/siebel-determinations-server/server/soap?wsdl
•/siebel-determinations-server/server/soap/10.2?wsdl
•/siebel-determinations-server/server/soap/10.0?wsdl


AdminSmokeTest
•/siebel-determinations-server/interview/soap/AdminSmokeTest?wsdl
•/siebel-determinations-server/interview/soap/10.2/AdminSmokeTest?wsdl
•/siebel-determinations-server/assess/soap/specific/AdminSmokeTest?wsdl
•/siebel-determinations-server/assess/soap/generic/AdminSmokeTest?wsdl
•/siebel-determinations-server/assess/soap/specific/10.3/AdminSmokeTest?wsdl
•/siebel-determinations-server/assess/soap/generic/10.3/AdminSmokeTest?wsdl
•/siebel-determinations-server/assess/soap/specific/10.2/AdminSmokeTest?wsdl
•/siebel-determinations-server/assess/soap/generic/10.2/AdminSmokeTest?wsdl
•/siebel-determinations-server/assess/soap/specific/10.0/AdminSmokeTest?wsdl
•/siebel-determinations-server/assess/soap/generic/10.0/AdminSmokeTest?wsdl
•/siebel-determinations-server/assessio/soap/AdminSmokeTest?wsdl
1 person found this helpful
902467
I deployed D:\Oracle\Policy Automation - Siebel\Determinations Server\Java\siebel-determinations-server.war in weblogic server. In WSDL file, I am getting the following:

Server
/siebel-determinations-server/server/soap?wsdl
/siebel-determinations-server/server/soap/10.2?wsdl
/siebel-determinations-server/server/soap/10.0?wsdl

AdminSmokeTest
/siebel-determinations-server/interview/soap/AdminSmokeTest?wsdl
/siebel-determinations-server/interview/soap/10.2/AdminSmokeTest?wsdl
/siebel-determinations-server/assess/soap/specific/AdminSmokeTest?wsdl
/siebel-determinations-server/assess/soap/generic/AdminSmokeTest?wsdl
/siebel-determinations-server/assess/soap/specific/10.3/AdminSmokeTest?wsdl
/siebel-determinations-server/assess/soap/generic/10.3/AdminSmokeTest?wsdl
/siebel-determinations-server/assess/soap/specific/10.2/AdminSmokeTest?wsdl
/siebel-determinations-server/assess/soap/generic/10.2/AdminSmokeTest?wsdl
/siebel-determinations-server/assess/soap/specific/10.0/AdminSmokeTest?wsdl
/siebel-determinations-server/assess/soap/generic/10.0/AdminSmokeTest?wsdl

AdminSmokeTestIO
/siebel-determinations-server/interview/soap/AdminSmokeTestIO?wsdl
/siebel-determinations-server/interview/soap/10.2/AdminSmokeTestIO?wsdl
/siebel-determinations-server/assess/soap/specific/AdminSmokeTestIO?wsdl
/siebel-determinations-server/assess/soap/generic/AdminSmokeTestIO?wsdl
/siebel-determinations-server/assess/soap/specific/10.3/AdminSmokeTestIO?wsdl
/siebel-determinations-server/assess/soap/generic/10.3/AdminSmokeTestIO?wsdl
/siebel-determinations-server/assess/soap/specific/10.2/AdminSmokeTestIO?wsdl
/siebel-determinations-server/assess/soap/generic/10.2/AdminSmokeTestIO?wsdl
/siebel-determinations-server/assess/soap/specific/10.0/AdminSmokeTestIO?wsdl
/siebel-determinations-server/assess/soap/generic/10.0/AdminSmokeTestIO?wsdl


I am not getting /siebel-determinations-server/assessio/soap/AdminSmokeTest?wsdl. is there configuration need to be done to get assessio? Please let me know how to do get assessio for custom projects?

I have developed the project named "custodyOPA" by importing Siebel Data Model and when I build using Oracle Determination Server, I am getting the following. How to get assessio for this project to integrate with Siebel.

Server
/determinations-server9000/server/soap?wsdl
/determinations-server9000/server/soap/10.2?wsdl
/determinations-server9000/server/soap/10.0?wsdl
custodyOPA
/determinations-server9000/interview/soap/custodyOPA?wsdl
/determinations-server9000/interview/soap/10.2/custodyOPA?wsdl
/determinations-server9000/assess/soap/generic/custodyOPA?wsdl
/determinations-server9000/assess/soap/generic/10.3/custodyOPA?wsdl
/determinations-server9000/assess/soap/generic/10.2/custodyOPA?wsdl
/determinations-server9000/assess/soap/generic/10.0/custodyOPA?wsdl
1 person found this helpful
907968
Could someone please respond to this? We have the same problem.
Answer
There's some quick reconfiguration that needs to be done to get siebel-determinations-server running on WebLogic.

Unfortunately, this seems to have missed the documentation.

Here's what you need to do:

1. Unzip siebel-determinations-server.war file

2. Edit the file WEB-INF/classes/config/application.properties:

At about Line 40, you will see a line that says

"plugin.libraries = "

Change that so that the line is (one line, no breaks):
plugin.libraries=com.oracle.determinations.server.plugins.IntegratedObjectCustomServicePlugin;com.oracle.determinations.bplan.BPlanReturnResultEventHandler
3. Locate the file: bplan_ds_eventhandler.jar and io-custom-service.jar in the directory io-custom-service.jar WEB-INF/classes/plugins

4. Move these files from WEB-INF/classes/plugins to WEB-INF/lib

5. Re-zip the the web application to siebel-determinations-server.war (be careful not to include any extra directories, WEB-INF and META-INF should be at the top level of the .war file).

Cheers
Frank
Marked as Answer by 902467 · Sep 27 2020
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 11 2012
Added on Sep 13 2012
#11g, #general-database-discussions
2 comments
3,117 views