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

how can we store space between two strings in database i.e
oracle

Answer Posted / roopesh kumar

select <string1>|| ' <<Number of spaces needed with in
single queotes>> ' ||<string2> from dual;

ex. select 'RAM' || ' ' || 'PRASAD' FullName from dual;

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I keep my database up to date?

874


Mention the differences between the clustered and non-clustered index

838


Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

1054


Why does reading require write privileges on database file?

837


What do you understand by data independence? What are its two types?

983


What is a join in the sql?

940


Define sub-query.

949


What are the database skills?

891


What is stored procedure in database?

896


What is normal form in dbms?

860


What is data example?

823


Explain data independence?

966


What are the disadvantages of file processing systems?

955


What is delimiter in dbms?

828


Why not phenix, the zelinka/otwinoski libraries, etc?

1060