In this article, You will be able to understand how to write a PL/SQL Program to Check Number is Odd or Even. An even number may be a number that will be divided into two equal groups. An odd number must be a number that can’t be divided into two equal groups. Even numbers end … Read more
Fibonacci Numbers are the sequence of numbers starting with zero and one. In this article, we will see how to write a PLSQL Program to find the Fibonacci series. For each of the following is sum of the previous two. 0,1,1,2,3,5,8,13,21,34,55… The Fibonacci Series Formula is given below With the selected values F0=0 and F1 … Read more
Given a number, your task to print the factorial of that number using PLSQL. Examples: Explanation: 4! = 4 * 3 * 2 * 1 = 24 Basic structure of PLSQL block Output (If given input as 3) 6 Conclusion Factorial, in mathematics, the value of all positive integers less than or equal to a … Read more
Prerequisite – PLSQL Introduction A PLSQL code is a groups of commands which are arranged within a block and block is a group of related declarations or statements. Now, let us see a practical example of the area and perimeter of rectangle. In declare part, we declare the list of variables and between begin and … Read more
Query: Write a PL/SQL block using the cursor to print the name salary of all employee working in the Sales department In this blog, we will see PLSQL Block using the cursor to print the name salary of all employees working in the sales department. Consider the employee table has the following columns based on … Read more
Here are the SQL Date Formats List. You can try yourself and look for the output. These SQL date formats list are useful in your interview point of view and also can be used in your professional SQL work environment depends on your requirements. Select TO_CHAR(date_column, ‘DD-MON-YYYY’) from emp21;Formats:d,dd,dddmm,mon,monthy,yy,yyy,yyyy,year select to_char(sysdate,’dd-mm-yyyy hh:mi:ss’) from dual; Select … Read more
Here is the list of Basic SQL Queries for the beginners. Simple Queries: 1. List all the employee details from the employee table Answer: Select * from employee; 2. List all the department details from the department table Answer: Select * from department; 3. List all job details from job table Answer: Select * from … Read more
Let us see the sensible example. Here i’m taking student table (student relation/ or student relational schema) . Here there are duplicate entries in the department information. I have highlighted the data where it has redundancy. Here we’ve 8 records in our table what if we got many records? It is a drag right? Let us say we’ve 100 students in our table for the CSE department, for … Read more