sql
gqlplus – sqlplus with readline (tab completion)
2012/08/03
Tab completion is something which is missing in the sqlplus and if you have lot of tables with long names or lot of columns then it is sufficiently difficult to type them 🙂 Here is a solution for this …
Oracle Select the top 5 queries
2012/02/27
Here are one sql script that I found some time back. This will be listing the top 5 SQL queries in Oracle.
Benchmarking the system/CPU performance
2012/01/15
Have you ever wanted to have a quick check on your CPU performance. I know that lot of people will say that this is not the right way to do this, but here is something that you can use to check the …
analyze debug queries output for wordpress
2011/02/09
Some time back, my website became too slow and I started getting timeout response for quite a lot of my pages. When I analyzed things, I found the issue was with the DB queries taking a lot of time. …
Using SQLite to maintain your monthly bills.
2010/08/24
I was looking for a small application to maintain my every month bills. The application had to be small and script-able. I basically wanted to keep track of the bills that have been generated and …
SQLite – simple use in scripts
2010/08/21
Today we will look a the most simple use’s in the scripts and how to use them. […] echo ”insert into bills values (”$name”,$date_now, …
SQLite : Manager for this simple database
2010/08/19
We will look at sqliteman – <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite Database manager. If you are looking for a …
SQLite – Easy to use, dependable and good to use database for small applications.
2010/08/17
For last couple of days I am looking at <a class="zem_slink" title="SQLite" rel="homepage" href="http://sqlite.org/">SQLite, a very footprint, file based …
SQuirrel SQL for Graphical interface to Oracle/MySQL and loads of other database – OSS and free.
2010/06/04
<a href="http://blog.amit-agarwal.co.in/category/linux/">Bookmark this category SQuirrel <a class="zem_slink freebase/en/sql" title="SQL" …
Checking the links to your site (from affiliates) using cron and bash script.
2010/05/27
If you have some affiliate links and are concerned about their presence then you can setup <a class="zem_slink freebase/guid/9202a8c04000641f80000000045c9c5b" title="Cron" …
create SQL-statements from textfile with awk
2010/03/08
<td> <div class="text codecolorer"> $ $ awk \'{printf "select * from table where id = %c%s%c;\\n",39,$1,39; }\' inputfile.txt </div> </td> </tr> …
bash script with sql to get the number of records from multiple tables.
2010/02/10
Here is the bash script: […] #!/bin/sh names[1]=errorlog names[2]=amit1log names[3]=amit2log names[4]=amit3log names[5]=amit4log j=1 echo $1 for i in $( sqlplus amit/passwd@tns @get_count.sql …