Questions tagged as 'oracle'

Tagged questions
1
answer

Error trying to make a "DROP TABLE": "ORA-02449: unique / primary keys in table referenced by foreign keys"

I happen to be trying to delete the following table of name CITY with the following code: DROP TABLE CIUDAD; But when I run the code I get the following error: ORA-02449: unique/primary keys in table referenced by foreign keys 02449. 0000...
asked by 13.12.2017 / 22:35
2
answers

How can I change the format of a date in SQL Language?

I am working with the HR SQL database (ORACLE), and I would like to know how to change the date format Current format 06/17/03 Future or expected format June 17, 2003
asked by 08.03.2018 / 13:46
1
answer

SQL Query subquery level

I have a query that throws level error. It is a table that has the rates of change in two directions Example: moneda_from | moneda_to | tasa conversion ARS | USD | 0.20 USD | ARS | 20.00 I want to get one of the...
asked by 14.09.2018 / 00:18
1
answer

Problems with connection to ORACLE with PDO and PHP

A moment ago post the following question! Problems with PDO and PHP Once the code in the connection file has been corrected, the following error appears!    could not find driver       Fatal error: Uncaught Error: Call to a member funct...
asked by 27.04.2017 / 18:28
2
answers

Oracle SQL SubConsulta

I'm doing a table query / modification exercise. I have two tables: CREATE TABLE CURSOS ( Codigo NUMBER, Nombre VARCHAR2(20), Cod_Profe NUMBER, Max_Alumn NUMBER, Fecha_Inic DATE, Fecha_Fin DATE, Num_Horas NUMBER, CONSTRAINT...
asked by 24.04.2017 / 09:47
1
answer

Pass java objects to stored procedure in oracle

I'm having a problem trying to pass an object or fix from java to a store in my database. What happens is that when I try to pass an attribute that is string, this is being allocated empty in the STRUCT object the code is as follows StructDesc...
asked by 14.06.2016 / 19:36
0
answers

ERROR IN ORACLE

I'm trying to make a trigger in sql, but it gives me three errors that I can not solve, you can tell me if you see any error in this trigger. CREATE OR REPLACE TRIGGER DL_3 BEFORE INSERT ON CONGRESOS FOR EACH ROW BEGIN SELECT AC.id_articulo...
asked by 24.11.2018 / 17:10
1
answer

Concat of two fields in different rows - ORACLE

I have the table Adjudicacion which carries various data, including no_garantia , and each row of the query would be an adjudication. Each award, as I said before, has its kind of guarantee (normal, professional or both). If the awa...
asked by 09.08.2018 / 13:00
1
answer

Filter a data in an SQL field

I have this query "SELECT * FROM KTMOVIMIENTOCONTABLE WHERE CM1_TERCERO LIKE '%" + TBNit.Text + "' AND CM1_TIPO = '" + comboBoxTipo.Text + "' AND CM1_NUM LIKE '%" + TBCausacion.Text + "'" I use it to bring some data but each user has many a...
asked by 10.08.2018 / 17:22
1
answer

Trigger / trigger for oracle

I need to make a triger / trigger so that when someone inserts a value it is modified and another one is inserted. That is, I from a web page will insert a list of products with their ID, but the database to be in oracle does not have auto_in...
asked by 20.05.2018 / 18:40