I'm new to SQL and I am trying to combine duplicate TRK_ID to one single row and SUM the IN_QTY if the HRS column is the same time stamp. Can someone please help me. Thank you!! Current SQL Code: Sele...

I am very new to plsql and I'm not even sure if I can do what I want. I'm trying to create a simple plsql block that I can use for multiple databases that will create a pfile in a specific directory t...

Is it possible to turn the current time stamp to a whole number? Example: If sysdate returns 1/19/2022 5:36:49 PM can I turn that to 1/19/2022 5PM since it falls in the 5PM range. Here is my query ...

I want to write the case expression for this condition in View Indicate "Y" in the report if Livestream (all) is selected and display all the individual platforms under livestream (App, Onli...