This content has been marked as final. Show 2 replies
select * from HSP_USERS;
that should return the details from the table if you are logged in with the schema user, otherwise you might need
select * from <schema>.hsp_users;
so if your planning application was in the planbud schema you would use
select * from planbud.hsp_users;
It may be more beneficial if you have a look at using a product with a GUI like SQLDeveloper as it will return the information in a nice format.
Thanks John for the answers.