Answer Posted / siddiq

In oracle joins, there is no need to mention the words like
left outer join, right outer join, etc..
Oracle joins sql joins
-------------------------------------------------
self join Natural join
cross join Arbitary join
outer join Left outer join
Equi join Right outer join
Non Equi join Full outer join

In sql server we have to use the words(join) in the query.

What does sign mean sql?

1178

---

what is row? : Sql dba

1275

---

how to include comments in sql statements? : Sql dba

999

---

What is the difference between partitioning and sharding?

1049

---

What is the difference between python and sql?

1051

---

What is asqueryable?

1035

---

What is a trigger word?

1076

---

Explain how exception handling is done in advance pl/sql?

1043

---

What is clustered index sql?

1030

---

Where the sql database files are stored?

1072

---

How to use distinct and count in sql query? Explain

1080

---

How do you remove duplicate records from a table?

978

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1007

---

What is the importance of sqlcode and sqlerrm?

1390

---

What is the difference between the sql*loader and import utilities? : aql loader

1088

---