Answer / gretta

The WHEN clause with POSITION can be used to skip header and footer records.

what are the differences between char and varchar? : Sql dba

0 Answers  

---

Can primary key be changed?

0 Answers  

---

What does select count (*) mean in sql?

0 Answers  

---

Mention what is the function that is used to transfer a pl/sql table log to a database 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,

---

What are wait events. Describe the wait event tables.

1 Answers   CTS,

---

Name the different types of indexes in sql and define them.

0 Answers  

---

Explain the advantages and disadvantages of stored procedure?

0 Answers  

---

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

---

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

What is a cursor for loop ?

4 Answers  

---

what is sql and plsql

6 Answers  

---