How to Check to See if a Record Exists in Oracle. Though SQL ... "database_identifier" is a character string that specifies a particular Oracle database. SQL*Plus will prompt you for your password.