Questions tagged as 'oracle'

Tagged questions
1
answer

Refresh column with item sorting

Hello, In a given relationship table I have a column that holds the sort, however due to a problem in the application this column was populated with wrong data, as the example |user_log ------------------------------------------- |user_id...
asked by 22.07.2016 / 19:08
2
answers

Compare with previous date in oracle

Hello, I need to check which purchases have been made in the last 7 days select * from carros car where to_date(to_char(to_date(car.datacompra,'yyyymmdd'),'dd-mm-yyyy')) = trunc(sysdate - 7) I get the following error: ORA-01840: v...
asked by 25.07.2016 / 15:21
1
answer

Oracle error PLS-00103 when doing INSERT

I can not understand this Oracle syntax error: SET SERVEROUTPUT ON DECLARE v_idEmp INTEGER: = &numero_funcionario; v_nome VARCHAR(30): = '&nome'; v_sobrenome VARCHAR(30): = '&sobrenome'; v_email VARCHAR(30): = '&email'; v_tel...
asked by 11.05.2015 / 21:14
2
answers

Audit change in Java + Spring + Oracle application

I have a task to change an audit implementation in an application in which I work. The audit requirement is to know the history of changes, and the execution of certain tasks by a particular user. (Initial State -> Modification 1 -> ... -> M...
asked by 19.01.2015 / 13:46
2
answers

Join table using a SubQuery

I have 3 tables: inscricaoaluno , inscricaoescola and prova , with the following structures: PROOF    IDPROVA | DESCPROVA | TYPE | QTDEMAX REGISTRATION    PROFESSOR | SCHOOL (IDESCOLA) | DTINSCRICAO | IDPROVA...
asked by 24.03.2015 / 17:53
1
answer

Oracle user is a reserved word, can generate problems?

Is there a problem if an Oracle user (USER) is a reserved word? In case: MAX     
asked by 25.07.2014 / 16:59
2
answers

SELECT column type DATE by HH24: mm: ss

Hello, I have 2 DATE fields, depending on the snippet below: ...hr_inicio DATE NOT NULL, hr_fim DATE NOT NULL, ... And I need to query these fields using only the values for the HH2...
asked by 11.12.2018 / 19:11
1
answer

How to use order by stop ordering the names of the months in Oracle

Hello, I'd like to know how to solve this problem. I would take the name of the days of the month and order them and not the numbers of the corresponding months. It follows the query that I performed but that only orders in numbers corresponding...
asked by 05.12.2018 / 20:44
1
answer

How to find the name and address of the students and teachers of São Paulo

Hello, I have a question on the question my teacher went through to train. The database has 5 tables being: a alunos , professores and historico in the exercise asks to consult the name and address of the students and teacher...
asked by 13.11.2018 / 19:11
1
answer

How do I know if a column exists in a table in Oracle?

I'm trying to add a new column to a table in Oracle, and I want to know if it already exists or not. I have tried something like this: IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'minhaTabela'...
asked by 30.01.2018 / 14:22