Contact us

 

Comments

Post a Comment

Popular posts from this blog

Difference between union and union all in oracle sql plsql

Image
"This is one of the most important questions that interviewer might be asking in an interview.Infyosis,Linked group,Kyndryl,Vodafone Idea, IBM and Mphasis etc." INTRODUCTION: It is said to be set operators which is used to combine, add or concatenate two or more result sets. It is used in the multiple select statements where to combine to produce the final desired results. In other words, multiple select statements of similar column name in same order and having same data type to produce the unified result. It merges the content of the two structurally compatible organized tables into single table.  In MIS datalake,when you are adding the modules of GST reconciliation which is to be used in micros in Excel or VB script, union and union all set operator is preferred for eliminating duplicate records or keeping duplicate records as per business requirement. There are several alternatives like bulk collect,join,set operators like intersect & minus for combining the data from...
Read more

Difference between full join and cross join-oracle sql plsql

Image
 Difference between full join and cross join in sql:- They behave differently to combine the rows from the two tables. FULL OUTER JOIN: It is also called as the full join .It will return all the rows when there is either match in the left table or right table. If there is no match, it will return NULL for the rows of the columns which is lacking the matching rows. Syntax: select c.*,d.*  from tableC c FULL OUTER JOIN tableD d on c.id=d.id; select e.ename,d.dname from emp e FULL OUTER JOIN dept d ON e.deptno=d.deptno; When you want to retain the unmatched rows i.e operations which is not present in the emp table and having deptno as 40.So,ename is appeared as NULL. CROSS JOIN: It returns the cartesian product of both the tables i.e. Every row of the table A is combined with every row of the table B.ON condition is not used due to not match rows. Syntax: select c.*.d.* from tableC c CROSS JOIN tableD d; select e.ename,d.dname from emp e CROSS JOIN dept d; ENAME ...
Read more

Introduction to Linux Tutorial in English

Image
 Introduction: It is an operating system which is much like Microsoft window and apple Macintosh. It is open source and freely available without any cost. It is Unix like computer operating system which are assembled at free cost and under open-source software development & distribution. It shares the kernel and has gnu utilities. It comes in different variations to serve different purposes of end users. Debian: It is well known for its reliability and extensive package repository which may be used for both production and development environments. Red hat: It is used in server environments. Linux mint: It is suitable for beginners who want to compare with Microsoft os.Fedora: It is popular choice for the developers and perfect platform for software testing and development. Gentoo Linux: It is used by advanced users. CentOS: It is used in server environments. Ubuntu: It is used by the beginners. OpenSUSE: It is preferred by system administrators.Archlinux: It is used by advanced...
Read more