Binary Search in C

Here you will get program for binary search in C. Binary search algorithm can be applied on a sorted array to search an element. Search begins with comparing middle element of array to target element. If both are equal then position of element is returned. If target element is less than middle element of array …

Binary Search in C Read More »

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 »