Jason L. Froebe – Tech tips and How Tos for Fellow Techies

Tips & Tricks for Databases (Sybase, Oracle, MySQL, PostgreSQL, SQLite), Windows, Linux, Solaris, Perl, Java, Bash and so much much more

How to change the default NLS_DATE_FORMAT (Date format) in Oracle 10g/11g

by Jason L Froebe on May 6, 2010, 3 comments

It is really really easy to change the default NLS_DATE_FORMAT setting but to be honest, you should set it at a session level IMHO. We basically just need to run “ALTER SYSTEM SET NLS_DATE_FORMAT=’YYYY-MM-DD’ SCOPE=SPFILE” as a user with sysdba privileges. If you started the Oracle instance without a spfile (it should be located at [...]

Share Button

FW: Revision 3: System Episode 45 – Practically Free DIY WiFi Antennas

by Jason L Froebe on July 16, 2008, 2 comments

The building of the free windsurfer (using the Ez-12 Parabolic Reflector Template) from freeantennas.com is particularly interesting. The website claims an amplification of about 9 dBi of gain with the standard size template and 12 dBi of gain if you double the size. Something I will definitely try tonight

Share Button
Facebook login by WP-FB-AutoConnect