Monday, April 27, 2009

Query

-- to be used in Sql* plus or some other editor
Set Serverout put on;

DECLARE
MULTIPLICATION_TABLE_FOR NUMBER;
J NUMBER:=0;
L NUMBER;
BEGIN
MULTIPLICATION_TABLE_FOR:=&MULTIPLICATION_TABLE_FOR;
FOR J IN 1..10 LOOP
L:=MULTIPLICATION_TABLE_FOR*J;
DBMS_OUTPUT.PUT_LINE(MULTIPLICATION_TABLE_FOR||'x'||J||'='||L);
END LOOP;
END;

Tuesday, April 21, 2009

Programs for u..

set serveroutput on;

DECLARE
I NUMBER:=0;
J NUMBER:=1;
V NUMBER;
L NUMBER:=2;
Limit NUMBER:=0;
BEGIN
DBMS_OUTPUT.PUT_LINE(I);
DBMS_OUTPUT.PUT_LINE(J);
Limit:=&Limit;
LOOP
L:=L+1;
V:=I+J;
I:=J;
J:=V;
DBMS_OUTPUT.PUT_LINE(J);
EXIT WHEN L=Limit;
END LOOP;
END;

Friday, April 17, 2009

Qoutes for u.

Ability is nothing without opportunity. - Napoleon Bonaparte.

Behind an able man there are always other able men. - Chinese Proverb.

The palest ink is better than the best memory. - Chinese Proverb.

A concept is stronger than a fact. - Charlotte Perkins Gilman.

Ideas are the roots of creation. - Ernest Dimnet.

There is time for everything. - Thomas Edison.

The buck stops with the guy who signs the cheques. - Rupert Murdoch.

Examine what is said, not who speaks. - Arabian Proverb.

There are those that say, and those that do. - Andrew Campbell.

Everyone must row with the oars he has. - English proverb.

When policy fails try thinking. - American Business Maxim.

What's not worth doing is not worth doing well. - Don Hebb.

Statistics - figures used as arguments. - Leonard Louis Levinson.

There is always a better way. - Thomas Edison.

The world is full of cactus,but we do not have to sit on it, - Will Foley.

Business is a combination of war and sport, - Andre Maurois

What we see depends mainly on what we look for. - John Lubbock.

Nothing is a waste of time, if you use the exeperience wisely - Rodin.

Most of the critical things in life,which become the starting points, of human destiny, are little things.
- R. Smith.