select <string1>|| ' <<Number of spaces needed with in s

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

Question Posted / roopesh kumar

2 Answers
6413 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the different types of database keys?

975

Is a database a file?

928

How to recreate the index on a firebird table?

897

What is a table called in database?

974

What do you mean by entity type?

1066

What is a hierarchical database?

998

Mention the different languages present in dbms

945

What is 2nf in database?

996

What is tuple and attribute?

911

Explain issues for database performance.

941

Why does reading require write privileges on database file?

882

What's the best database software for mac?

922

How to specify transaction or query timeout?

1037

What is meant by database server?

995

What do you mean by deadlock dbms?

1090