Answer Posted / kavithanedigunta

full outer join in 10 g

select a.*,d.dname
from emp a
full outer join
dept d on
a.DEPTNO = d.DEPTNO

full outer join in 9i

select a.* ,d.DNAME
from emp a, dept d
where a.DEPTNO = d.DEPTNO

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2503

---

what are the security recommendations while using mysql? : Sql dba

1124

---

How do you update f as m and m as f from the below table testtable?

1860

---

Are stored procedures faster than queries?

949

---

What is parameter substitution in sql?

1035

---

What are the different operators available in sql?

1007

---

What is a dynamic query?

1030

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1105

---

What is oracle and pl sql?

1123

---

What is the life of an sql statement?

1024

---

What is the difference between left and left outer join?

950

---

Is sql sequential or random?

1041

---

What is rollback?

1118

---

how can you see all indexes defined for a table? : Sql dba

1002

---

Explain character-manipulation functions?

1141

---