Difference between SQL and PL/SQL

Here you will learn about difference between SQL and PL/SQL. SQL and PL/SQL are two popular database technologies. These two topics are very frequently asked in database interviews. In this article I have shared the key differences between these two technologies. Also Read: PL/SQL Interview Questions and Answers Image Source Difference between SQL and PL/SQL S.… Read More »

Producer Consumer Problem in C

Here you will learn about producer consumer problem in C. Producer consumer problem is also known as bounded buffer problem. In this problem we have two processes, producer and consumer, who share a fixed size buffer. Producer work is to produce data or items and put in buffer. Consumer work is to remove data from… Read More »

Program for Shell Sort in C and C++

Here you will get program for shell sort in C and C++. Shell short is an improved and efficient version of insertion sort. In this algorithm we sort the pair of elements that are far apart by gap h. The process is repeated by reducing h until it becomes 1. Program for Shell Sort in… Read More »

Android Upload Image to Server Using Volley

Here you will learn about android upload image to server using volley library. At server side I have used java web service and for sending image to server volley library is used. How it works? The user chooses an image from gallery and click on upload button. The image is then converted into Base64 string… Read More »

PL/SQL Program to Reverse a String

Here you will get pl/sql program to reverse a string. The substr() function returns a part of string. It has following syntax. substr(string, position, length); We will use this function to extract character by character from string in reverse order and concatenate it previous extracted character. || is used to concatenate string. In this way string… Read More »

PL/SQL Program to Check Number is Odd or Even

Here you will get pl/sql program to check number is odd or even. A number is even if it is completely divisible by 2 otherwise it is odd.   PL/SQL Program to Check Number is Odd or Even

  Output Enter value for n: 7 old   2:        n number:=&n; new   2:        n number:=7; number… Read More »

PL/SQL Program for Fibonacci Series

Here you will get pl/sql program for fibonacci series. It is a series in which next number is the sum of previous two numbers.   PL/SQL Program for Fibonacci Series

  Output Enter value for n: 6 old 5: n number:=&n; new 5: n number:=6; Fibonacci series is: 0 1 1 2 3 5… Read More »

PL/SQL Program for Reverse of a Number

Here you will get pl/sql program for reverse of a number. For example: Number = 34589 Reverse of number = 98543   PL/SQL Program for Reverse of a Number

  Output Enter value for n: 4578 old 8: n:=&n; new 8: n:=4578; reverse is 8754