Questions tagged as 'oracle'

Tagged questions
1
answer

Query error per month

I need to make it so that the user chooses the month to calculate ESTDIA. On the red and bold line. When I leave the :MES and execute of the error and already leave defined example V.OUTUBRO o SELECT runs without error...
asked by 10.11.2014 / 16:06
0
answers

Problems with insert in Oracle with Laravel [closed]

I'm having a problem with a INSERT in Oracle using the yajra / laravel-oci8 package, where I get the following error:    Error Code: 1722 Error Message: ORA-01722: invalid number Position   : 260 Statement: insert into TRANSMISSAOITB...
asked by 20.06.2014 / 20:43
2
answers

What Connection String is used to make the connection between Cobol and B.D. Oracle?

I can not make a connection between a Micro Focus program Cobol and the Oracle database. I'm using the command: EXEC SQL CONNECT :USERNAME IDENTIFIED BY :PASSWD END-EXEC The error that returns me is:    Please speci...
asked by 27.03.2017 / 17:04
1
answer

Update in table with date field

Hello! I need to do an update on a table. I have some sort of chat in the bank, where it records the time the conversation was started, and should record the time it ended. However, before I implemented the code that would record in the bank...
asked by 08.07.2015 / 17:06
2
answers

Group views in SQL Oracle

I have a small block of logical reasoning. I have a table (table1) organized this way, but would need to return the query as table2 just below. Can anyone help me?     
asked by 01.12.2016 / 13:35
2
answers

How to do WHILE in PL / SQL

I need to make a WHILE in SQL. Follow the code I've already tried DECLARE CONT INT; SET CONT=0; WHILE CONT < 3 BEGIN SELECT CONT SET CONT = CONT +1; END; The error that appears is as follows: Erro a partir da linha : 1 no...
asked by 25.10.2016 / 02:35
3
answers

operation with date sqlserver

Gentlemen, I'm migrating my system from Oracle to SQL Server, I'm having trouble doing the following operation SELECT CASE WHEN (EPL.DAT_VENCIMEN - EPL.DAT_FABRICA) > 0 THEN CAST(((CAST(SYSDATE-EPL.DAT_FABRICA AS INT)) /...
asked by 11.10.2016 / 16:21
2
answers

How to mount a Transaction with Commit and Rollback in Oracle?

I'm trying to set up a transaction in Oracle, but I do not know how to do a Rollback if there is an error in one of the querys. I searched some sites, but I did not find anything clear and simple that explained. I started doing this: DELETE...
asked by 20.03.2014 / 18:14
3
answers

Remove repeated lines in all respects in Oracle [closed]

In a CADASTRO column I have two lines repeated in all respects: NOME ID EMAIL SEXO JOAO 1234 [email protected] M JOAO 1234 [email protected] M How to compare these two lines, check if all the columns are identical and d...
asked by 04.05.2017 / 21:18
1
answer

Where are banks saved in SQL * Plus?

I downloaded SQL * Plus from the Oracle site, installed it (my notebook is Windows 10) I created a user and I already created some banks, but I do not know where it saves the banks I created. Where is it?     
asked by 15.09.2016 / 18:34