What are tuples in sql?

0 Answers  

---

Does a primary key have to be a number?

0 Answers  

---

Can we use join in subquery?

0 Answers  

---

define join and explain different type of joins? : Sql dba

0 Answers  

---

What is a join query?

0 Answers  

---

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

---

What is a record in a database?

0 Answers  

---

Is it possible to create startup or shutdown trigger for on-schema?

0 Answers  

---

What are database links used for?

0 Answers  

---

How do you retrieve the last N records from a table?

10 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,

---

Explain the concept of normalization.

3 Answers  

---