It's all about the answers!

Ask a question

JRS Adv SQL Query - Troubleshooting


Mahari Hill (4861156229) | asked Apr 12 '18, 9:33 p.m.

CLM 602
Oracle 11.x

We need to create a SQL query to prevent starting back up Cognos to create this. We need, for a given project ID

Name, UserID, Email, (active/inactive)

Seems simple, and I think we need to access "the resource table" but not sure.

One answer



permanent link
Mahari Hill (4861156229) | answered Apr 25 '18, 7:32 a.m.

I was able to obtain the information needed from support. I was not aware that there were views that could be used.

Your answer


Register or to post your answer.