Tag Info

Hot answers tagged

2

Query V$SESSION and include the column SESSION_EDITION_ID which contains the value you are looking for. The link http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3016.htm#REFRN30223 defines all the column meanings for that dynamic view; I would probably do a query like SELECT SID, USERNAME, SCHEMANAME, OSUSER, PROCESS, MACHINE, ...


1

There are several ways to do this. One would be to use a pipelined function to return the additional row when the day spanning condition is detected. Another way is to duplicate the rows and then eliminate the ones that don't need to be duplicated and adjust the times for those that do. Here is an example: SELECT Case When TwoRowsNeeded = 1 And ...



Only top voted, non community-wiki answers of a minimum length are eligible