Answer Posted / john

Depending on condition existence
----CROSS JOIN (synonyms also CARTESIAN JOIN, CARTESIAN PRODUCT)
----NATURAL JOIN
----# NAMED COLUMNS JOIN - syntactic notation joining source
tables on user defined columns having the same name. This is
less dangerous than Natural join and just short form of
writing Equi joins on some common columns joined together.
Named columns joins always are Equi joins.
----# CONDITIONAL JOIN - fully controllable syntax by user.
This is the most widespread and most useful syntactic
convention. Depending on used predicates in join condition
it may be Equi join as well as Non-equi join.

Depending on row selection
INNER JOIN
OUTER JOIN--- left,right,full

Depending on comparison operator
equi Non-equi

Depending on used tables
SELF JOIN

What is blob datatype?

1132

---

What is a data lock in oracle?

1125

---

How do I start tns listener?

1047

---

Where do you use decode and case statements?

996

---

I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2185

---

What do you mean by cdb and pdb in oracle 12c?

1062

---

What is Virtual Private Database in Oracle?

1091

---

How to write a query with a left outer join in oracle?

1065

---

How can I create database in oracle?

1028

---

What is a system tablespace and when it is created?

972

---

How to check the server version in oracle?

1094

---

How to see the table columns used in an index?

1024

---

How to execute a stored procedure in oracle?

1091

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1990

---

When do you get a .pll extension in oracle? Explain its importance

1042

---