Area and Perimeter Of Rectangle in PLSQL

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

PL/SQL block using the cursor to print all employees working in the Sales department

Query: Write a PL/SQL block using the cursor to print the name salary of all employees working in the Sales department In this blog, we will see PL/SQL 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

SQL Date Formats List Updated(2020)

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

What is Normalization in DBMS? Complete Guide Updated (2021)

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

It’s All About (The) DATA INTEGRATION

Software Development Life Cycle. Software Development Life Cycle.SDLC (Software Development Life Cycle) may be a set of steps that a team will absorb order to form sure that they build a correctly functioning application. So with this complete process, there are many of us they’re getting to get on this team and that they are performing on different parts of the development of this application. Looking at the below Requirements Design Implementation Verification Maintenance … Read more

Very Easy Method SQL Count Consecutive Rows Updated (2021)

In this article, we’ll see the way to count consecutive rows in SQL with practical examples. this is often one of the foremost important and commonly used real-time SQL concepts. I am sure you’ll get a clear picture about this subject so confirm to read this text till the end. At the end of this … Read more

What is the Use of a truncate table in SQL? Updated 2021

Use of truncate table in SQL Let us see what exactly is that the truncate table in SQL and what’s the utilization of it. At the end of this article, I also captured the video explanation for your better understanding, so confirm to observe that video also. So what’s truncate table in SQL?. In one word It simply removes all the rows from a table. The syntax for truncate … Read more