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

What are the basic elements of Base configuration of an oracle Database ?

1 Answers  

What are the different types of data tables?

0 Answers  

Dept wise avrage salary

2 Answers   HCL, IBM, TCS,

What does DLL stands for ?

2 Answers   Nexus Technologies,

What do you mean by index hunting?

0 Answers  

what is the difference between filters and conditions?

0 Answers   ITC Infotech,

Explain the Difference Between OLTP and OLAP Databases.

1 Answers  

How do I create a database in open office?

0 Answers  

What is rdbms and its types?

0 Answers  

Why would someone use a database?

0 Answers  

What is write ahead logging in DBMS?

0 Answers   HAL,

Can you have more than one cursor open at any one time in a program ?

0 Answers  

For more Database Management Interview Questions Click Here
Categories