Answer / sudhakar & co

select rownum from table_name;

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 many types of relationship are there?

0 Answers  

---

Write an sql query to select all records from the table?

0 Answers  

---

what is the difference between char_length and length? : Sql dba

0 Answers  

---

What is a sql schema used for?

0 Answers  

---

What is partition in sql query?

0 Answers  

---

Why do we use set serveroutput on?

0 Answers  

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

---

how to rename an existing column in a table? : Sql dba

0 Answers  

---

Show the two pl/sql cursor exceptions.

0 Answers  

---

How to convert comma separated string to array in pl/sql?

0 Answers  

---

what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,

---