Questions tagged as 'oracle'

Tagged questions
1
answer

"is not a jdk java home valid"

I'm trying to install weblogic 12c from a .jar. I run the command java -jar wls_121200.jar , but the CMD returns me    This installer should be run using the Java Development Kit (JDK),       however, C: \ Program Files \ Java \ jre1...
asked by 12.05.2017 / 19:49
0
answers

Add column to SQL considering some conditions to be valid

I'm trying to put together two pieces of information and I'm not getting it. I set up this SQL to bring me only the products that were purchased that had a discount through a contract. But this discount was registered for the product categori...
asked by 19.06.2017 / 22:59
1
answer

Integrate WordPress with Oracle

I will develop an "E-Commerce" service in WordPress, known as WooCommerce, but I need to integrate it with Oracle, in addition to the MySQL itself that it will run ... Example: When someone hires a service, I need them to send some informatio...
asked by 24.05.2017 / 17:16
1
answer

Authenticated Users

How do I add (authenticated users) back to the GROUP OR USER NAMES in the Security tab in a given folder?     
asked by 10.05.2017 / 16:32
1
answer

How to return zero, when JOIN does not bring me a value?

I have a problem with this SQL, when I need to list a move but the code has not yet been written. There when you fall into this JOIN AND A.NCODIMVEPI = E.NCODIMVEPI .and JOIN AND D.NCODIEQEPI = E.NCODIEQEPI . I do not have it,...
asked by 18.04.2017 / 14:44
0
answers

Value shown in production other than development

I have an application in ASP.NET MVC with the Entity Framework with an Oracle database, and it is showing some wrong data, and this happens only in production, in Debug (locally) the data is brought right . This data is written from another s...
asked by 05.04.2017 / 14:38
0
answers

Conversion from LONG RAW to BLOB in Oracle

I tried to use TO_LOB to convert the value LONG RAW to insert but it returns:    ORA-00932 inconsistent datatypes tips The destination is a column BLOB of a table already in use of the system, and its type can...
asked by 04.04.2017 / 21:14
0
answers

replace null with previous value in oracle

I want to make a replace of a null value by the last value before that null or null. Using LAG in cases where I have 2 nulls or more only does the replace in the first null. COL1 is the key, COL2 is the original value, and COL3 is the expe...
asked by 11.04.2017 / 20:45
2
answers

Add a column with the row number in the select result

How can I add the row number of the select result to an additional column? For example: select e.ds_estados from estados e This select would return me the registered states AC AL AM ... TO I would like next t...
asked by 24.03.2017 / 20:09
1
answer

I can not start the oracle listener

I'm trying to install Oracle on a linux machine to be accessed in cobol. Sqlplus is working, I can execute sql commands. When trying to start the oracle listener, I'm getting the error:    Message 1070 not found; In the message file for pr...
asked by 23.03.2017 / 11:49