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

How can we view last record added to a table?

968

What is the scope of a local variable?

992

how to clone 9i Database on to 10g Database.

2284

How many data types are supported?

1016

What is SQL Tuning Advisor in Oracle?

1105

How to estimate disk space needed for an export job?

989

What is a data dictionary and how can it be created?

1053

How to create an oracle database manually?

1017

Why do we need oracle client?

881

Can multiple columns be used in group by in oracle?

925

What is an oracle cursor variable?

1000

How to check the oracle tns settings?

987

Where are the settings stored for each instance in oracle?

1060

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2242

What is an oracle data file?

1035