Posts by LeonardoBarreto • 13 points
3 posts
-
0
votes0
answers20
viewsQ: Manipulating data and dates in oracle
I am developing a report with a view with Oracle database, and I need to make a function where the output value will be the running days since the last product drive, ie basically present day less…
-
0
votes1
answer62
viewsQ: How can I get all data stored in an array
I am programming a system in Delphi that should trigger automatic emails, and to store some of the emails that I have in my database, I place them in an array as follows? function…
-
0
votes2
answers64
viewsQ: Select returning null values in the database
SELECT S.ID_SALES, S.ID_CLIENT, C.FULL_NAME, S.SDATE, coalesce(S.billed, 'N') BILLED, P.product_description product, I.amount, I.unit_cost, I.unit_cost * I.amount SUBTOTAL, coalesce(I.discount, 0)…