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

What's the difference between file and database?

1 Answers

What is the purpose of a field in a database?

0 Answers

How is data stored in a relational database?

0 Answers

what is "TABLE" datatype ?

2 Answers

What are data modelling tools?

0 Answers

What is oracle block?

0 Answers

What is the first step in creating a database?

0 Answers

what is the location of oracle inventory?

0 Answers

What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?

0 Answers

what is the difference between two and three-tier architectures?

0 Answers

What is super key in dbms?

0 Answers

What is openedge abl in terms of taking the perspective of the developer?

0 Answers

For more Database Management Interview Questions Click Here