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

Write a sql to print only character form the below string.
@So&*CIE%$TE@GEN!@RAL

Answer Posted / santosh

select regexp_replace('@So&*CIE%$TE@GEN!@RAL','[^a-zA-Z]') from dual

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is function and procedure in pl sql?

975


What can you do with pl sql?

1034


Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2230


Explain the difference between drop and truncate commands in sql?

964


How do I find duplicates in sql?

879


What are pl sql data types?

956


how would you get the current date in mysql? : Sql dba

915


Explain what is a database?

1039


What are the popular database management systems in the it industry?

929


Explain the difference between rename and alias?

966


What is set serveroutput on in pl sql?

1199


What is the purpose of a sql?

915


Explain what is an index?

1001


Explain what is a column in a table?

1045


explain the advantages and disadvantages of stored procedure? : Sql dba

956