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

How to Write Simple Subqueries in SQL?

In this article, we will see what is sub query in SQL and its use. Also we will write simple sub queries with practical examples. In simple words a sub query is nothing but a query inside query. Many times you would like to have a series of SQL chained where an output of one … Read more