Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
LSQL Questions
Content
Hi all - I am working on an LSQL report for combining salary/assignment data to show old/new information. I have run into a few questions that I am really hoping to get answered before posting the final report.
- How do I do sorting? It appears I cannot do it through the LSQL (ORDER BY ASC/DESC), and I know how to do it through the UI itself, but as you know, when you change the LSQL it wipes that formatting. So was hoping to do it through the code.
- Is there a way to do variables? In SQL, I know you can create a variable at the top of the code (DECLARE
Tagged:
0