Tech Trek

Oracle Cascade Delete

2012-01-15T07:49:00.002+05:30

http://www.sandeepsinghal.com/2012/01/14/oracle-cascase-delete/

Oracle SID vs Service Name in JDBC URL

2011-10-09T06:03:00.000+05:30

With SID

jdbc:oracle:thin@myhost:port:sid

With Service Name

jdbc:oracle:thin@myhost:port/service

Vim - Join Lines with a Comma (or any other character)

2011-10-04T17:18:00.000+05:30

Step 1 : Put the desired character at the end of each line. I will use a "," as an example

:%s/$/,/g

Step 2 : Join the lines together

%j!

Post on Logging.

2011-10-03T08:15:00.002+05:30

My post on logging in production

http://sandeepsinghal.wordpress.com/2011/09/18/better-you-log-in-development-less-you-will-bleed-in-production/

Google Code Page for Unix Utils

2011-10-03T08:13:00.001+05:30

Adding some of my utility shell scripts to a common google page.

http://code.google.com/p/nixtils/

Linux - See which process is using which port

2011-07-25T19:57:00.000+05:30

netstat -anop

Then use ps and grep to find the process using this port

Windows - See what processes are using which ports

2011-07-25T19:49:00.000+05:30

netstat -ano

You can then use the task manager to see the process id of the owning process.

Installing xmllint on cygwin

2010-02-23T23:06:00.001+05:30

Select the following pacakges

libxml
libxslt

symbolic links in windows

2009-12-27T20:33:00.002+05:30

junction - sysinternal tool for winxp and above

mlink - with vista and above

Find lines of code in your repository

2009-11-07T09:23:00.004+05:30


        for ext in "*.java" "*.xml" "*.css" "*.jsp" "*.js" "*.sql"
        do
                echo -n "$ext,$location,"
                find ./$location -iname "$ext" -exec wc -l '{}' \;|gawk '{total+=$1} END{print total}'
        done

Passing Debug Parameters to JVM using Ant

2009-10-22T17:54:00.001+05:30

Getting tablespace Size

2009-07-02T19:20:00.000+05:30


SELECT tablespace_name,
       SUM (bytes) / 1024 / 1024 current_size,
       autoextensible,
       SUM (maxbytes) / 1024 / 1024 max_size
FROM dba_data_files
WHERE tablespace_name like '%'
GROUP BY tablespace_name, autoextensible
ORDER BY 1

bash : search and replace from previous command

2009-05-10T14:53:00.002+05:30

tar -cvf sandeep.tar sandeep/

!!:gs/sandeep/singhal will mean

tar -cvf singhal.tar singhal/

:gs is for global search and replace

bash - last argument of the previous command (nth argument)

2009-05-10T14:19:00.004+05:30

Get the last argument of the previous command : !!$
Get the first argumnet of the previous command : !!^
Get the 1st argument of the previous command : !!1
Get the nth argument of the previous command : !!n

Examples :

$> ls :!!$ (or !$)

$> ls :!!^

$> ls :!!2

$> ls :!!n

Trigger GC in eclipse.

2009-05-02T12:12:00.003+05:30

This is a handy for eclipse which lets you to trigger gc in the eclipse instead of waiting for the jvm to schedule the GC .

Go to Window->Preferences->General, mark Show Heap status check box.
The current Heap usage with icon for "Run Garbage Collector" will appear at the bottom right.

It helps a lot in eclipse performance.

I find it pretty handy especially because I do not shutdown eclipse often.

Two things I love about opera

2009-05-01T09:51:00.003+05:30

1. You can type windows specific path on the browser bar and it will covert it to "forward slashes" when you are browsing directory like strucure on a browser

2. The quick search box : The cursor remains at the same place if you go to a different window by "ALT-TAB". This in firefox changes to select the entire text already typed in the search box. Hence you cannot start typing straight away, since that will erase the already entered text.

Common sqlplus commands

2009-04-26T21:01:00.000+05:30

ACCEPT - Get input from the user
DEFINE - Declare a variable (short: DEF)
DESCRIBE - Lists the attributes of tables and other objects (short: DESC)
EDIT - Places you in an editor so you can edit a SQL command (short: ED)
EXIT or QUIT - Disconnect from the database and terminate SQL*Plus
GET - Retrieves a SQL file and places it into the SQL buffer
HOST - Issue an operating system command (short: !)
LIST - Displays the last command executed/ command in the SQL buffer (short: L)
PROMPT - Display a text string on the screen. Eg prompt Hello World!!!
RUN - List and Run the command stored in the SQL buffer (short: /)
SAVE - Saves command in the SQL buffer to a file. Eg "save x" will create a script file called x.sql
SET - Modify the SQL*Plus environment eg. SET PAGESIZE 23
SHOW - Show environment settings (short: SHO). Eg SHOW ALL, SHO PAGESIZE etc.
SPOOL - Send output to a file. Eg "spool x" will save STDOUT to a file called x.lst
START - Run a SQL script file (short: @)

source :

http://www.orafaq.com/wiki/SQL*Plus_FAQ

Oracle - Default Location for data files

2009-04-20T13:54:00.001+05:30

To get the existing location

sql > show parameter db_create;

To set a new location

sql> alter system set db_create_file_dest='/home/ssinghal/oradata';

Vim - Reduce Backslashing

2009-04-08T13:59:00.001+05:30



Appending a "\v" reduces the amount of backslashing the search expressions.

/codes\(\n\|\s\)*where : normal regexp
/\vcodes(\n|\s)*where  : very magic

source :
http://vim.wikia.com/wiki/Best_Vim_Tips

Vim - Open Current File in Explorer or Command Prompt

2009-04-07T14:04:00.004+05:30

Put the following two lines in your vimrc files under window to get F11 and F12 to work as "command prompt here" and "explorer here" !


map  :silent !start cmd.exe /k pushd %:p:h
map  :silent !start explorer.exe %:p:h

source for tip1

"http://vim.wikia.com/wiki/Open_the_folder_containing_the_currently_open_file"

source for tip2

A variant of tip 1 using windows trick of adding a registry for folders to open a command prompt

Note : % represents the file open in current buffer

Oracle dba_jobs : Breaking

2009-04-06T13:57:00.002+05:30

exec dbms_job.broken(690,true);

where 690 is the job number obtained from
select * from dba_jobs

Oracle databases - startup and shutdown

2009-04-06T13:54:00.004+05:30

Shutdown:

$ export ORACLE_SID=db_sid
$ sqlplus /nolog
sql> connect / as sysdba
sql> shutdown immediate

Startup :

$ export ORACLE_SID=db_sid
$ sqlplus /nolog
sql> connect / as sysdba
sql> startup mount
sql> alter database open;

Note: This needs to be done by logging on the machine where oracle database is installed

marks in vim - bookmarks

2009-02-24T18:58:00.000+05:30

- Go to a line where you want a mark and press mx - this will create a bookmark

( x can be any alphabet from a-z)

- Now navigate away from that place. If you need to get back to the earlier cursor location press "`x" (back-tick and x)

- You can set multiple "marks" in a single file and navigate using back-tick and the alphabet used to create a mark

Cron entry for other users

2009-02-16T16:13:00.000+05:30

Execute the following as root :

cat /var/spool/cron/ssinghal

where ssinghal is the user name

Sed - Deleting lines matching a pattern

2009-02-06T11:36:00.002+05:30

sed -i '/.*log$/d' file_names.txt

Deletes all the lines ending with "log" from the file "file_names.txt"

marks in vim - bookmarks

2009-01-27T08:29:00.002+05:30

Go to a line where you want a mark and press mx - this will create a bookmark

( x can be any alphabet from a-z)

- Now navigate away from that place. If you need to get back to the earlier cursor location press "`x" (back-tick and x)

- You can set multiple "marks" in a single file and navigate using back-tick and the alphabet used to create a mark

sed : inplace replacement

2009-01-26T21:39:00.004+05:30

It is easy to open a file in vim and do a search replace - but if the file runs into huge sizes, a regular editor would not be able to perform search and replace tasks on it efficiently. For these situation, you need a "stream" editor. Here is an example for replacing "foo" with "bar" in a file called snafu.txt

sed -i -e 's/foo/bar/g' snafu.txt

Where:

-i : Is for inplace replacement

-e: sed script to be run on the file

samba mount

2009-01-26T21:21:00.001+05:30

Using samba to mount a windows shared folder

mount -t cifs -o username=Home\\sandeep //192.168.0.1/Shared/ /media/Shared

Where /media/Shared is the target folder where the network folder will be mounted.

Executing a command remotely using ssh

2009-01-25T18:49:00.001+05:30

Following command will run a shell script on a remote machine

ssh ssinghal@192.168.0.1 /tomcat/jakarta/bin/kill.sh

Capturing output of terminal on Unix

2008-12-26T12:31:00.002+05:30

Terminals do not have a great scroll length and even though you can increase the number of lines that can be scrolled up, it is always useful to have the output captured in a file so that you can search on it. Here are few ways

1. Redirection

cat foo.txt > bar.txt

Outout of foo.txt is captured in bar.txt

2. Redirection with "append"

ls >> bar.txt

This will append the output of "ls" to bar.txt ( Instead of overwriting it)

3. "tee"
Redirect and redirect with append will not display the content on console and hence if you want to see the content and also redirect it to a file , use "tee"

ls | tee bar.txt

this will display the contents of ls on terminal and also redirect it to bar.txt

4. output to multiple files

ls | tee a.txt b.txt c.txt

This will output contents of ls to a.txt, b.txt, c.txt

5. Outout all the terminal interaction to a file

script -f out.txt

Converting UTF-16 to UTF-8

2008-12-22T08:57:00.003+05:30

I was running grep on an xml file (big one) and realized that it did not match the pattern I was expecting the the file. I then did a "head" from the file to see a pattern that is present in it. Grepping on that too returned nothing telling me that grep is somehow not working on this file.
"head" was returning some junk characters at the begining of the file - This idicated that the file does not have a normal text encoding and probably that is the reason why grep is not working on it.
Reading the XML header proved that, since it was "UTF-18", grep was not running over it. I had to convert the file to UTF-8 which is more text friendly if the content is only English.

iconv --from-code UTF-16 --to-code UTF-8 input_file.xml > output_file.xml

screen

2008-12-13T21:14:00.001+05:30

when to I use screen :

* When "nohup" is just not enough
* When the power goes off and you are left in the middle of nowhere
* When I need to log on to 10 different terminals each day
* When I do not want to enter 10 different username passwords each day

"screen" is a terrific unix utility that allows you to start a terminal without having to worry about you job being interreputed mid-way. It is better than nohup in that respect nohup only allows unix commands to be started in a "nohup" fashion. If for instance you are working with an interactive program like sqlplus and your internet connection happen to break, you will loose your context and any transactions that you were working on.

It essentially allows you following :
* Multiple sessions in a single ssh window (screen multiplexing)
* Ability to "resume" a session in the state you left it - irrespective of power outage, internet connection termination etc

Here is how you use it :

1. Make sure it is installed on your system by typing "screen --help"
2. If it is not installed, you can install it by "yum install screen" on a fedora box.
3. start a screen session by typing "screen" and you should be in a screen session.
4. If you are disconnected or closed the terminal, type "screen -r -d" to reattach to the session

Here are some of the short-cuts available (All after CTRL+A)

c : creates a new
n : next screen window
p : previous screen window
a : toggle between two screen windows
[0-9] : Go to a specific screen window identified by a number
A : Set the name of a screen window
" : List all the existing screen
ESC : Scroll up or down on a screen

Man on the moon (well almost)

2008-11-15T11:03:00.003+05:30

India becomes the 4th Nation to put a lunar probe on the moon ! I am proud to be the 4th country to do that(as against the alleged 3rd world country banter from Matthew Hayden who knows nothing more than being a sore loser)

pasting code in vim

2008-10-19T09:18:00.002+05:30

:set paste

paste the code

:set nopaste

set pastetoggle=F3 in your vimrc file is an alternative.

Renaming Files in Linux

2008-10-17T19:24:00.003+05:30

Type the following on commandline of a bash shell and change the logic as needed.


for i in `ls /home/ssinghal` ; do mv "$i" "$i.new" ; done

sudo without password

2008-09-30T13:02:00.003+05:30

1. Log in to a unix box as root
2. Execute "visudo" to open sudo editor
3. Enter the following line
ALL=(ALL) NOPASSWD: ALL

Database Objects - Finding Dependencies

2008-09-23T16:43:00.004+05:30

You come across tables in databases that are being populated by other pl/sql procs, triggers e.t.c what becomes difficult is to figure out which process is actually updating a table.

The following query will list objects that refer a table "TABLE_A" which belongs to a schema "SCHEMA_A"


select name,owner
from dba_dependencies
where referenced_name='TABLE_A' 
and referenced_owner='SCHEMA_A'

JQuery - Getting Started

2008-08-19T16:12:00.003+05:30


// Makes an element visible which has the id 'mydiv'
$("#mydiv").show();
  
// Makes each odd tr element to have a blue backcolor
$("tr:odd").css("background-color", "blue");


// What if we want to make the header row have a different look ? Show Me
$("#results tr:first").css("background", "black");
$("#results tr:first").css("color", "white");
$("#results tr:first").css("font-weight", "bold");


// We also could have assigned a class name to the header tr element like this 
$("#results tr:first").addClass("header");


//All span that are inside a div element (may not be immediate child of the div) will be selected.
$("div span").css("border", "1px solid");

//Here is how we select the links that are descendent of span which are direct children of a div
$("div > span a")

//Here is how we can select a div with id mydiv 
$("div#mydiv")


// Here is how we select all links under div elements that have css class set to mycss
$("div.mycss a")

// if we want to find a link that points to http://www.google.com then we would write
$("a[href=http://www.google.com]")


// Modifications
$("body").prepend("");
$("div#mydialog").html("Hi There!
");
$("#mytable").wrap("
");


// How to replace all hr elements (horizontal line) with a br element
$("
").replaceAll("hr");

Reference : http://www.shafqatahmed.com/2008/08/mybutton-font-f.html

tcpdump : capturing data

2008-07-22T15:15:00.001+05:30

capture all traffic on port 80 for a specific machine

sudo tcpdump -A -s 0 -i eth0 dst or src host and port 80

Reference : http://code.google.com/support/bin/answer.py?answer=71567&topic=12022

Vim Movements - Some Common , Some Not so much

2008-06-27T09:03:00.002+05:30

ESC + H Moves to the line at the top of the screen.
ESC + M Moves to the line in the middle of the screen.
ESC + L Moves to the line at the bottom of the screen.

[Ctrl-F] Move forwards one page.
[Ctrl-B] Move backwards one page.
[Ctrl-D] Move forwards by half a page.
[Ctrl-U] Move backwards by half a page.
[Ctrl-E] Display one more line at the bottom of the screen.
[Ctrl-Y] Display one more line at the top of the screen.

Reference : http://en.wikibooks.org/wiki/Learning_the_vi_editor/vi_Reference#Movement

Old Firefox Versions

2008-06-23T07:44:00.001+05:30

http://releases.mozilla.org/pub/mozilla.org/firefox/releases/http://releases.mozilla.org/pub/mozilla.org/firefox/releases/

nmap - portscan

2008-06-12T14:36:00.003+05:30

scan all the ports in a given range on a specific machine

nmap -p1-10000 127.0.0.1

The above command will scan host 127.0.0.1(localhost) to see if any of the ports from range 1 to 10000 is up.

Oracle - Enabling Parallelism

2008-06-09T13:42:00.003+05:30

If your database server is running on multiple processor system. You can make all your processors conspire to run a query. You might want to do this when the query is known to take a long time and there is no way it would return in sane time. At the same time, be careful to run this on production systems as it may hamper performance of the database.


select /*+ parallel(x 4) */ count(1)
from huge_table
where huge_table.x = 'somevalue'

vim : ignoring white spaces in vimdiff

2008-06-06T10:30:00.000+05:30

In your .vimrc file :
set diffopt+=iwhite

http://vim.wikia.com/wiki/Ignore_white_space_in_vimdiff

Appending to a register in vim

2008-06-04T08:28:00.000+05:30

For example, you want to collect a sequence of lines into the a register. Yank the first line with:

"aY

Now move to the second line, and type:

"AY

Repeat this command for all lines. The a register now contains all those lines, in the order you yanked them.

Reference : Vim manual

Bind Parameters in a complex query

2008-05-13T18:21:00.010+05:30

Oracle Data dictionary tip :

This is pretty useful when you are running a huge pl/sql code or a complex query and you need to know what bind parameters are being used for a query. helps figure out the iteration you are in amongst many other.




select name, position, datatype, 
       value_string, value_anydata 
from V$SQL_BIND_CAPTURE where sql_id 
IN 
 ( select a.sql_id 
   from v$sql a where sql_id in 
    ( select sql_id 
      from v$session 
      where osuser = 'ssinghal' 
      and machine = 'my_machine_name 
      and status = 'ACTIVE'
     )
 );

Search Replace in all Vim Buffers

2008-05-06T13:34:00.002+05:30


:bufdo %s/pattern/substitution/ge | update



bufdo – apply the following command to all buffers – see :help :bufdo.

%s – search and replace the whole file

g – change all instances in a line

e – avoid an error when the pattern doesn’t exist in a buffer

update – write the file only if changes were made

source : http://vim.wikia.com/wiki/Search_and_replace_in_all_buffers

Getting Started with Rails 2.0 on ruby

2008-03-06T08:52:00.004+05:30

create a rails project called student with mysql as database (default is sqllite)

rails -d mysql student

vim config/database.yml and edit username/password if required

create the database if not already created through backend
rake db:create:all

Generate a scaffold for a student
ruby script/generate scaffold studen name:string address:string

edit db/migrate/001_create_students.rb to add more tables or columns to existing table. This step can be skipped.

Create the Database tables
rake db:migrate

Run server
ruby scripts\server

Access the project through a browser
http://localhost:3000/students

tada

vim - stop autoindent while pasting text

2008-03-02T20:01:00.002+05:30

On a putty terminal, when you copy-paste code from other sources, it results in a complete mess, due to vim trying to format it again. To avoid this, type

:set pastetoggle=

Now you can use to toggle between paste mode (and no paste mode).

When in paste-mode auto indent will be turned off. This is very useful when pasting text that's already indented.

source:
http://amix.dk/blog/viewEntry/19083

vim - going back in time

2008-03-02T19:54:00.002+05:30

supported since vim 7

" Go back 1 minute
:eariler 1m

g+ and g- can be used for redo and undo ( u and CTRL + r still applies)

Long Operations in Oracle

2008-03-01T18:51:00.002+05:30

It is nice to know what queries are taking time to finish. The following sql figures out the "long operations" currently being processed


SELECT username,time_remaining,sofar/totalwork,message,target_desc
FROM gv$session_longops where sofar<totalwork
ORDER BY message

Apache Web Service Framework

2008-02-13T20:15:00.001+05:30

http://incubator.apache.org/cxf/

vim - recording keystrokes and reusing

2008-02-11T16:07:00.000+05:30

http://www.vim.org/tips/tip.php?tip_id=144

The most useful feature that I find in VIM is the "recording" feature (:help recording).  I have used this to automatically insert function headers, re-indent lines, and convert some 34 source files into HTML.

This feature is most useful when you want to do some repeated jobs, which you cant do easily using ".".  You can set about writing a function, define a mapping, etc, but then these things might take time.  By recording, you can try out and find the actual keystrokes that does the job.

To start recording, press "q" in normal mode followed by any of "0-9a-z".  This will start recording the keystrokes to the register you choose.  You can also see the word "recording" in the status(?) line.  You can start the key sequences that you want to record.  You can go to insert mode and type if you want.

To stop recording, press "q" in the normal mode.

To playback your keystrokes, press "@" followed by the character you choose.  Pressing "@@" will repeat the same again.

subversion : clean non-versioned files from svn source tree

2008-02-08T19:45:00.001+05:30

svn status|egrep "^\?"|awk '{print $2}'|xargs rm -rf

ruby - installing from source

2008-02-08T08:51:00.000+05:30

1. Download ruby.tar.gz from rubyforge

2. unzip and untar the file

3. Navigate to extracted folder

4. following steps ( like any other source compile on linux)

./configure
make
make install

This will install ruby .

5. To install an extention (say to install openssl on linux)

go to ruby-source/ext/open ssl and execute following steps

ruby extconf.rb
make
make install

unix find - seach based on permissions

2008-02-07T11:27:00.000+05:30

All the files in the current directory that does not have a write permission for user and group

find . -not -perm -ug=w

All files owned by 'ssinghal'

find . -owner ssinghal

Code Search Engines

2008-02-04T12:44:00.000+05:30

TODO: Edit this post to give a description on special features of each search engine :)

http://www.google.com/codesearch

http://www.koders.com

http://www.krugle.org

http://www.codase.com/

using sun.* packages in java

2008-02-01T13:03:00.000+05:30

From : http://java.sun.com/products/jdk/faq/faq-sun-packages.html

The classes that Sun includes with the Java 2 SDK, Standard Edition, fall into package groups java.*, javax.*, org.* and sun.*. All but the sun.* packages are a standard part of the Java platform and will be supported into the future. In general, packages such as sun.*, that are outside of the Java platform, can be different across OS platforms (Solaris, Windows, Linux, Macintosh, etc.) and can change at any time without notice with SDK versions (1.2, 1.2.1, 1.2.3, etc). Programs that contain direct calls to the sun.* packages are not 100% Pure Java. In other words:

The java.*, javax.* and org.* packages documented in the Java 2 Platform Standard Edition API Specification make up the official, supported, public interface.
If a Java program directly calls only API in these packages, it will operate on all Java-compatible platforms, regardless of the underlying OS platform.

The sun.* packages are not part of the supported, public interface.
A Java program that directly calls into sun.* packages is not guaranteed to work on all Java-compatible platforms. In fact, such a program is not guaranteed to work even in future versions on the same platform.

For these reasons, there is no documentation available for the sun.* classes. Platform-independence is one of the great advantages of developing in the Java programming language. Furthermore, Sun and our licensees of Java technology are committed to maintaining backward compatibility of the APIs for future versions of the Java platform. (Except for code that relies on serious bugs that we later fix.) This means that once your program is written, the class files will work in future releases.

Each company that implements the Java platform will do so in their own private way. The classes in sun.* are present in the SDK to support the Sun implementation of the Java platform: the sun.* classes are what make the Java platform classes work "under the covers" for the Sun Java 2 SDK. These classes will not in general be present on another vendor's Java platform. If your Java program asks for a class "sun.package.Foo" by name, it may fail with ClassNotFoundError, and you will have lost a major advantage of developing in Java.

Technically, nothing prevents your program from calling into sun.* by name. From one release to another, these classes may be removed, or they may be moved from one package to another, and it's fairly likely that their interface (method names and signatures) will change. (From the Sun point of view, since we are committed to maintaining the Java platform, we need to be able to change sun.* to refine and enhance the platform.) In this case, even if you are willing to run only on the Sun implementation, you run the risk of a new version of the implementation breaking your program.

In general, writing java programs that rely on sun.* is risky: they are not portable, and are not supported.

Regular Expressions Across Multiple Lines

2008-01-30T08:17:00.000+05:30

I was looking at this huge java file which had hundreds of SQL statements and thousands of java code interleaved like a spaghetti ! What I really needed was to analyze all the SQL statements in the file since they were all related to a single application which we were supposed to modify. I needed a mechanism to extract all the SQL statements from the file for sake of brevity.

Simple regular expressions using vim or sed did not work since they all deal with a single line, but each one of them provide a mechanism to match regular expression over multiple lines.

sed - the following command will extract all lines between a 'select' and the first ';' following that. Hence you would have printed all the sql queries from a file


sed -ne '/^select/,/;/p' SqlIntensiveFile.java

vim - using the 'g' command can achieve the same. For e.g. the following will delete all the sql queries from the file.


%g/select/,/;/d

Formatting Oracle Timestamp

2008-01-23T18:43:00.001+05:30

create table temp (a timestamp)

insert into temp values(sysdate)

select to_char(a,'MM/DD/YYYY HH24:MI:SS:FF3') from temp

http://www.databasejournal.com/features/oracle/article.php/2234501

Oracle Instance Configuration Parameters

2008-01-23T17:21:00.000+05:30

To find out the parameters that oracle is using for configuring an instance, logon to that instance using sqlplus and execute the following command.

sql> show parameters

This will display list of all oracle configuration parameters with their current values

Block Select in Vim

2008-01-14T11:52:00.000+05:30

Go to the visual mode using "ctrl + v" instead of "v", then use the motion arrow keys *hjkl* to select the block you want.

Perform any copy/delete/edit function you would normally perform using vim ( y , d etc)!

GET POST PUT

2008-01-05T19:59:00.000+05:30

When a browser requests a normal page from a server, it uses the "GET" method. This is the standard way to get back information from a server. The information itself may come from a static page, a CGI program, a server-side include page or any other source handled by the server. By definition it is safe for a browser to obtain a page by GET as many times as it likes - it will never cause any permanent action on the server (such as entering a product order).

To perform a permanent action on the server, the "POST" method is used. This method must be handled by a program or script, and the browser should not re-request a POST page without getting the user to confirm it. This POST method is used when a script or program requires a lot of form data input or when the request makes the server perform a real action such as entering an order.

The "PUT" method is similar to the POST method in that it can cause information to be updated on the server. The difference is that the POST method is normally handed a script which is explicitly named by the resource (that is, something that already exists), while a PUT request could be directed at a resource which does not (yet) exist. Another difference is that the POST method can be used in response to a form, while the PUT method can only contain a single data item. The PUT method is suited for publishing pages.

Reference :
http://www.apacheweek.com/features/put

Unix Login Without Password (Setting login keys)

2007-10-18T15:02:00.001+05:30

Client : Machine from where you want to log-on
Server : Destination machine where you want to log-on from

1. On the client machine

Create the key(id_rsa) file with appropriate permissions

ssinghal@client$cd ~ssinghal/.ssh
ssinghal@client$touch id_rsa
ssinghal@client$chmod 600 id_rsa

Generate is_rsa file

ssinghal@client$ssh-keygen -t rsa

Press enter when you are prompted for a passphrase or for entering a file name ( accept the default)

Id is stored in ~ssinghal/.ssh/id_rsa

Your identification has been saved in /home/ssinghal/.ssh/id_rsa.
Your public key has been saved in /home/ssinghal/.ssh/id_rsa.pub.
The key fingerprint is:
2c:ce:0d:e4:53:83:d3:41:95:82:5f:cc:e5:8f:a1:6b ssinghal@MACHINENAME

2. copy the id_rsa.pub to server

Using any scp or ftp mechanism

3. On the server machine

SSH to the server machine and create keys file with appropriate permissions

ssinghal@server$cd ~ssinghal/.ssh/
ssinghal@server$touch authorized_keys2
ssinghal@server$chmod 600 authorized_keys2
ssinghal@server$cat id_rsa.pub >> authorized_keys2
( id_rsa.pub is client's public key)

Note: The username on client and server needs to be same ( If I am not mistaken)

Logout and from the client machine try to ssh again, you should be able to log-on with just your username

ssinghal@client$ ssh ssinghal@server

Formatting XML in vim

2007-10-12T12:04:00.001+05:30

":silent 1,$!xmllint --format --recover - 2>/dev/null"

http://www.vim.org/tips/tip.php?tip_id=349

Updated vim tips URL :

http://vim.wikia.com/wiki/Format_your_xml_document_using_xmllint

Eclipse Tools I Use

2007-10-12T10:25:00.001+05:30

This list keeps on growing and changing when I discover new plug-ins. Here is my current configuration of eclipse. Along with eclipse update sites.

Base Eclipse Version : 3.3.0 Europa, http://download.eclipse.org/releases/europa

Web Tools Platform : http://download.eclipse.org/webtools/updates
It Includes many cool features, best of which is JSP Debugging options and unbelievable support for editing WSDL files for web-services

JSEclipse: Javascript plug-in from Adobe(now), http://download.macromedia.com/pub/labs/jseclipse/autoinstall/

Subclipse, SVN plugin for eclipse : http://subclipse.tigris.org/update_1.2.x

Perl Editor : http://e-p-i-c.sourceforge.net/updates
I prefer VI to work with perl files, but fancy it for its auto-complete features.

ShellEd for browsing through shell scripts - No better way than VI to actually code and test them :)

Oracle - Common Datafile Operations

2007-10-01T18:24:00.000+05:30

Adding a table space

ALTER TABLESPACE users
ADD DATAFILE ‘/home/ssinghal/oradata/users01.dbf' SIZE 10M
AUTOEXTEND ON
NEXT 512K
MAXSIZE 250M

Adding a table space with minimal options

ALTER TABLESPACE name ADD DATAFILE ‘filespec’ SIZE 200M;

Altering a tablespace by adding a new datafile

ALTER TABLESPACE VPN2_LRG_TBLS
ADD DATAFILE '/home/ssinghal/oradata/users02.dbf' SIZE 100M
AUTOEXTEND ON
NEXT 1024K
MAXSIZE 250M

Resizing a data-file

alter database datafile '/home/ssinghal/oradata/users02.dbf' resize 500M

Dropping a datafile

alter database datafile 20 offline drop

Note : ID of datafile can be obtained from dba_data_file

Oracle Procedure Source code from Dictionary

2007-08-27T22:24:00.000+05:30

SELECT to_char(text)
FROM user_source
WHERE type IN ('PACKAGE' ,'PROCEDURE','TRIGGER')

Java Collections Overview

2007-08-19T12:10:00.002+05:30

Getopts with bash

2007-08-15T19:37:00.000+05:30

#!/bin/sh

usage()
{
      echo "Usage: $0 -a all -b ball -c -d -e";
      exit 1;
}

if [ $# -lt 1 ] ; then
      usage;
fi

# ":" decides which options require an argument
# In the example below options "a" and "b" will require a value to be passed along
while getopts a:b:cde opt
do
      case "$opt" in
              a) echo "hello $OPTARG";;
              b) echo "hello $OPTARG";;
              c) echo "c is selected";;
              d) echo "d is selected";;
              e) echo "e is selected";;
              \?) usage;;
      esac
done

UNIX - find cheet sheet

2007-07-11T20:03:00.000+05:30

Find all files named "foo" in directory "/" recursively
find / -name foo

Find all files named "foo" in directory "/"
find / -maxdepth 1 -name foo

Find all files name "foo" in current directory descending recursively
find . -name foo

Find all files starting with "foo" and ending with "bar" in the current directory
find . -name foo*bar
find . -name "foo*bar"

Find all files modified in the last seven days and tar them
find / -type f -mtime -7 | xargs tar -rf weekly_incremental.tar

Find all files named core and delete them
find / -name core | xargs /bin/rm -f
find / -name core -exec '/bin/rm -f {} ;'

Locate files modified less than 10 minutes ago
find / -mmin -10

locate files that are writeable by "others"
find . -perm +o=w

Locate files owned by a user
find . -name core -user ssinghal

Find mtime and mmin options
When specifying time with find options such as -mmin (minutes) or -mtime (24 hour periods, starting from now), you can specify a number "n" to mean exactly n, "-n" to mean less than n, and "+n" to mean more than n.
find . -mtime 0 # find files modified within the past 24 hours
find . -mtime -1 # find files modified within the past 24 hours
find . -mtime 1 # find files modified between 24 and 48 hours ago
find . -mtime +1 # find files modified more than 48 hours ago
find . -mmin +5 -mmin -10 # find files modifed between 6 and 9 minutes ago

moving around in bash

2007-07-10T11:34:00.000+05:30

when you are in bash , do as emacs does.

The default orientation of bash command line is emacs. And though I am a big vim fan, I have gotten used to emacs mode for command line. And as they say, old habits die hard!

Here are some shortcuts to help you move around on the command line .

ctrl + e : takes you to the end of a command

ctrl + a : takes you to the beginning of a command

esc + f : takes you one word forward

esc + b : takes you one word backward

esc + d : deletes a word and puts it in a buffer

crtl + k : deletes the line from current word and puts it in a buffer

ctrl + y : paste contents of buffer

Vim and Sqlplus

2007-07-10T11:24:00.000+05:30

open the following file :
$ORACLE_HOME/sqlplus/admin/glogin.sql
Add following line :
DEFINE _EDITOR='gvim -c "set filetype=sql"'

Typing edit will now open your favorite editor