Questions tagged as 'oracle'

Tagged questions
1
answer

How to implement the max and min in jpa, to obtain the maximum and minimum date?

I have the following query @NamedQuery(name = "findRegistroAccesoByNuserid", query = "select myRegistroAcceso from RegistroAcceso myRegistroAcceso where myRegistroAcceso.nuserid = ?1 and TO_CHAR(myRegistroAcceso.fecRegistroEntrada, 'dd/MM/yyyy...
asked by 24.03.2018 / 00:43
1
answer

Installing JRE or JDK in Windows does not load file opening dialog [closed]

I comment to see if you can help me that this problem is already driving me crazy. I can not install neither the JRE nor the JDK of java. When I execute them in the JRE , nothing appears to me (but in the task manager ther...
asked by 03.03.2018 / 21:47
1
answer

Know which field is unique

I have a table in Oracle People, nombre varchar2 unique apellido varchar2 edad int I would like to know what the query is to know which field of the table is unique     
asked by 13.02.2018 / 12:04
2
answers

Uncaught Error: Call to a member function fetchColumn () on boolean

Hello, why do I get that error? this function is to validate if there is a user or not but I get this problem:    Fatal error: Uncaught Error: Call to a member function fetchColumn ()   on boolean in C: \ xampp \ htdocs \ login_oracle \ funcs...
asked by 12.12.2017 / 20:21
1
answer

Call an SP from another SP ORACLE

I have the following SP, create or replace PROCEDURE INUP_PARTY( o_PARTYID2010 OUT VARCHAR ) AS v_partyMAX NUMBER :=0; BEGIN SELECT MAX(PARTYID2010) INTO v_partyMAX FROM PARTY2010; INSERT INTO PARTY2010 ( PARTYID2010...
asked by 22.11.2017 / 15:17
1
answer

Doubt to show data in c # from an sp in oracle

Good afternoon I have a question related to ac # and oracle, well I have several procedures stored in an Oracle database (Oracle 11G) in several of these some with input parameters and others that only show everything (select * From name) , my q...
asked by 23.10.2017 / 00:56
1
answer

Different results in distinct

I have a query. In Oracle the column NUM_DISTINCT of the table table ALL_TAB_COLUMNS showing the number of different values throws me a number that if I compare with the following statement, I get different data: select count(distinct(CUST...
asked by 17.10.2017 / 19:16
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

Select with case and decode with different columns [closed]

I want to make a query with a case and decode in the same selection with different columns so that: select NOMBRE, case when DESDE >= 0000 THEN decode(DIA,'0','DOM','1','LUN','2','MAR','3','MIER','4','JUE','5','VIE','6','SAB','ALL','TOD...
asked by 31.08.2017 / 18:26
1
answer

Tablespace and data files in Oracle

A tablespace is a data file that stores several tables, such as a zip file? What is the relationship between tablespace and the data file?     
asked by 11.08.2017 / 23:13