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

How many types of database language exist?

0 Answers  

Define "correlated subqueries".

0 Answers  

i need query for displaying the eno,ename in a table from row 2 to row 5

1 Answers  

Explain what are called fat clients and fat servers?

0 Answers  

What is the use of GRANT option in EXP command ?

1 Answers  




How to prevent concurrent access to my data?

0 Answers   HCL,

How rdbms is different from dbms?

0 Answers  

What is the use of IGNORE option in IMP command ?

1 Answers  

Explain issues for database performance.

0 Answers  

Tell us about some Dot operator queries?

0 Answers   Atos Origin,

Which dbms is best?

0 Answers  

Enlist the advantages of dbms.

0 Answers  

For more Database Management Interview Questions Click Here
Categories