Posts by renan bessa • 15 points
5 posts
-
1
votes2
answers1444
viewsQ: Convert Integer to Decimal in Oracle
how do I convert a whole number to decimal on oracle? Today, the consultation coming out this way. 75 However, I want you to go out with 2 decimal places, that way. 75.00 Below is the syntax of the…
-
-1
votes1
answer40
viewsQ: Doubt Bring Specific Date - Oracle
In the query below is bringing this way. Data Inicial Data Final Dia da Semana 16/10/18 30/10/2018 3 Where that initial and final date is a specific period and the day of the week in that case is 3…
-
0
votes0
answers38
viewsQ: Doubt Query Line - Oracle
In the query below is leaving this way. Unidade Ordem_Compra CNPJ Aprovador Sim Boavista 29021 155454878787 Ivan Sim Boavista 29021 155454878787 Romel The question is: How do I leave on a line just…
-
0
votes0
answers163
viewsQ: Different Value - Oracle Query
In the query below in the column Valor_Total_da_Ordem is giving a totally different value, far above what was actually to be. The value is giving 55990.62. The correct value being 1333.11. What may…
-
0
votes0
answers392
viewsQ: Error Query Oracle
People, when executing the query below, the following error is occurring. By parsing, the error occurs when I put sum. For what reason? "ORA-00918: column defined ambiguously 00918. 00000 - "column…