Questions tagged as 'oracle-10g'

Tagged questions
1
answer

Error ORA-06502: PL / SQL

I have the following procedure: CREATE or REPLACE PROCEDURE QUERY_EMP (id IN emp.empno%TYPE, salario OUT emp.sal%TYPE, puesto OUT emp.job%TYPE) IS BEGIN SELECT job, sal INTO salario, puesto FROM emp WHERE empno = id; END QUERY_EMP;...
asked by 08.05.2018 / 20:52
1
answer

Because length returns the value of the mask and not the actual result?

I was trying to make a pad to the left of spaces to a number, so that in my view they were all formatted (in the view they can not be formatted). When I try the function that follows: LENGTH (TO_CHAR(a.variacion*100,'999990.99')) oh by c...
asked by 14.07.2017 / 20:44
1
answer

Map ORACLE SP that returns a cursor

Please, I need your help to finish building an architecture. What I want to do is the following: Create the ORACLE SP the CRUD, everything is easy, the main problem I have is that for the select I do something like: CREATE OR REPLACE PROCED...
asked by 16.03.2016 / 22:53
1
answer

How to execute this query in Oracle 10g?

I have this query SELECT EMPNO, ENAME, HIREDATE, DEPTNO, ROWNUM AS rn FROM (SELECT EMPNO, ENAME, HIREDATE, DEPTNO FROM EMP ORDER BY HIREDATE DESC) WHERE rn < 3 but the error is:    ORA-00904: "RN": invalid identifier   00904. 00000 -...
asked by 01.11.2017 / 06:56
1
answer

QuerySyntaxException: unexpected token: ON

When I run a query with the entity manager entityMan.createQuery(str.toString()).getResultList().size(); I get a syntax error org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ON near line 1, column 534 [select catfiguras.FIG...
asked by 05.12.2015 / 04:03
1
answer

Sum of rows in Oracle PL / SQL

I want to add these two amounts but I get two different rows because they are unequal the amount should give me "2231" and a single row: MONTO NAC CEDULA CODIGO SUBCODIGO FISCAL FECHA 1673,25 V 8018573 28 50 2017 11/05/17 557...
asked by 13.09.2017 / 00:28
1
answer

Call Oracle data to a NetBeans Table [closed]

I would like help on this topic, because I really do not know how to do it. My question is, I have a form in my NetBeans and when I click on the button I should pull the data that I have in my Oracle and show them in the table I have there .....
asked by 29.09.2018 / 19:30
1
answer

Fatal error: Uncaught Error: Call to undefined function oci_connect () in C

Greetings! I was working with PHP Version 5.4.3 connected 2 Databases (Oracle Database version 10g Enterprise Edition Release 10.2.0.5.0 - 64bit) (version Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit) When I upgrade to PH...
asked by 22.01.2018 / 22:26
1
answer

Error activating Oracle Flashback

I am trying to enable Oracle Flashback in an Oracle 10g database that I have mounted on a virtual machine (which has Windows XP). This is my script: --chechar si estan habilitados los respaldos flashback SELECT FLASHBACK_ON FROM V$DA...
asked by 13.07.2017 / 18:43
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