Akshay Sharma
21 followers
21 followers
Posts
Post has attachment
Operator Precedence in Sql.
In this article, we will see  Operator Precedence in Sql . When a complex expression has multiple operators, operator precedence determines the sequence in which the operations are performed. The order of execution can significantly affect the resulting val...
Operator Precedence in Sql.
sqlbyakshay.blogspot.com
Post has attachment
ORDER BY clause
In this article, we will see the   ORDER BY clause  Sql . The  SQL ORDER BY clause  is used to sort the data in ascending or descending  order , based on one or more columns. Some database sorts query results in ascending  order  by default. Syntax SELECT c...
ORDER BY clause
sqlbyakshay.blogspot.com
Post has attachment
wow.
Pattern T
anypatterns.blogspot.com
Post has attachment
pl sql program for 'palindrome'
Write a program in PL/SQL to check whether a number is a palindrome or not. In this article, we will see the program for Palindrome in Pl/Sql. A  palindrome  is a word, phrase, number, or other sequence of characters which reads the same backward or forward...
Post has attachment
Reverse Of a Number
Write a program in PL/SQL to print the reverse of a number. According to the problem if a number  is 677 then it should print 776. Program Code: SQL> set serveroutput on SQL>Declare 2 num number:=&n; 3 rev number:=0; 4 Begin 5 while(num>0) 6 Loop 7 rev:=rev...
Post has attachment
PL/SQL Fibonacci Sequence
Write a PL/SQL code to get the Fibonacci Sequence. First, I will explain what is Fibonacci Sequence and how to get this series. So, Fibonacci Sequence is a series of numbers 0,1,1,2,3,5,8,13,21............. In Fibonacci Sequence, first and second elements a...
Post has attachment
PL/SQL factorial program
Write a program in PL/SQL to print the factorial of a number. In this post I will explain how to get the factorial of any given number. For that first you need to know what is the procedure to find the factorial of a number. To get the factorial of any give...