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
6443 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 are different types of joins in the sql?

0 Answers

What is drivermanager getconnection?

0 Answers

when A set of Dictionary tables are created ?

2 Answers

Does netlib support windows 95?

0 Answers

What is the structure of a database?

0 Answers

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

0 Answers

What is cursor and where do you use them?

2 Answers eBay,

How do you start a database?

0 Answers

Who is communication horizons?

0 Answers

Is mysql a rdbms?

0 Answers

What is structure of dbms?

0 Answers

What is big data in database?

0 Answers

For more Database Management Interview Questions Click Here