Sign Up Login


  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

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

Question Posted / rams

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

Is sql a database?

0 Answers  

What does rdbms stand for?

0 Answers  

What do you understand by cursor?

0 Answers  

Explain the architecture of reporting services?

0 Answers  

Define denormalization.

0 Answers  




What is database bloat?

0 Answers  

What is the difference between a shared lock and exclusive lock?

0 Answers  

For each user who needs access, the DBA creates an account in which database?

0 Answers  

How do you open .db files?

0 Answers  

Explain the key constraints and constraints on Null Values with examples?

2 Answers  

Define object-oriented model.

0 Answers  

What is building blocks of client/server?

0 Answers  

For more Database Management Interview Questions Click Here
Categories