How does cross join work in sql?

0 Answers  

---

Can ddl statements be used in pl/sql?

0 Answers  

---

What sql does db2 use?

0 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

What is error ora-01000: maximum open cursors exceeded

0 Answers  

---

---

what is bdb (berkeleydb)? : Sql dba

0 Answers  

---

Which join is like inner join?

0 Answers  

---

what is online transaction processing (oltp)? : Sql dba

0 Answers  

---

Define overloaded procedure?

0 Answers  

---

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

---

what is meant by forward declaration in functions?

4 Answers   TCS,

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---