Questions tagged as 'oracle'

Tagged questions
1
answer

Modify "NLS_NUMERIC_CHARACTERS"

I have a bbdd in Oracle 12 with this parameter: NLS_NUMERIC_CHARACTERS = '.,'; I would need it to be reversed ',.' . The only option I find is: alter session set NLS_NUMERIC_CHARACTERS = ',.'; But this only changes it at the ses...
asked by 25.06.2018 / 14:18
1
answer

How to do an UPDATE correlated with conditions in PL SQL?

I have 2 tables: Table Solicitudes , with columns Id_cliente and No_cuenta_prestamo Table Disposiciones , with columns Id_cliente and Estado_Actual Subsequently I run the following code: ALT...
asked by 17.04.2018 / 21:27
1
answer

oracle 18c on Ubuntu16

I'm trying to install Oracle 18c on Ubuntu Server 16 When it reaches a point in the installation, it throws the error: "Failed to call destination install" There is documentation on how to install Oracle 12c in Ubuntu as: Tutorial in 12c Bu...
asked by 31.10.2018 / 18:48
1
answer

PDO and Oracle query problem

I have a problem when making the query, it does not return anything. The query is correct since I have executed it in the sqldeveloper and it does not give me an error in the connection either. This is my code: test.php <!DOCTYPE html>...
asked by 07.04.2018 / 17:40
1
answer

Loop within Oracle Forms PL / SQL Block

Good day, I have a block with the following elements: * TextBox *Check box * Label in the TextBox I execute a query to show me data from a table, the checkboxes will serve me to indicate which of the elements shown I want to execute in a s...
asked by 03.04.2018 / 21:14
1
answer

Problem with date format

I am working on a mobile application in which I keep data in my device database, one of those fields is the date and time but when I want to insert these fields from my application to Oracle, it marks me an error the format of the date which I h...
asked by 20.03.2018 / 21:59
1
answer

Error when trying to insert data into a table (Trigger)

I am new here and I come to ask you where is the error in the code (exact match returns ..) since I am eating my head and I still can not find it. It turns out that the Trigger works with the first two inserts in the Call table but in the third...
asked by 13.01.2018 / 14:37
1
answer

missing error a parenthesis to the right ORA-00907

Hi, I'm a newbie in sql code and they ask me to create tables with sql. When creating the table I get the error of missing a parenthesis on the right ORA-00907 and I can not find the cause. This is the structure that I have created. create...
asked by 28.11.2017 / 20:09
1
answer

Remove structure from all Oracle SQL tables

With the following SELECT I see all the tables of a user: SELECT table_name FROM all_tables where owner='usuario1' Result: TABLE_NAME ---------- USUARIOS PRODUCTOS CLIENTES ...(+300 tablas) And with the statement describe...
asked by 21.11.2017 / 14:18
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