Avatar of tyruss8
Flag for United States of America

asked on 

PL SQL Developer

I have a broad question so please bare with me on this. I posted a question regarding how to calculate a working days using a holidays table. So now I have a function working.

But my question, how to call/execute this function so that I can run it against a table. (Kinda similar to MS Access queries work).
I've been searching the web but I just don't how what's the best practice. Example:
I have a function that accepts 2 dates and returns an integer number. (e.g., function_name (a date, b date) and returns the a number.
My table columns: id, start_date, end_date.
My expected results if possible: id, start date, end_date, "the number returned from the function"

Thank you.
Oracle DatabaseSQL

Avatar of undefined
Last Comment

8/22/2022 - Mon