Shortcut to run current command with sudo in bash

For me, I mostly forget to add “sudo” to the command until the time I am actually supposed to run it. Also sometimes, on some systems, bash completion does not work as expected with “sudo”. With these in mind, I wanted something such that when I have completed the command, I could insert sudo in the begining of the command without much ado. So, finally this is what I came up with in my “~/.inputrc” file. Note: If you don’t have this file, then simply create this file.

gqlplus – sqlplus with readline (tab completion)

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 problem. Download and install gqlplus. gqlplus is a replcement for sqlplus which supports completion for commands/tablenames and column names. Quite useful.

Related articles

• 2 GB File limit on writing file using Oracle SQLPlus in Unix(compscicafe.wordpress.com)

  ---

• Find version of Oracle(sqlandplsql.com)

  ---

• Oracle: Using SQLPLUS and SQLLDR on databases without TNSNAMES entry(hs2n.wordpress.com)

  ---

• Another Reason Why You Should Upgrade Your Oracle Client Software(bobbydurrettdba.com)

  ---

Oracle Select the top 5 queries

Here are one sql script that I found some time back. This will be listing the top 5 SQL queries in Oracle.

SET linesize 300
SET PAGESIZE 200
select *
from
(select sql_text,
        sql_id,
        elapsed_time,
        cpu_time,
        user_io_wait_time
from    sys.v_$sqlarea
order by 5 desc)
where rownum < 6;
quit;

Related articles

• SQL Fiddle (thinkvitamin.com)
• New Oracle E-Book (arnoldit.com)
• All about Security – SQL Injection (tkyte.blogspot.com)

Backup of files in the directory.

I was working on some scripts and the changes that I was making in the scripts was very dynamic, which I did want to keep backing up in the version control system. But for the peace of my mind, I wanted to keep a copy of the scripts, whenever it was in working state.

Since I had multiple files, so it would make more sense to have a script that could copy all the files in the current directory to “old” directory without over-writing the existing files. So, I wrote a script that would postfix the files with a number. With this approach, finally what I had was the following:

Faster blog with stats removed

I was thinking of removing the statpress plugin for quite some time now, but did not have a good alternative. Today finally I managed to do this as I had few hours to spare. Now that this is done, you should not be getting the database error that some of you on IE were getting and also should have a nicer experience in terms of page load time.

Related articles

• CR Post to Ping.fm not working – resolved. (amit-agarwal.co.in)
• Compare Two Websites Load Time & Learn Which Website Loads Faster (basnettips.wordpress.com)
• Unix shell script for removing duplicate files (amit-agarwal.co.in)

mysql output to an array for easy parsing.

Today I was looking for some way to put the output of the mysql output in an array in a bash script. Quick google search yeilded to results something like this:

  <td>
    <div class="text codecolorer">
      output=$(mysql -e "select * from table")
    </div>
  </td>
</tr>

The problem with the above approach is that all the words go into separate index. So if you have a line that has space then that is split into multiple index’s. Not good…

Make any command read line enabled (on *nix)

Make any command read line enabled (on *nix)

  <td>
    <div class="text codecolorer">
      rlwrap sqlite3 database.db
    </div>
  </td>
</tr>

Enable readline even if the command line application is not using it.

* View this command to comment, vote or add to favourites * View all commands by pykler

commandlinefu.com

by David Winterbottom (codeinthehole.com)

URL: http://feedproxy.google.com/~r/Command-line-fu/~3/mKEgYoyHCMA/make-any-command-read-line-enabled-on-nix

Related articles

• Use the last command’s output as input to a command without piping and bind to it to a key sequence in bash. (amit-agarwal.co.in)
• DTerm: A command line anywhere and everywhere Oh, man. DTerm =… (kungfugrippe.com)
• Python command line = Linux Bash command line (hackerz4u.com)
• Data Hacks: Command Line ASCII Bar Charts (infosthetics.com)
• Hack of the Day: commandlinefu – Linux Command Heaven (readwriteweb.com)