Answer / bhakti

select length(trim('ram charan singh')) - length (replace
(trim ( 'ram charan singh'),' ','')) +1 from dual

Answer / sanjaya

select regexp_count('RAM CHARAN SINGH','s')+1 from dual;

Answer / joel

select count('ram charan singh') dual;

How to get a list of all tables in the database?

1 Answers  

---

What are the different types of modules in oracle forms?

0 Answers  

---

does the query needs a hint to access a materialized view?

1 Answers  

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,

---

How to use existing values in update statements using oracle?

0 Answers  

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

0 Answers  

---

I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

0 Answers   Cisco,

---

What is the difference between primary key and unique key and foreign key in oracle?

0 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers  

---

How to retrieve first and last records from a table?

7 Answers   DELL, QSmart,

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---