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

how to pass values from one table to another by using Bulk collect?

3 Answers Oracle, Wipro,

Differentiate between ‘cluster’ and ‘non-cluster’ index.

0 Answers

How do you notify dbpak about stored procedure?

0 Answers

Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz

1 Answers

Define join types.

0 Answers

how can we store space between two strings in database i.e oracle

2 Answers HCL,

Explain relational algebra?

0 Answers

What is a checkpoint in dbms and when does it occur?

0 Answers

What is ddl in dbms?

0 Answers

what is datapump? Difference between exp and expdp?