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

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 do databases work?

0 Answers  


What is 2nf in database?

0 Answers  


What is domain in dbms?

0 Answers  


What are 4 types of models?

0 Answers  


Why is foreign key used?

0 Answers  






if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  


What is dbms and its advantages?

0 Answers  


What are stored-procedures? And what are the advantages of using them.

0 Answers  


What is the use of TABLES option in EXP command ?

1 Answers  


Explain ddl interpreter?

0 Answers  


Are Constraints exported through Export command?

1 Answers  


What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....

0 Answers   NIC,


Categories