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 */ […]
Month: August 2010
OCE Solaris Network Admin
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 […]
Do you know the ORA- nonerrors?
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 […]
Hardcoding SYSDATE
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 […]
On Express Edition
If you want to start with developing free software on old technology, you can download the Oracle Database 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 […]