I am writing an SQL with "Oracle SQL Developer" to search for data based on user selection. The two choices are: 6AM-3PM (1st Production Shift) and 3PM-12AM (2nd Production Shift). I am ok with writing two separate SQLs to complete this task, but I would like to have one SQL making the decision based on a prompt for user input (i.e. Please enter shift "1" or "2"). Can someone please help me with the details of setting up this CASE?