Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between SUBSTR and INSTR?
- 1 Answers
- 3050 Views
- I also Faced
- E-Mail Answers
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')
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between SQL and SQL Server?
what is IDE,DMV in sql server?
How to create a new table by selecting rows from another table?
What are the differences between primary key and unique key?
How do I find the database name in oracle?
What is a relational database management system?
How to create a table index in oracle?
Why is oracle used?
How to save query output to a local file?
How to start your 10g xe server from command line?
Explain database link?
What is meant by a deadlock situation?
Oracle General 
