I was reading http://blogs.oracle.com/myoraclediary and there was a command about printing the modification details of a file.
In Linux / Cygwin “stat” exists as a command
$ stat /etc/hosts
Access: 2010-08-25 15:20:49.782522200 +0200
Modify: 2010-08-18 14:04:25.868114200 +0200
Change: 2010-08-18 14:04:26.072413100 +0200
Or use the one-liner perl below
### st_atime; /* Time of last access */
$ perl -e 'use POSIX;[-f"/etc/hosts"]&&print ctime((stat(_))[8])'
Wed Aug [...]
I read Paul Sorensen blog : Sun certifications will be renamed next week.
For instance the Sun Certified Network Administrator will be Oracle Certified Expert, Oracle Solaris 10 Network Administrator.
But to get the OCE Solaris title, you need to upgrade your certification [...] to receive an Oracle certification title (check more details on the Oracle [...]
In one of my script, I am checking at the end for any ORA- error. And if I have any ORA- error, I quit with an error.
So far so good.
Also when I run a report from the shell, I do set the sqlplus settings I like and I expect the script to receive the [...]
I see TRUNC(SYSDATE) in the code very often. Is this good or bad?
Over my past two years as a developer, I can tell you it is pretty bad. What does TRUNC(SYSDATE) mean? It is today’s date.
But when does today starts and ends? And at the time of the writing, it is already tomorrow in [...]
If you want to start with developing free software on old technology, you can download the Oracle Database 10g Express Edition.
Actually, Oracle 10g is more than 5 years old and it is the only version available as Express Edition, 11g has not been released at the time of the writing, and no patch has been [...]
According to the doc
The subquery_factoring_clause now supports recursive subquery
factoring (recursive WITH), which lets you query hierarchical data.
This feature is more powerful than CONNECT BY in that it
provides depth-first search and breadth-first search, and supports
multiple recursive branches. A new search_clause and cycle_clause
let you specify an ordering for the rows and mark cycles in the
recursion
As written there [...]