Questions tagged as 'oracle'

Tagged questions
0
answers

Exception when Inserting in the Oracle DB

The error message is as follows:    2017-06-23 10: 35: 07.365 ERROR 888 --- [nio-2019-exec-1]   o.a.c.c.C. [. [. [/]. [dispatcherServlet]: Servlet.service () for   servlet [dispatcherServlet] in context with path [] threw exception   [Request...
asked by 23.06.2017 / 18:25
1
answer

Oracle + Oci8 + php5.6 + ubuntu 16.04

I have installed ubuntu 16.04, with PHP5.6 . I downloaded a version of Oracle instantclient (sdk and basics) Oracle 12.1.0.1.0 , I unzipped it over /opt/oracle/instantclient. Then I exported the variable as the home of oracle...
asked by 10.06.2016 / 09:44
0
answers

Replication from oracle 12c to postgreSQL

Hello friends I am trying to replicate data from a database of oracle to a database of postgreSQL , researching I have found the application oracle golden gate . The point is that I am working with two virtual machines in o...
asked by 01.02.2016 / 02:37
3
answers

how to do a SELECT of two different fields of the same table in a single column in Oracle 11g?

Good morning, I'm making a query I need to make a selection of 2 fields from the same table but within a single column column, that is SELECT desc_equipo, serialnro, serialmac from producto desc_equipo is let's say the field that stores the...
asked by 07.11.2016 / 16:44
3
answers

Validate in PL-SQL

I'm in a PL / SQL database and I need to put together an anonymous script to insert into a configuration table (config and value fields). Something like this: Config: ‘country’ Value: ‘Argentina’ Config: ‘moneysign’ Value: ‘$’ Config...
asked by 21.09.2016 / 03:43
2
answers

Help JOINS ORACLE SQL query

Create a select where the name and last name of the employee, department where he works and the name and surname of the manager who coordinates it. SELECT EMPLOYEES.FIRST_NAME||' '||EMPLOYEES.LAST_NAME AS "NOMBRE COMPLETO DEL EMPLEADO",DEPARTM...
asked by 16.06.2018 / 08:08
1
answer

ORA-00928: in MERGE

Good morning, I am trying to update records from a CTE, however I am getting error ORA-00928: I think I'm not missing anything, however, I can not get the update to run. I attach the code that I am making. I hope you can guide me about...
asked by 10.07.2018 / 19:15
2
answers

How can I resolve this query?

They ask me: what is the most expensive mazda brand vehicle plate sold in 2017? I have 3 tables: vehicle, owner, sale Vehicle: primary key plate, color, make, model Owner: id primary key, identity card, name, surname, email. Sale: idv...
asked by 30.07.2017 / 02:02
1
answer

Migrate SQL Server database to Oracle

I'm trying to migrate a database from SQL Server to Oracle , for this I'm using Oracle SQL Developer as suggested by the following Oracle Tutorial , which has the following sections: Connection: 1. Install Oracle SQL D...
asked by 02.06.2016 / 00:37
3
answers

Optimize SQL query

I have the following SQL query SELECT (SELECT NVL(max(f_mov), '') AS f_mov FROM tmp_vtas_clientes AS b WHERE a.c_linea = b.c_linea AND a.c_almacen = b.c_almacen AND a.c_producto = b....
asked by 30.04.2016 / 15:57