Pages
Home
About Us
Ask The Expert
FAQ's
Tuesday, September 3, 2013
how to find the number of users connected to Oracle Apps in the past 1 day using SQL
select count(distinct user_id) "users" from icx_sessions where last_connect > sysdate - 1 and user_id != '-1'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment