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

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

Question Posted / rams

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

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / harika

select <string1>|| ||<string2> from dual;

Is This Answer Correct ?

9 Yes

4 No

Post New Answer

More Database Management Interview Questions

How do you set up a database?

0 Answers

How to export data from database and import into another?

0 Answers

i want to know real time experience on oracle dba anybody help me please mail me aniltelkar50@gmail.com

1 Answers IBM,

What is db flush?

0 Answers

What are the drawback of rdbms?

0 Answers

Define entity set.

0 Answers

what is database

2 Answers IBM,

what are database files, control files and log files. How many of these files should a database have at least? Why?

0 Answers

select Nth highest salary by using rownum

4 Answers Ford, TCS, Tech Mahindra,

What is sql and where is it used?

0 Answers

Explain the Surrogate Key in DBMS.

0 Answers Genpact,

What is system r? How many of its two major subsystems?

0 Answers

For more Database Management Interview Questions Click Here