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

What is the use of FULL option in EXP command ?

1 Answers  

Can I concurrently access a firebird database with embedded and with regular server?

0 Answers  

Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?

0 Answers   DELL,

What do you mean by starvation in dbms?

0 Answers  

What is super key in dbms?

0 Answers  




What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?

1 Answers   Sutherland,

Define atomicity and aggregation.

0 Answers  

Why normalisation is required?

0 Answers  

When a form is invoked with CALL_FORM does Oracle forms issues?

1 Answers  

Which is the best database?

0 Answers  

What is database management system with example?

0 Answers  

What is the use of PARFILE option in EXP command ?

1 Answers  

For more Database Management Interview Questions Click Here
Categories