Questions tagged as 'oracle'

Tagged questions
1
answer

Name table resulting from SELECT

I need to do a SELECT of the resulting table from another SELECT , but I need to reference it in ON INNER JOIN in>. How do I do this in Oracle (PL / SQL)? I tried this way, but it did not work: SELECT * FROM (SELECT * FROM recurso WHERE...
asked by 22.11.2017 / 14:53
1
answer

Selection Using FROM TABLE

I have a table and a function that returns a pipeline, but the function needs to receive a data from the first table, I thought the selection would look something like this: Select FERRAMENTA.IDFERRAMENTAS FROM SIG_SERVICOSFERRAMENTAS FERRAME...
asked by 23.10.2017 / 14:59
1
answer

Table is not generated in Oracle database

This normal wheel: create table M_VENDEDORES ( ID_VENDEDOR number (10,0) not null, NOME varchar2 (100) not null, CPF number (11,0) not null, ENDERECO varchar2 (100) not null, NUMERO varchar2 (10) not null, CEP number (11,0) not null, constrain...
asked by 23.10.2017 / 00:32
1
answer

Search using model

I would like to use my model to do research in Laravel. I would like, if possible, someone could explain me: I have my model class minhaModel extends Model { protected $table = "minha_model"; public $timestamps = false; prote...
asked by 20.10.2017 / 14:13
1
answer

Insertion error in Oracle database with Java

When I make a set of inserts in the bank, it says that only the course information has been entered, but the class Console STATUS DE CURSO: true STATUS DE CURSO: false JOptionPane TurmaDAOpublicclassTurmaDAOextendsDAO{publicT...
asked by 15.10.2017 / 20:23
3
answers

Statement Where comparing variable Date (date type) with current date

Hello. I am using Oracle SQL and need a query that returns values where the date is equal to the current date. Does Oracle have any reserved word for current date in the system? My code: insert into monitoracao(idseq, idsess, inst_name, ela...
asked by 29.09.2017 / 16:38
3
answers

Doubt with insert in the bank Postgres

I have an error message, I tried several options of not getting a solution. Is there a missing configuration?     
asked by 28.08.2017 / 16:21
1
answer

Find duplicate values in an Oracle table

Have a table in an Oracle database called MESSAGE. This table has some fields among them LOCALID and APPLICATIONNAME. Following examples of values entered in the base LOCALID - APPLICATIONNAME 1 - app1 1 - app1 1 - app1 2...
asked by 15.08.2017 / 19:52
1
answer

Convert a to_date sql to a date java

My problem is this, I have to grab SQL insert lines and check if the formats in the TO_DATE function in these inserts are valid with a java method. For a 'DD / MM / YYYY' format, SimpleDateFormat solves my problem, but sometimes an insert is req...
asked by 07.07.2017 / 02:12
1
answer

How to mount an inner join by filtering through a field with a minimum value?

I wanted to mount a inner join that would only bring the values filtered by a minimum value field select min(data_vencimento) from pagamento where cod_situacao = 3, cli.cpf, cli.nome, con.data_inicio, con.data_fim, sit.situacao, con.val...
asked by 12.06.2017 / 01:37