Monthly Archives: April 2010

Setup Google Apps Custom Domain (e.g. @techienotes.info) on Empathy

Posted on April 18, 2010 by Ahmed Tawfik

Create a new Jabber account and enter the following details: account :  username@techienotes.infoencryption required TLS/ssl : (unmarked)ignore ssl certificate error : (unmarked)server : talk.google.comport : 5222 (default)use old ssl : (unmarked)Source

Posted in Jabber | Tagged , , | Leave a comment

Bash Script to run a sql file (Draft) – Part 1

Posted on April 17, 2010 by Ahmed Tawfik

#!/usr/bin/bash # This script calls the Ad_1.sql script and spools the output with date stamp to a log file# Update: You MUST add your environment variables one way or another, e.g. look below export ORACLE_BASE=/oracleexport ORACLE_HOME=/oracle/OraHome_1PATH=${PATH}:${ORACLE_HOME}/bin; export PATHexport LIBPATH=${LIBPATH}:${ORACLE_HOME}/lib32:${ORACLE_HOME}/lib if … Continue reading →

Tagged , | Leave a comment

Putting the Current Date in a Spool File Name in sqlplus

Posted on April 14, 2010 by Ahmed Tawfik

 Using SYSDATE you can query the current date and put it in a substitution variable. The substitution variable can then be used in a SPOOL command: column dcol new_value mydate noprintselect to_char(sysdate,’YYYYMMDD’) dcol from dual;spool &mydate.report.txt— my report goes hereselect … Continue reading →

Tagged | Leave a comment

Some useful Google Chrome extensions that I use – Part 3

Posted on April 11, 2010 by Ahmed Tawfik

Well, this is the article number 200 in this blog, I’m so proud of this 🙂 Copy Without Formatting: Enables you to copy text from any website without its formatting, very useful in some situations where you just need to extract … Continue reading →

Tagged , , | Leave a comment