Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
04-26-2009, 09:22 PM #1
- Join Date
- Sep 2007
- Thanked 0 Times in 0 Posts
Oracle SQL - do something if found in table
I have a table containing many rows of usernames. I want to say:
if current user's username is found in the usernames table, then do something
else do nothing
I use upper(PORTAL.wwctx_api.get_user) to get the username of whoever is logged in.
This is my code so far
select 'some html' from domain.table where upper(PORTAL.wwctx_api.get_user) not like upper(username)
I've tried doing case statements, but I get an output for every row in the table.
Hope I've explained this clearly? Can anyone help?