Questions tagged as 'oracle-11g'

Tagged questions
1
answer

how to install oracle 11g r2 expres and sql developer on ubuntu 18.04

I have 2 .zip files and from the console I try to execute a file that comes inside one of the zip files called "RunIntaller" but it shows an error: An invalid source path '../stage/Components/oracle.jdk/1.5.0.17.0/1/DataFiles' was specified f...
asked by 20.11.2018 / 03:36
0
answers

how to pass multiple values in a single parameter in stored procedure oracle plsql

friends a query how you can pass multiple values in a single parameter in a stored procedure with Oracle plsql     
asked by 30.10.2018 / 15:01
0
answers

Is there any way to pass the structure of the table to the value of a query in Oracle?

I am trying to perform a dynamic query where I can pass the structure of the table to row of a query keeping the value of that field using some Oracle function. I have seen the references of PIVOT, ws_concat and listagg but they do not fulfill w...
asked by 17.10.2018 / 02:06
1
answer

Duplicate sqlserver join

Hello good day I have a question, I have a table that says products and one that says equivalents and linked results that I do the query with joins where is this way: Productos Equivalentes Ligados 00697000 MS-92692 MU-41309-P...
asked by 05.10.2018 / 00:49
1
answer

SQL Developer, INSERT dated: error - ORA-01843: not a valid month

I am running this to insert values in the table: CREATE TABLE SERVICIOS ( ID INTEGER PRIMARY KEY NOT NULL, FECHA DATE NOT NULL, HORA TIMESTAMP NOT NULL, DISTANCIA DECIMAL (*,2) NULL, TIEMPO_REQUERIDO INTEGER NULL, DIREC...
asked by 23.09.2018 / 07:37
0
answers

How to save a trigger of a table A in scheme A in another table B of scheme B?

I need to save some data in a Bitacora table when I update the Salary attribute, the detail is that the Bitacora table is in a DA user and the Salary attribute belongs to the Employee table which is in the AD user, then I show the trigger that I...
asked by 15.09.2018 / 02:53
0
answers

Problem when dropping tables with empty PL / SQL records

Very good, I have done a procedure in PL that filters tables whose columns match or contain the word you receive from a parameter and generate a .CSV file, the fact is that I have thought about, in addition, discard those tables that do not cont...
asked by 05.09.2018 / 13:46
1
answer

duplicate field in query records with Entity Framework on table without primary key

Currently I have the need to connect an application to a table in a database (Oracle 11g) of other software. This table does not have a defined primary key. My Entity is this. public partial class Inacc { [Key, Column("ACCHIS", Or...
asked by 10.09.2018 / 22:51
0
answers

connect to oracle database with phyton

I'm trying to connect to an oracle database via 32-bit phyton 3.6.5, but I miss this error: I ping the database and receive a correct answer. I can also connect to the developer correctly. I have also done a tnsping and returns: performed...
asked by 27.08.2018 / 10:15
0
answers

Load external table data in Oracle 11g

I would like to know if you can help me with a process that I am trying to adapt to get some interesting data from the trace files. I have an external table called "cursor", which performs the loading of data through a program in Perl "cursor...
asked by 10.08.2018 / 00:44