How to write a query with an inner join in oracle?

0 Answers  

---

does Oracle has only one table space?

1 Answers   Oracle,

---

What is Oracle table?

1 Answers  

---

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,

---

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

0 Answers   Wipro,

---

State some uses of redo log files?

0 Answers  

---

Can group functions be mixed with non-group selection fields?

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  

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

0 Answers   Infosys,

---

How to convert characters to numbers in oracle?

0 Answers  

---

Can you have more than one content canvas view attached with a window ?

0 Answers   Oracle,

---

What is an Oracle Instance?

0 Answers  

---