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

What is cardinality in db?

581


Explain what are called fat clients and fat servers?

562


How to reorder the table columns (fields)?

674


Define stored procedures.

624


Is there a database program for mac?

538






Is database a storage?

583


What is database url?

594


What does partition mean in database?

588


What is erd?

668


What is view dbms?

600


Explain the scenarios or situations under which progress database creates new index entry for a record?

624


What is limit in dbms?

570


Explain concurrency transparency.

672


Explain the term entity in dbms?

570


How to load a file into database column?

593