SQL on Offering details in Learning module — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

SQL on Offering details in Learning module

edited Aug 29, 2021 3:21PM in Learning 2 comments

Summary

SQL on Offering details in Learning module

Content

Hi Experts,

I have a sql query to get course and offering details. But there is a difference between offering start date from SQL and actual value.

SQL:

SELECT DISTINCT lit.NAME course_name, lit.learning_item_id course_iddd,
                lit_off.learning_item_id off_iddd,
                lit.description_short course_description,
                li.DURATION course_duration,
                li.learning_item_type learningitemtype,
                li.learning_item_number course_id, li.currency_code,
                lit_off.NAME offering_name,
                lit_off.learning_item_number offering_id,
                TO_CHAR (lit_off.effective_start_date,
                         'yyyy/mm/dd'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!