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 problem one might face while writing log information to a data-base table in pl/sql?

1153

---

Are pl sql variables case sensitive?

1043

---

what are the types of join and explain each? : Sql dba

1032

---

Why sql query is slow?

981

---

What is a unique constraint?

1065

---

What is before and after trigger?

949

---

How can I change database name in sql?

1069

---

What are the steps for performance tuning.

1326

---

What is nested table in pl sql?

1060

---

What are the types of functions in sql?

1010

---

what is rollback? : Sql dba

1096

---

Explian rowid, rownum?

1004

---

Is pl sql still used?

971

---

what are the type of locks ? : Sql dba

957

---

What are the events on which a database trigger can be based?

1179

---