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
6533 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 normalization in dbms?

0 Answers

what is the difference between DBMS and RDBMS??

76 Answers Aon Hewitt, BlackRock, Infosys, ISB, Jawood, TCS,

How to Perform Data Cleaning and Preprocessing?

1 Answers

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

0 Answers

What is the difference between case version and decode version?

0 Answers

how to solve cardinality in dbms...many to many ralationships

0 Answers

What is limit in dbms?

0 Answers

What are the five steps of data modeling?

0 Answers

Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com

0 Answers Oracle,

What is a checkpoint in dbms?

0 Answers

What is atomicity in dbms?

0 Answers

What is Archived Redo Log ?

3 Answers

For more Database Management Interview Questions Click Here