What does where 1 1 mean in sql?

0 Answers  

---

Difference between global and parameter variables?

0 Answers   TCS,

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

What do you think about pl/sql?

0 Answers  

---

What is the differnce between view and materialized view

4 Answers   TCS,

---

What is RAC in oracle?

7 Answers   MCN Solutions,

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

0 Answers  

---

What are triggers and its uses?

0 Answers  

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers  

---

Can you inner join the same table?

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,

---

Why is sql important?

0 Answers  

---