Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between SUBSTR and INSTR?
- 1 Answers
- 2940 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 use of aggregate functions in oracle?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
What are the different editions of oracle?
Difference between varchar and varchar2 data types?
What is Data Block ?
What is oracle server autotrace in oracle?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
what are actual and formal parameters?
please explain.. DB architecture ...
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Is insert autocommit in oracle?
What is a Private Synonyms ?
Oracle General 
