Answer Posted / avi007

full outer join -

select * from table1,table2 where
table1.columnname(+)=table2.colunmname;
union
select * from table1,table2 where
table1.columnname =table2.colunmname(+);

What is an alias command?

1068

---

What sql does db2 use?

983

---

What is file based approach?

941

---

Describe different types of general function used in sql?

1038

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2223

---

What are keys in sql?

1000

---

Explain what is a subquery ?

1188

---

what does it mean to have quoted_identifier on? : Sql dba

1146

---

How do you drop a trigger?

992

---

What is substitution variable in pl sql?

1045

---

What is the difference between cluster and non-cluster index?

1108

---

What is Difference Between Unique and Primary Key Constraints?

1107

---

Can we connect to postgresql using sql developer?

1009

---

What is write ahead logging in sql server?

1052

---

Is sql difficult?

1162

---