For the OBIEE prompts to be used for BIP reports and to pass (All Column Values) and also multi select you can use the following SQL in the...
Read More
Enter key word
Home / Archive for 2017
Display Previous N period in MON-YY format
SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -level), 'MON-YY') AS Previous_Period FROM dual CONNECT BY LEVEL < 5 order by (TO_CHAR(A...
Read More
Subscribe to:
Posts
(
Atom
)