Questions tagged as 'oracle'

Tagged questions
0
answers

REST GET Procedure that returns CLOB as JSON

I have trouble calling a REST-GET service that uses a procedure that returns a CLOB in JSON. When the result has some records, it works fine, but if there are many, it locks. Oracle 12.1 I have defined a table with postal codes. In this, f...
asked by 12.07.2018 / 14:29
0
answers

Toad + oracle + hexadecimal 4,1XXXXXXXX52E15 (41XXXXXXXX5198)

Currently executing the following query: SELECT SOL_RDDDETALLEREPROGRAMACION.operacion FROM evaluacion.SOL_RDDDETALLEREPROGRAMACION, CREDITO.PRODUCTO P, CREDITO.CUOTA C, CREDITO.CREDITO CA WHERE SOL_RDDDETALLERE...
asked by 18.07.2018 / 23:02
2
answers

Oracle :: Error ORA-01858

I have a table in oracle with a text type column. This column stores dates in dd / mm / yyyy format and may or may not be filled. I need to filter in that table and show only the records that have that field filled with a date less than or eq...
asked by 19.07.2018 / 13:49
0
answers

ORACLE database installation error

When installing Oracle the log throws me the following errors Error cataloging RMAN backups DBCA_PROGRESS: DBCA operation failed.     
asked by 05.07.2018 / 21:20
0
answers

I can not connect Oracle 12c services

Install Oracle in Ubuntu 18 , but after following a guide you do not connect me to the services and it shows me: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ale-VirtualBox)(PORT=1521))) STATUS of the LISTENER ---------...
asked by 04.07.2018 / 18:23
0
answers

I can not install pdksh package for oracle12c

when installing on linux virtual machine oracle 12c I can not advance by: The pdksh package is not available, but some other package makes reference to the. This may mean that the package is missing, obsolete or only available from some other...
asked by 03.07.2018 / 02:18
0
answers

How to insert the last record entered in a table in another table?

I explain. I have a table called OBS_SITEDS that works as a history table of all obervations that are entered, this table has the following fields: code, date, observation And I have the other table that is called CRED_CTACTE where I need the la...
asked by 02.07.2018 / 22:18
1
answer

ORACLE SQL CASE ERROR FROM KEYWORD

I am looking for solutions to the error that is presented to me at the time of writing this query (I am new to the platform, I regret the inappropriate documentation of the code): SELECT EVALUATION CASE WHEN EVALUATION = '1' THEN 'Malo'...
asked by 27.06.2018 / 05:56
1
answer

oracle installation without files

I was installing oracle , but in the end I do not have this file, do you know where I find it?    'Error calling the destination' links proc gen_pcscfg procob 'from the file   make '/u01/app/oracle/product/12/dbhome_1/precomp/lib/ins_precomp...
asked by 05.07.2018 / 20:13
2
answers

Cumulative sum with oracle expression

I am trying to make a cumulative sum with the following query: SELECT to_char(INVC_DT, 'MON-YYYY') AS MONTH ,SUM(INVC_AMT) /*, aqui necesito una tercera columna con la suma cumulativa de la segunda columna*/ FROM T_INVC_INFO I I...
asked by 05.07.2018 / 20:39