Skip to content
Advertisement

how to create pl sql function to Checking if data exists in database or not

I am trying to create a function that tells whether data exist in database or not. Trying to solve this using cursor if data exist then data will be fetched from database and value of temp will be TRUE otherwise data would not be fetched from DB and it will set value of temp to false.

But when I compile this function it gives warning that

Warning: Function created with compilation errors.

Advertisement

Answer

I recommended to use an implicit cursor and don’t bother for open/closed;

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement