3 Reasons Why Students Need to Change Their OS to Linux

3 Reasons Why Students Need to Change Their OS to Linux

Technology has been on the rise throughout the past several decades. Every new generation has been getting savvier and savvier about devices around them. Electronics now make up an essential part of virtually any sphere of our lives. And with every passing day, it becomes harder and harder to ignore the need to study up ... Read more 3 Reasons Why Students Need to Change Their OS to Linux

How to create a sequence which start with 1 and next value will be 0 and then next value is 1 and then 0 .. and so on ... is this possible ?

SQL> CREATE SEQUENCE TEST_SEQ_A            START WITH 1            MINVALUE 0            MAXVALUE 1            INCREMENT BY -1            NOCACHE            ORDER            CYCLE ; SQL> Insert ... Read more How to create a sequence which start with 1 and next value will be 0 and then next value is 1 and then 0 .. and so on ... is this possible ?

Host gets stuck at certain percentage while entering maintenance mode in Full Data Migration (VMware, vSAN)

Host gets stuck at certain percentage while entering maintenance mode in Full Data Migration (VMware, vSAN)

Problem Statement:  Host stuck at a 68% (certain percentage) while entering vSAN Maintenance Mode. When you enter a vSAN Maintenance mode with option "Full data migration", its bound to take long time depending upon the size of the diskgroups. "Full data migration" mode will ensure evacuation of all components to other hosts in the cluster. ... Read more Host gets stuck at certain percentage while entering maintenance mode in Full Data Migration (VMware, vSAN)

what is the difference between sub-query and co-related sub-query?

Sub-query The inner query execute first, the outer query deprnds on inner query output. Correlated sub-query The outer query execute first, the inner query deprnds on outer query result. A correlated sub-query is where the sub-query part makes reference to values from the outer query. ------------------------------------------------------------------------------------------------------------------------------ SELECT emp1.emp_id, emp1.last_name, emp1.job_id, emp1.department_id from employee emp1 WHERE ... Read more what is the difference between sub-query and co-related sub-query?

How to Remove Duplicate Rows from a Table

Use rowid pseudo column. All you have to do is to keep the latest data (i.e. highest ROWID) and remove other duplicated rows. SELECT * FROM table1 a WHERE rowid < (SELECT max(rowid) FROM table1 b WHERE a.column1 = b.column1 AND etc...); OR create table testtt (num number); insert into testtt values(111); insert into testtt ... Read more How to Remove Duplicate Rows from a Table

How to generate ER diagram using Oracle SQL developer

How to generate ER diagram using Oracle SQL developer

Tool Used : SQL Developer version 3.1.07 Schema Used : HR Tables Used : Countries, Departments, Employees, Job_History, Jobs, Locations, Regions Navigate the below path and step by step screen shots: File > Data Modeler > Import > Data Dictionary 1# Select DB Connection and click on next 2# Select Schema/DB you wish to import ... Read more How to generate ER diagram using Oracle SQL developer