Difference between join and a subquery?

8 Answers   Base Automation, NMDC,

---

which is the best training centre for learning oracle?

13 Answers  

---

What do you mean by merge in oracle and how can you merge two tables?

0 Answers  

---

6. Display the client name and order date for all orders using the traditional method.

0 Answers   Wipro,

---

How to change user password in oracle?

0 Answers  

---

Explain the blob datatype?

0 Answers  

---

how to retrieve daily sal from emp table in oracle 10g

2 Answers   Infosys,

---

What are the different types of database objects?

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---

what are the disadvantages of hierarchial database over RDBMS?

1 Answers   TCS,

---

what are archived logs?

0 Answers  

---

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 Answers  

---