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  

---

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 Answers  

---

What are the composite date types in oracle?

6 Answers   HCL,

---

What is Read-Only Transaction ?

3 Answers  

---

How to do a full database export?

0 Answers  

---

---

What is an oracle tablespace?

0 Answers  

---

what is difference between DBMS and RDBMS?

2 Answers   Metric Stream,

---

can a view be updated?

3 Answers  

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

Can we create more than one constraint to column ?

6 Answers  

---

How to load excel data sheet to oracle database

0 Answers  

---

Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?

2 Answers   IBM,

---