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 >> SQL PLSQL
  2. Suggest New Category

i have a word
***********hello********world******.
I require a o/p
**********hello world**********,
Need to delete the middle stars.

Question Posted / murugesh

Answers were Sorted based on User's Feedback



i have a word ***********hello********world******. I require a o/p **********hello world*********..

Answer / chandan kumar

select (substr('***********hello********world******',1,instr
('***********hello********world******','o',1) )
||' '||substr('***********hello********world******',instr
('***********hello********world******','w',1) )
)
from dual

Is This Answer Correct ?    10 Yes 2 No

i have a word ***********hello********world******. I require a o/p **********hello world*********..

Answer / ajit

select '******hello*****world*******' str,
rpad(lpad(replace('******hello*****world*******', '*'), 15, '*'), 20,'*') str1
from dual;

Is This Answer Correct ?    1 Yes 1 No

i have a word ***********hello********world******. I require a o/p **********hello world*********..

Answer / mkarthikeyan

select replace('word ***********hello********world******. I
require a o/p **********hello world**********','*','') from
dual;

Is This Answer Correct ?    1 Yes 9 No

Post New Answer

More SQL PLSQL Interview Questions

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

Explain the update statement in sql

0 Answers  

What is rename in sql?

0 Answers  

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

how to start mysql server? : Sql dba

0 Answers  

four procedures is are there should i write their in a package

2 Answers  

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

What are the advantages of pl sql?

0 Answers  

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

Does view contain data?

0 Answers  

sql query to get zero records from a table having n no of records

8 Answers   CTS,

how to fetch common records from two tables? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories