Neeraj Mishra

A crazy computer and programming lover. He spend most of his time in programming, blogging and helping other programming geeks.

SQL Server Tuning for Faster Queries

Your SQL Server Compact is capable of lightening-fast performance and stunningly efficient service even while handling huge work loads. But without regular SQL sever performance tuning, you can’t expect it to “win the race” any more than a race car could without regular tune ups. You will have an opportunity to read in-depth information about …

SQL Server Tuning for Faster Queries Read More »

PL/SQL Program to Print Patterns

Here you will get plsql programs to print patterns of stars, numbers and alphabets. Pattern 1: * ** *** **** ***** declare n number:=5; i number; j number; begin for i in 1..n loop for j in 1..i loop dbms_output.put(‘*’); end loop; dbms_output.new_line; end loop; end; /

PL/SQL Program to Find Greatest of Three Numbers

Here you will get plsql program to find greatest of three numbers. declare a number:=10; b number:=12; c number:=5; begin dbms_output.put_line(‘a=’||a||’ b=’||b||’ c=’||c); if a>b AND a>c then dbms_output.put_line(‘a is greatest’); else if b>a AND b>c then dbms_output.put_line(‘b is greatest’); else dbms_output.put_line(‘c is greatest’); end if; end if; end; / Output a=10 b=12 c=5 b is …

PL/SQL Program to Find Greatest of Three Numbers Read More »