This will be an easy one for any experts!
I am doing a project on Oracle at uni and only have basic knowledge of Oracle.
I want to retrieve data into 3 display items from one code.
Ie: I have a clinic code and have created 3 display items for clinic_description, start_time and end_time.
How do I write the PL/SQL for the trigger to display all data in one go? I only know how to display it for one item.
So far it looks like this:
I need the start_time & end_time to display in the clinic_appoint form as well.