Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

What is difference between SUBSTR and INSTR?

Question Posted / parthasarathi

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is insert autocommit in oracle?

1068

How to drop an index?

959

How to bring a tablespace offline?

1065

List the types of joins used in writing subqueries?

998

How to run queries on external tables?

1048

What are the differences between date and timestamp in oracle?

1046

Write a trigger example in oracle?

1066

What is a database table in oracle?

1023

Explain oracle left join with an example?

1013

What is analyze command used for?

1073

Can we create database in oracle using command line ?

1088

How to create a new oracle data file?

1032

What language does oracle use?

1103

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1842

Point out the difference between user tables and data dictionary?

983