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...

Add a comment...

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...

Add a comment...

Post has attachment

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...

Add a comment...

Post has attachment

Public

**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...

Add a comment...

Post has attachment

Public

**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...

Add a comment...

Post has attachment

Public

**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...

Add a comment...

Post has attachment

**Difference function**

Given a City table, whose fields are described as +

Add a comment...

Post has attachment

**'Shortest' and 'Longest' cities name**

Given a table STATION that holds data for five fields namely ID, CITY, STATE, NORTHERN LATITUDE and WESTERN LONGITUDE. +

Add a comment...

Post has attachment

**Selecting 'Consonants '**

Given a table STATION that holds data for five fields namely ID , CITY , STATE , NORTHERN LATITUDE and WESTERN LONGITUDE . +

Add a comment...

Wait while more posts are being loaded