Questions tagged as 'oracle'

Tagged questions
2
answers

Sum with inner join Oracle

People need help, I need to create a report that shows the total quantity of each product in stock, but I can not get the name of the products, only the product code and the sum of the quantity of the products I have. Here is the code I did: S...
asked by 30.06.2017 / 15:57
0
answers

Create trigger in oracle

I have three tables: Usuario , Lembrete and Lembrete_Usuario in Oracle. I'm trying to create a trigger that when I insert it into the User table and in the Reminder, take the User and Reminder ids, and put it in the User_Reco...
asked by 18.06.2017 / 20:09
1
answer

"ORA-01417: a table may be extra joined to at most one other table"

I'm setting a select and I came across the following error:    ORA-01417: a table may be extra joined to most other table SELECT A.SEQPESSOA, A.NUMERONF, A.NROEMPRESA, A.SEQPRODUTO, D.SEQCONTRATO, E.PERCDESCONTO, D.SEQCONTRATO, E.SE...
asked by 26.06.2017 / 23:17
1
answer

Could not read from remote repository

I created a BARE repository in the folder: c://projetos/cliente1 this in the VMBOX ORACLE called (vmserver) Then when real pc access time, returns the following message:    $ git clone file: //// vmserver / projects / client1 Cloning...
asked by 10.06.2017 / 05:19
1
answer

Return rows with the largest value in a [duplicate] column

I have a problem with a query in an Oracle database in a table with 3 columns: ID_Loja | Canal | Valor_Venda There is the possibility of having more than one sale per store and I want to know which channel was assigned to the st...
asked by 22.05.2017 / 19:00
2
answers

Change the characterset of oracle 11g

When performing a dump file import, oracle is returning the following messages: IMP-00019: Line Rejected Due to Error 12899 ORACLE IMP-00003: Oracle Error: 12899 found ORA-12899: too large value for column "USUARIO"."TABELA"."COLUNA" (...
asked by 22.05.2017 / 19:52
1
answer

Add values and subtract values from another condition

Good afternoon I have a table named TITLE In it I have got columns with name CODOPERACAO, VLROPERACAO, DTAOPERACAO I have 2 different CODOPERACAO records which are: 16 = Inclusion of title 28 = Payment of the title There may be more tha...
asked by 19.05.2017 / 23:10
1
answer

Create condition in statement

Hello, I have the following select: SELECT CONSTRAINT_NAME FROM user_cons_columns WHERE COLUMN_NAME = 'CANCELAMENTO' and table_name = 'NAVIO'; After getting the name it goes to another query but if it returns null I end up having an error a...
asked by 17.05.2017 / 15:53
1
answer

Create transform view by deleting or transforming DATE into VARCHAR in ORACLE

I have a table with 58 different columns and would like to create a View that treats the DATE fields as VARCHAR , without my having which discriminate all columns in the View creation. CREATE VIEW VW_TESTE AS SELECT * FROM TABELA...
asked by 17.05.2017 / 19:06
0
answers

How to create a new database in ORACLE?

I installed the oracle database, oracle client, and sql developer on a windows 8.1 64 bit. With the installation of the oracle database a database was created in localhost: 1521 But now I would like to create a new database on this connect...
asked by 08.06.2017 / 17:23