select <string1>|| ' <<Number of spaces needed with in s

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

Question Posted / roopesh kumar

2 Answers
6351 Views
HCL, I also Faced
E-Mail Answers

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 progress open edge?

1067

What is bcnf standard form in dbms?

985

What is a field in database?

866

Is there some bulk load or other way to import a lot of data fast?

822

Define identity and uniqueidentifier property of column?

1021

What is a database in a website?

1001

What is the use of database management system?

941

What is the main purpose of a database?

892

Is it good to store image in database?

861

List few restrictions that are imposed while creating views?

852

How do you link a spreadsheet to a website?

893

What is database url?

918

What is the full form of rdbms?

951

Why do we need database management?

919

How do you exit a database?

861