Answer / parthasarathi

substr is used to get part of a string, instr is used to get particular string's position.

syntax of substr:-

substr(string,from which character we want,[how many characters we want])

syntax of instr:-

instr(string,'character')

State any two functions of oracle?

0 Answers   Aricent,

---

select statement does not retrieve any records. what exception is raised?

2 Answers  

---

What is tns name?

0 Answers  

---

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers   Zensar,

---

what are steps for interface? where is exchange rate defined in which table?

0 Answers  

---

What is recovery manager in Oracle?

0 Answers   MCN Solutions,

---

Please explain joins in oracle?

0 Answers  

---

What are the advantages of oracle 12c?

0 Answers  

---

What is the difference between Outer join and Full outer join?

5 Answers  

---

How can we find out the duplicate values in an oracle table?

0 Answers  

---

What is the difference between 10g OEM and 11g OEM?

0 Answers   MCN Solutions,

---

what is host string in sql plus? how does it related to database?

1 Answers  

---