title: list of users who logged in for last week, month and year
body: <p>I had written a query where i can get a list of users who logged into the system based upon last 1 day, 7 days, 90 days, 180 days and year and it was written in <code>MYSQL</code></p>
  
  <p>but I need to write the same query for my <code>oracle</code> database but i am very limited in my oracle knowledge, can anyone please share the code as to how i can write that such query </p>
  
  <p>Database Table name is <code>JOBDesc</code> and column name is <code>lastLogin</code> </p>
  
  <p>Like this question<br>
  <a href="https://stackoverflow.com/questions/11195130/mysql-last-login-and-number-of-logins-in-last-3-months">MYSQL last login and number of logins in last 3 months</a></p>
  
  <p>my database is too large and big </p>