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')

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

0 Answers   Oracle,

---

What are various constraints used in SQL?

1 Answers   Polaris,

---

Explain enable novalidate constraint.

0 Answers  

---

Point out the difference between user tables and data dictionary?

0 Answers  

---

What is an Index Segment ?

2 Answers  

---

---

What is a Garbage Collection? and what is full recursive Garbage collection?

0 Answers   RBS,

---

Explain compound trigger in oracle?

0 Answers  

---

What is integrity and what is constraint??Explain with example

0 Answers   Google,

---

what is normalisation?what are its uses?

0 Answers  

---

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

1 Answers   BirlaSoft,

---

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

0 Answers  

---

Can we create more than one index on particular column?

1 Answers  

---