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...

Difference between SUBSTR and INSTR?

Answer Posted / shrikant

Hi,
Yes Tulsi is right.
Execute the below queries & you will see the diff clearly -

SELECT instr('hello','e') FROM dual
SELECT substr('hello',2,3) FROM dual

Is This Answer Correct ?    34 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does stored procedure reduce network traffic?

978


What are the different dcl commands in sql?

1086


Can we use commit inside a trigger?

1043


What is foreign key in sql with example?

898


What is the difference between the conventional and direct path loads? : aql loader

1335


Is ms sql traffic encrypted?

882


What do we need to check in database testing?

978


Can we join same table in sql?

975


Who is the owner of mysql database?

1012


What is a scalar value in sql?

1024


What is cursor in pl sql?

1069


how would concatenate strings in mysql? : Sql dba

1037


How can we link a sql database to an existing android app?

992


What are the different types of dbms?

972


Is sql a microsoft product?

905