Answer Posted / 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')

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5388

---

What do you mean by redo log file mirroring?

1008

---

Explain the use of rows option in exp command.

1068

---

How to convert character types to numeric types?

1096

---

What is a tns file?

976

---

How to login to the server without an instance?

1144

---

Explain oracle’s server parameter file.

971

---

What is not equal to in oracle?

980

---

How to put more than 1000 values into an oracle in clause?

1010

---

State the various uses of dbcc command?

1037

---

What is the use of file param in imp command?

1146

---

What is the difference between truncate & delete command?

1163

---

Can you tell me how to add new column in existing views?how?How is possible?

1419

---

How to define a data field as not null?

1091

---

List the types of joins used in writing subqueries?

980

---