Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Blackhawks4Life
- Order by date
-
Getting current UserID
I have a trigger that I was using the following script to get the current UserID. We recently upgraded from Oracle 10g to 11g and now this query is returning NULL for both values. What I have found is that the SQL_ID in the V_$SESSION table is not being populated. I am using Toad For Oracle on...- Blackhawks4Life
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
Date variable not increasing in Function...
Many thanks!- Blackhawks4Life
- Post #3
- Forum: Oracle: All versions
-
Date variable not increasing in Function...
I created the following function, and I pass in the year 2013. I expected the function to return '02-JAN-13', but it is still returning '01-JAN-13'. What am I missing? I am using Toad for Oracle, on Oracle 11G. Thank you in advance for the assistance. CREATE OR REPLACE FUNCTION...- Blackhawks4Life
- Thread
- Replies: 3
- Forum: Oracle: All versions
