MySQL: Create a function
The following code produces a sample function in MySQL: CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTICRETURN CONCAT('Hello, ',s,'!');
Linux-Unix: VI editor
VI Editor commands: Use [escape] key after completion of every input task! [ctrl]-F Move forward one screen.[ctrl]-B Move backward one screen.$ Move cursor to end of line.^ Move cursor to…
Linux-Unix: Find files / Find in files
Linux: To find files like *.rdf in the path /oracle/erptd/appl: find /oracle/erptd/appl -type f -name *.rdf -print 2>/dev/null Note1: .rdf is the extension for Oracle Reports, Note2: 2>/dev/null to drive…
Oracle Apps 11i: Creating a custom application
How to create custom applications in Oracle environment 11i (White Paper): Subject: Step By Step Guide to Creating a Custom Application in Applications 11i Doc ID: 216589.1 Type: WHITE PAPER …
PHP: Add watermark on a picture
Add a watermark on a picture in PHP: <?php// Load the stamp and the photo to apply the watermark to$stamp = imagecreatefrompng('stamp.png');$im = imagecreatefromjpeg('photo.jpeg');// Set the margins for the stamp…
MySQL: Run in batch mode
The following code can be written in windows batch file (.bat): cd "D:\EasyPHP-5.3.3.1\mysql\bin>"D:\EasyPHP-5.3.3.1\mysql\bin>mysql -u root -p < c:\run_this_file.sql
HTML: Timezones select list
The following is a simple format of all world timezones: <option value="-12">International Date Line (west) 04:08</option><option value="-11">Samoa 05:08</option><option value="-10">Hawaii 06:08</option><option value="-9">Alaska 07:08</option><option value="-8">Los Angeles 08:08</option><option value="-7">Denver 09:08</option><option value="-6">Chicago 10:08</option><option value="-5">New…
Linux: Backup Shell Script for Joomla
The following is an example of backup Joomla website filesystem and database, keeping always the newest backups, using shell script: #!/bin/bash#this script is in: /home/html/myScripts/scripts#backup is in: /home/admin/backupsysdate=`date '+%Y%m%d'`echo "This…
MS-DOS: BackUp Script Example
DOS backup example: Put the files in a new directory and cleanup the 11th oldest Using EnableDelayedExpansion the variables are preserved @echo offsetLocal EnableDelayedExpansionSET DESTINATION_DIR="D:\TEST_DESTINATION"SET SOURCE_DIR="C:\TEST_SOURCE"REM MAKE A NEW DIRECTORY…