Answer Posted / elumalai d

UNOIN:- It returns all the records from both tables without duplicates.
Example:-
A={1,2,3,4}
B={2,3,4,5,6}
AUB={1,2,3,4,5,6}

CREATE TABLE question36 (empid NUMBER);
CREATE TABLE quest36 (empid NUMBER);

INSERT INTO question36 VALUES(1);
INSERT INTO question36 VALUES(2);
INSERT INTO question36 VALUES(3);
INSERT INTO question36 VALUES(4);

INSERT INTO quest36 VALUES(2);
INSERT INTO quest36 VALUES(3);
INSERT INTO quest36 VALUES(4);
INSERT INTO quest36 VALUES(5);
INSERT INTO quest36 VALUES(6);
COMMIT;

SELECT empid FROM question36
UNION
SELECT empid FROM quest36;

EMPID
---------
1
2
3
4
5
6

DELETE FROM question36;
DELETE FROM quest36;
COMMIT;

MINUS:- It returns table A values not available in table B.
Example:-
A={1,2,3,4}
B= {2,3,5}
A-B={1,4}

INSERT INTO question36 VALUES(1);
INSERT INTO question36 VALUES(2);
INSERT INTO question36 VALUES(3);
INSERT INTO question36 VALUES(4);

INSERT INTO quest36 VALUES(2);
INSERT INTO quest36 VALUES(3);
INSERT INTO quest36 VALUES(5);
COMMIT;

SELECT empid FROM question36
MINUS
SELECT empid FROM quest36;

EMPID
---------
1
4

DROP TABLE question36;
DROP TABLE quest36;

Name the operator which is used in the query for pattern matching?

931

---

Are pl sql variables case sensitive?

1035

---

what are the t string functions available in tsql? : Transact sql

993

---

Explain ttitle and btitle.

1109

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

956

---

Explain the components of sql?

1046

---

How do I remove sql plus from windows 10?

1079

---

What are stuff and replace function?

1069

---

How do I make sql search faster?

982

---

What are the two types of exceptions in pl/sql?

1028

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1330

---

How do you sort in sql?

993

---

Explain lock escalation? : Transact sql

1176

---

What is a sql statement?

940

---

What does sql stand for?

978

---