Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between SUBSTR and INSTR?
- 1 Answers
- 3038 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 a procedure in oracle?
How to use "if" statements on multiple conditions?
How to write text literals in oracle?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How do we create privileges in oracle?
What language does oracle use?
How to export your connection information to a file?
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
what is candidate key & super key
How to name query output columns in oracle?
Oracle General 
