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
6431 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 is drivermanager getconnection?

0 Answers

I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?

1 Answers eBay, Google,

Enlist the advantages of normalizing database.

0 Answers

What are the advantages of rdbms?

0 Answers

What is the main purpose of normalization?

0 Answers

What is a functional dependency in the dbms?

0 Answers

If CPU is very slow What can u do to speed up?

1 Answers

What is the purpose of normalisation?

0 Answers

what is the difference between filters and conditions?

0 Answers ITC Infotech,

What do you mean by DBMS?

0 Answers Hexaware,

What is blob database?

0 Answers

Define database model.

0 Answers

For more Database Management Interview Questions Click Here