Questions tagged as 'oracle'

Tagged questions
1
answer

Error retrieving record with a null property in Oracle

when trying to get a record in ORACLE and the value of the property which I then use to make a validation contains a null value query error Informe de error - ORA-01403: No se ha encontrado ningún dato ORA-06512: en línea 38 01403. 00000 - "n...
asked by 26.10.2017 / 13:47
2
answers

Obtain a single data from two Oracle queries

I need to make a query, in which if a subquery returns a value null execute a second subquery which guarantees me to return a value the two subqueries return the same value. FIRST_VALUE (pac1.pac_name) -------------------------- |Oct/20...
asked by 27.09.2017 / 22:36
2
answers

BD Oracle query by time segments

Hello, I have a table in Oracle DB that has the following fields and values: Now I need to generate a query that groups me by sections of half an hour the number of elements per DATE_CREATION, for example for this case the result I would e...
asked by 12.07.2017 / 18:32
1
answer

Query executed in Python does not return information from my Oracle database

The problem is that I'm doing some queries to the oracle 9 database from my python 2.7 script with the help of cx_oracle but when printing the cursor values it does not return information which IF IT EXISTS in the database. I have tried pla...
asked by 25.05.2017 / 17:12
1
answer

Trigger to calculate hours pl / sql

Good morning everyone and thanks in advance for the time you gave me; My problem is the following one I have to program a trigger in my database that calculates the excess of hours or in its defect the hours of less and skips a warning. I'...
asked by 10.05.2017 / 15:41
0
answers

Django and Oracle

I have a django project that I need to connect to an Oracle database When I use sqlite3, which comes by default with the following string: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME': os.pat...
asked by 12.05.2017 / 16:57
0
answers

Migration Django 1.10 a 1.11 Error environment can only contain strings

Recently I actulize django from its version 1.10 to 1.11 and the console sends me the following error Traceback (most recent call last): File "manage.py", line 10, in <module> execute_from_command_line(sys.argv) File "C:\User...
asked by 12.05.2017 / 15:38
0
answers

Oracle query error

Hi, I have this query but I miss an error saying that parentheses are missing right: select to_char(trunc(fecha,'HH')+(30*round(to_char( trunc(fecha,'MI'),'MI')/30))/1440,'DD/MM/YYYY hh24:mi:ss') AS fecha, SUM(total) AS total from (S...
asked by 31.07.2017 / 20:32
2
answers

Oracle PL / SQL Get package name

I have N Packetes with N Procedures, how can I get the name of the package that is executing the procedure, I know I can get the name of the procedure with $$ PLSQL_UNIT, but since I do the same but for the name of the package, this with the goa...
asked by 20.04.2017 / 21:35
1
answer

Error creating an Identity in Oracle

How about people, I hope you can help me solve this problem even if it's silly, I'm trying to create a table with an Identity type ID and I'm getting the following error: Error que empieza en la línea: 1 del comando : CREATE TABLE USUARIO ( us...
asked by 05.05.2017 / 18:54