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 »