sqlplus Archives - AskDba.org Weblog

12c: Sqlplus Displays Last Login Time For Non – Sys Users

Post author:Amit Bansal
Post published:22 July, 2013
Post category:12c
Post comments:1 Comment

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…

Sqlplus HTML reports

Post author:Amit Bansal
Post published:28 June, 2012
Post category:10g / 11g
Post comments:1 Comment

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…

Input is too long (> 2499 characters) – line ignored

Post author:Amit Bansal
Post published:30 January, 2009
Post category:Unix
Post comments:0 Comments

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…