12c: Sqlplus Displays Last Login Time For Non – Sys Users
12c database has introduced a pretty nifty Security feature which allows you to check last login time for non-sys user. e.g If I connect to scott user as below, it…
Read Full RecipeTag: sqlplus
Sqlplus HTML reports
I was working on setting up monitoring for application team to monitor AQ and wanted html formatting of table data. On searching I found this link from Ittichai Chammavanijakul which makes…
Read Full Recipe
Input is too long (> 2499 characters) – line ignored
There are times when you observe above mentioned error while creating view and mview from mview definition taken from Toad or indexfile option. vi editor comes in handy to resolve…
Read Full Recipe