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

Define database.

0 Answers

What is database or database management systems (dbms)?

0 Answers

What is Database Management System?

0 Answers Atos Origin,

What are the different levels of abstraction in the dbms?

0 Answers

Excellent job opening with one of our client in Hyderabad About Client : It is an American e-commerce company based in Seattle, Washington, a leading online retailer of products that inform, educate, entertain and inspire.

1 Answers

What is cluster table or non_cluster table?

1 Answers

What are indexes? What are b-trees?

0 Answers

Explain the necessary techniques to control deadlocks?

0 Answers

what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,

0 Answers

What are the limitations of rdbms?

0 Answers

What is management system in dbms?

0 Answers

What are the three main types of models?

0 Answers

For more Database Management Interview Questions Click Here