Questions tagged as 'oracle-11g'

Tagged questions
2
answers

Put a sum in the filters of a SQL query?

Good morning, I'm scheduling this query: SELECT t1.percod permisor, t1.pernom ciudad, t2.abocod cod_abonado, t2.abonom1 nombre, t2.aboape1 apellido, t2.abosts, t2.abocmsts, t2.abotlfsts, t2.aboipsts, t3.recicod, t3.recifch...
asked by 02.02.2017 / 14:13
2
answers

How to select 1 date field with 3 tags in Oracle SQL?

I'm doing query in oracle 11g and they ask me to select the last 3 dates when a client paid invoice. The query I have it like this: SELECT t1.datefield date_1, t1.datefield date_2, t1.datefield date_3 FROM ta...
asked by 28.10.2016 / 15:52
1
answer

Create a stored procedure without parameters in ORACLE

I am new to this database engine, I believe that I create a store procedure and when I create it, there is no problem, but when I run it I get this: ORA-06550: line 2, column 3: PLS-00905: object WEB_SEGURIDAD.SIMEXA_SP_DEPARTAMENTOS_UBIGEO is...
asked by 10.12.2018 / 22:57
2
answers

how to call a name with duplicate condition Oracle sql?

I am a bit confused when trying to construct a query that brings the Names (from the ENAME column) of all the employees (from the employees table) that were not registered in the JAVA course (from the table registrations). the column attendee is...
asked by 29.06.2018 / 00:18
1
answer

How to include sequence in WebService Restful

I have created a database in Oracle 11G , where there is a sequence to make the autoincrementable records: CREATE SEQUENCE S_CATEGORIA MINVALUE 1 START WITH 1 INCREMENT BY 1 NOCACHE; Through a webservice I need to save a new record to...
asked by 11.04.2018 / 22:54
1
answer

Subtraction of dates in Oracle

Today working with dates in Oracle, perform a subtraction of date with the following query: SELECT TO_DATE(SYSDATE, 'DD/MM/YYYY') AS HOY, TO_DATE(T.FECHAEVAL, 'DD/MM/YYYY') AS FECHA, TO_DATE(SYSDATE, 'DD/MM/YYYY') - TO_DATE(T.FEC...
asked by 22.03.2018 / 20:26
1
answer

THE ERROR "It was not expected / BIOCaptureFinger at this time." WHAT DO YOU NEED?

I am using the WebLogic server in JavaEE, specifically WebLogic 11gR1, I can raise the administration page of WebLogic "localhost: 7001 / console", but when I turn off and turn on the PC I can not access the domain I had created, I see the follo...
asked by 01.10.2017 / 23:41
2
answers

Return a data from a stored procedure in Oracle

I have this stored procedure: create or replace procedure spu_modificarTrabajador ( tnombre varchar2, tapellido varchar2, tid_cargo number, tdireccion varchar2, trut varchar2,tsueldo number, tcorreo varchar2, tcomuna number) is begin updat...
asked by 02.07.2017 / 08:52
1
answer

Force the character set by running a script via sqlplus

I have a macro in Excel that generates a flat SQL file with INSERT statements to be executed from an Oracle Forms form, by means of an invocation to sqlplus. I am the developer and in my team everything works correctly, but the people who use th...
asked by 30.03.2017 / 19:21
1
answer

Oracle.DataAccess DLL error

I am using the dll Oracle.DataAcess and I have the following error: Error de servidor en la aplicación '/'. No se puede cargar el archivo o ensamblado 'Oracle.DataAccess' ni una de sus dependencias. Se ha intentado cargar un programa con...
asked by 10.01.2017 / 20:05