Create a query in Oracle SQL -

Create a query in Oracle SQL -

i have table called p_sighting. has these columns (site_id, dive_num, genus, species) want create query create list of species have been sighted on every single dive @ site_id # 3014.

if site_id of type number, utilize query

select species p_sighting to_number(site_id) = 3014

if site_id of type varchar, utilize query

select species p_sighting trim(site_id) = '3014'

oracle-sqldeveloper