I'm learning PL/SQL stored functions in Oracle SQL Developer and I'm having trouble trying to create a function that returns a row that does not contain duplicate information. Schema information: APP...

So I'll have table values where some values in a column will have a 4 digit value and if they exist, I have to add the 3rd value to a variable. So if I have 1234, the variable Number will be 3. Below ...

I created a function to calculate total amount (shipping + subtototal) for customer If customer isn't cerated I want to see in the output error DBMS_OUTPUT.PUT_LINE('IDCUSTOMER: ' || customer_id || 'T...

I there, I am new to PL/pgSQL, the project I am working on started using it for some data-intensive handling implementations, I am failing to understand some basic foundations, even reviewing the docs...