Questions tagged as 'oracle'

Tagged questions
2
answers

Delete repeated data oracle

Suppose I have this "Product" table id number categoria nombre varchar precio number I need to make a query in oracle that I delete the duplicate data that match the name and price, is it possible with a query without using a procedure?   ...
asked by 11.01.2018 / 17:00
1
answer

Error trying to connect to sql plus from the Ubuntu terminal

I'm trying to connect to the sql plus from ubuntu but I get this ERROR ubuntu@ubuntu6:~$ su oracle Contraseña: oracle@ubuntu6:/home/ubuntu$ lsnrctl start oracle@ubuntu6:/home/ubuntu$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Productio...
asked by 05.01.2018 / 23:45
1
answer

Trigger with compilation errors

Well it turns out that I want to make a trigger that when I update a column in a specific table records are annexed ie I have a table where articles when the sale is made and the quantity is discounted that information is given to a sales table....
asked by 17.12.2017 / 21:36
1
answer

Error creating table: "An identifier with more than 30 characters was specified"

I have problems when trying to execute the script to create the client table, I leave the code and the tables with which it interacts with its respective problem. CLIENT TABLE CREATE TABLE CLIENTE( RUT VARCHAR2(10) CONSTRAINT PK_CLIENTE PRI...
asked by 13.12.2017 / 21:40
0
answers

Login is not working php oracle

Hello, when I try to log in it just does not work, I should enter the if and write a message "FORWARD" but it does not work (enter the else) I searched the error for a long time but I can not find it. I made sure that the data is good, and I tri...
asked by 10.12.2017 / 06:52
0
answers

import bbdd error ORA-00038

When trying to import a database using the statement: imp system/system@xe file=database.dmp log=importLog.log full=y; Launches me an error:    IMP-00038: Could not convert to environment character set's handle Reading by sta...
asked by 15.12.2017 / 14:17
0
answers

Uncaught Error: Call to undefined function createTitles ()

Good morning I am trying to create a function with php that fills in the title fields automatically, but when I try to pass the arrangement where I have my titles, I get the following error: "Uncaught Error: Call to undefined function createTitl...
asked by 04.12.2017 / 15:52
0
answers

ORA-12505, TNS: listener does not currently know of SID given in connect descriptor

Good afternoon, what happens is that I have an error when trying to create a connection in SQLDeveloper "Status: Fail: Failed to test: Listener refused the connection with the following error: ORA-12505, TNS: listener does not currently know of...
asked by 03.12.2017 / 21:14
0
answers

relate nested table attribute to attribute of another table in OOO oracle

Hello as the title says I need to relate the attribute Id_libro of nested table that is in the table Prestamo with an Id_libro attribute of the table Books in POO oracle, a kind of foreign key so that there are no errors that in a loan t...
asked by 29.11.2017 / 20:08
1
answer

help with query to update with fields separated by commas

I have the table COSAS CAMPOA CAMPOB Frutas Manzana Frutas Peras Frutas Uvas Lacteos Yogur CANTIDAD CAMPOC CAMPOD Frutas 1 Manzana 2 Peras 3 Yogur 1 Lacteos 1 I need a query that ponsiga this: FIELD A and FIELD C I...
asked by 15.11.2017 / 17:54