Answer / subbareddy

up to 2 gb

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,

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

what is rdbms? : Sql dba

0 Answers  

---

How do I view stored procedures?

0 Answers  

---

Is left join same as inner join?

0 Answers  

---

---

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---

How do you declare a constant?

0 Answers  

---

What are the most important ddl statements in sql?

0 Answers  

---

What is sql*loader and what is it used for? : aql loader

0 Answers  

---

How do you update a table in sql?

0 Answers  

---

Show how functions and procedures are called in a pl/sql block.

0 Answers  

---

What are the advantages of indexing?

0 Answers  

---