Advanced Search

Return to Snippet

Revision: 54429
at December 23, 2011 05:53 by theonlyalterego
Initial Code 
SELECT fl.login_id, fl.start_time, fl.end_time, fl.pid, fl.spid, fl.terminal_id, fl.login_name, fl.session_number, fl.submitted_login_id, fl.serial#, fl.process_spid, fl.login_type,
fuv.user_name, fuv.description
 FROM FND_LOGINS fl, apps_fnd.fnd_user_v fuv
where
 fl.user_id = fuv.user_id
 and fuv.user_name = :P_USER_NAME
 and fl.start_time > (sysdate - 365)
 order by fl.start_time desc
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
Query to find the most recent logins for a particular user ( find 1 years worth )

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Oracle SQL - get a list of most recent user logins

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, Oracle

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL