Questions tagged as 'oracle-11g'

Tagged questions
2
answers

no How to get the last value inserted in the BD Oraclexe?

I am working in JEE, with WebLogic and OracleXE as a database engine, I am using a DataSource (NO JPA), in this database you have to create sequences to generate autoincremental values, I already did it and it works well when I execute it becaus...
asked by 31.10.2017 / 14:31
1
answer

Status: Failure: Failure to test: I / O error: The Network Adapter could not establish the connection

I just installed Oracle Database 12c Release 2 (12.2.0.1.0) on my pc with windows 10. The problem is that I can not create a connection from the Oracle SQL Developer and the message appears in red (see image). When testing the connectiv...
asked by 16.09.2017 / 08:19
0
answers

How to use an Oracle function from PHP?

Cordial Greeting. I am working on Oracle 11G from PHP and it is necessary to use some functions of ORACLE from PHP and since I am passing more than 1 query at the same time to use INSERT ALL I am sending the data in an array and using the fun...
asked by 11.07.2017 / 23:02
2
answers

Problem with the Group by help?

SELECT VENDEDOR.ID_VENDEDOR, CASE WHEN TO_CHAR(BOLETA.FECHA_BOLETA,'MM/YYYY')='05/2014' THEN SUM(COMISION_VENTAS.VALOR_COMISION_BOLETA) ELSE 0 END "COMISION" FROM VENDEDOR JOIN BOLETA ON BOLETA.ID_VENDEDOR=VENDEDOR.ID_VENDEDOR JOIN COMISI...
asked by 25.06.2017 / 04:14
0
answers

Why do not they upload the data from the BD with JSP?

I have this singleton class of connection to an Oracle Database 11g express edition database: public class ConexionDB { private static ConexionDB _conexion; private Connection connection; /** * */ private ConexionD...
asked by 30.04.2017 / 01:50
2
answers

Error "not a valid month" SQL

Good afternoon; I'm doing an exercise for my Database course, they passed us a script to create the tables and do the inserts of the elements (I use the Oracle Application Express). But when executing any insert I get the following error:...
asked by 20.04.2017 / 19:41
1
answer

sqlplus get a TXT file to import using spool

I'm working with Oracle Database and I need to create a script that will generate an import file in TXT format. I'm using sqlplus and the spool command to save the queries but for more than try I can not accommodate the data: What I need is:...
asked by 28.03.2017 / 20:33
1
answer

Store Select procedure in Oracle can not find data

I have the following code in Oracle: CREATE OR REPLACE PROCEDURE STOREDSUBMODULOS(IDCATMODULO IN NUMBER , IDCATSUBMODULO OUT NUMBER , CLAVESUBMODULO OUT VARCHAR2 , DESCRIP OUT VARCHAR2) AS BEGIN SELECT ID_CAT_SUBMODULO , CLAV...
asked by 10.03.2017 / 19:07
1
answer

Help with Oracle SQL query 11g

I need to make two queries in sql, but I'm stuck in one part, I explain. The first query asks me the following:    You want to know by customer: The total of invoices made in the month, the total value of purchases made in the month, the v...
asked by 20.04.2017 / 03:49
1
answer

Export packages with "dbms_metadata.get_ddl"

I am exporting packages using dbms_metadata.get_ddl . For example: select dbms_metadata.get_ddl('PACKAGE_BODY','NOMBRE_PAQ','SCHEMA_NA‌​ME') from dual; But when generating the spool with the package code, a blank line is generated bef...
asked by 28.11.2016 / 16:15