how to check if a database exists programatically

["surabhi.ahuja" <surabhi.ahuja@xxxxxxxxxxx>]

 i have to write a shell script in which i have to check if the database "abc" exists or not

 

how should i do it ? some select query

 

select * from ??? where database_name = 'abc';