This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables. It uses information schema database to gather information and storing in a temporary table. Usage: call xplore(database-name); – Procedure will search through information schema for […]
Having a colourful display on shell script is something that’d beautify your experience. Using colour text and echos will help you to highlight and distinguish the shell output on a linux prompt. Here’s how you can have colored text in linux shell, try following command on your bash: bash $] tput setaf 1 You will […]
Using Vlookup: I have two csv files; File1 has Id and Value Columns and File2 has Id. Problem: I need to compare both files and put respective values to File2 from File1. Solution: VLookup in excel Steps: Open both files in Excel & arrange it vertically (Window >> Arrange; for ease) Click on cell where […]
I required to make a batch script which needs file / directory to be created with current date / time stamps. Following are the code snipts for formating date / time in a batch script: FOR /F “TOKENS=1* DELIMS= ” %%A IN (‘DATE/T’) DO SET MYDATE=%%B FOR /F “TOKENS=1,2 eol=/ DELIMS=/ ” %%A IN (‘DATE/T’) […]
This is a LAN Messenger which allows you to chat with friends on local network. The Dos based chat program is just like a chat program but only for LAN. What you need to have is: This tool, a desire for communication and an IP / Machine Name. In one line, its a “batch program […]
Characters Character Description Example Any character except [\^$.|?*+() All characters except the listed special characters match a single instance of themselves. { and } are literal characters, unless they’re part of a valid regular expression token (e.g. the {n} quantifier). a matches a \ (backslash) followed by any of [\^$.|?*+(){} A backslash escapes special characters […]
About Subversion: Subversion, also known as svn, is a version control system much like the Concurrent Versions System (CVS). Version control systems allow many individuals (who may be distributed geographically) to collaborate on a set of files (typically source code). Subversion has all the major features of CVS, plus certain new features that CVS users […]
This article explain a way to get a mail as soon as the disk usage reaches to its critical level to avoid issues later. To set a simple monitor on Linux / Unix, I have two simple scripts: DSAlert.sh : Shell script for retrieving disk space percentages and put in to a cron job. DiskSpace_Alert.pl : Perl script for sending an […]
Following are linux commands, tricks for doing regular tasks. Rename files: replace space by _ in linux: for files in *; do mv “$files” `echo $files | tr ‘ ‘ ‘_’`; done Change case of multiple file names: for files in *; do mv $files `echo $files | tr ‘[:upper:]’ ‘[:lower:]’`; done Find files having […]
Change Is Inevitable