Questions tagged as 'oracle'

Tagged questions
2
answers

Compare two tables, one of sql server vs. another one of pl / sql

How or where can I do a select comparing two tables from different databases? Example: I have two databases, one in SQL Server 2008 r2 and one in Oracle There is a table of ventas_cabecera in both Which of the platforms...
asked by 08.03.2016 / 14:36
3
answers

Resultset of a query in java

Hi, I have a project in which in a java class, I did the query to the bd of oracle, I did it of type ResultSet, so that my servlet that works as a controller, could discriminate the result and see where it redirects it , the query only brings a...
asked by 24.05.2016 / 16:02
1
answer

How is a bulk insert to Oracle from .net with C # language? [closed]

How to make a bulk-insert from .net for an Oracle database.     
asked by 08.02.2016 / 17:39
0
answers

Django Migrate ORA-00955 error

I'm doing a project in django 1.8.7 using Linux Ubuntu 16 and connected to an Oracle 11g database, at the moment of wanting to migrate the project using the python manage.py migrate it throws the following error, does anyone know how to s...
asked by 31.12.2018 / 04:45
1
answer

Error ORA-00933 when using oracle query in python

I'm putting together a script in python: #!/usr/bin/python2.6 import os import cx_Oracle import csv SQL="SELECT count(status) status FROM v'$'session GROUP BY status" # You can set these in system variables but just in case you didnt os.pu...
asked by 14.04.2016 / 21:56
0
answers

How to get the first day of the week ORACLE?

How can I get the first day of the week in ORACLE and the week that is for example 12/17/2018 - 12/23/2018 It would be week 51     
asked by 27.12.2018 / 13:20
0
answers

Problems generating Excel report with PHP

I am trying to generate a report from ORACLE using PHP. By clicking on the "generate excel" button, you have no problem bringing me an .xls. The problem is that the .xls file does not bring the columns separated by cells. This is the cod...
asked by 27.12.2018 / 16:09
0
answers

Take out new field crossing with another table large query

I was trying to modify an existing query using oracle sql developer 18.0.3 I have a large query I enclose the query to make it clearer <entry key="descriptor.pers"> WITH t1 as (select t1ID, listagg(nvl(cod,'#'), ',...
asked by 21.12.2018 / 08:55
0
answers

Phone data handling in MySQL and PHP

I need to save the phones and then validate it by SMS and serve as a method of recovering your account. According to my approach, I decided to use 3 fields in MySQL phone BIGINT(20) // Guardar el # como tal code_phone VARCHAR(8) // Guardar...
asked by 03.01.2019 / 22:02
0
answers

Pivot with Oracle

In this query, day is a date field, effort a numerical field where I keep the number of hours worked and technical, as the name of the technician. I want to get the hours for each month from each technician. select * from ( select to_char(dia...
asked by 20.12.2018 / 14:44