Understanding Wildcard Operations in Oracle SQL Like

How to Select Values from Different Rows in a Table Based on Conditions with Oracle SQL