Answer Posted / anjum

There are four types of joins

Inner join (Equi join,Non Equi join)
Outer join (Left outer, Right outer,Full outer)
Self join
Cartesian join

Explain what are the type of synonyms?

1094

---

Is oracle an open source?

1061

---

How to load data from external tables to regular tables?

1041

---

What is the sql query to concatenate column values from multiple rows in oracle?

1036

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2541

---

What is the relationship among database, tablespace and data file?

965

---

How to define a record variable to store a table row?

1041

---

if you ctreate table identity

2353

---

Which is better Oracle or MS SQL? Why?

6343

---

How to generate query output in html format?

1094

---

What is oracle rownum?

931

---

6. Display the client name and order date for all orders using the traditional method.

2291

---

How translate command is different from replace?

1059

---

How do I uninstall oracle 11g?

1095

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2002

---