Non body animation(.gif)

Can someone show/tell/link me to creating animation in SL(.gif like animation) what program is used?

The only program most people use to animate textures is the basic LSL scripting language. You'd probably have better responses to this question if you posted it in the Scripting Tips forum, but for the most part it involves the
llSetTextureAnim(ANIM_ON | LOOP, ALL_SIDES, x, x, x, x, x.x) command.

If you can find yourself a freebie fireplace with full perms, check out how the prim for the fire itself is set-up.

Here is the function description and details:
http://rpgstats.com/wiki/index.php?title=LlSetTextureAnim

Essentially, you need to make a single texture broken into frames. For example, we have six frames we'd like to play, here labeled A,B,C,D,E,F. Our texture would look like this:

A B C
D E F

To loop the animation from A to F at .2 seconds for each frame, you would drop this script in:

default
{
state_entry()
{
llSetTextureAnim(ANIM_ON | LOOP, ALL_SIDES, 3, 2, 0, 0,0.2);
}
}

Note that this animates all sides of the prim. To animate just one side, put a number in corresponding to the side you want. How to determine that number is explained here:
http://rpgstats.com/wiki/index.php?title=Side

3 and 2 are the number of frames horizontally and vertically (that's how the function knows where you are splitting your images). The next two numbers set the start and end points (here, we want it to do the whole thing, starting from A). The final number is the speed.

Hope that helps!