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
6411 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 the different levels of abstraction in the dbms?

0 Answers

What is a candidate key in a database?

0 Answers

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

0 Answers

What is index hunting and how does it help in improving query performance?

0 Answers

What is Dedicated server configuration ?

2 Answers

Why normalisation is required?

0 Answers

What are the four objectives of the selection of a data type?

0 Answers

What is cursor and where do you use them?

2 Answers eBay,

How to retrive a single data from a database

0 Answers MCN Solutions,

What are the different types of database keys?

0 Answers

hi, i am new to database cau give me link where can i get about databse..

0 Answers

How to unzip a file in ssis?

0 Answers

For more Database Management Interview Questions Click Here