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 to export data from database and import into another?

0 Answers  

What is the mechanism provided by ORACLE for table replication ?

1 Answers  

How to know the Architecture of the Database

0 Answers   HCL,

Explain degree of a relation?

0 Answers  

What is the main purpose of a database?

0 Answers  




What is the default '-sort' order for a sql?

0 Answers  

What is an ALERT ?

1 Answers  

What is the use of SET TRANSACTION USE ROLLBACK SEGMENT ?

1 Answers  

How is a database related to a table?

0 Answers  

Why not phenix, the zelinka/otwinoski libraries, etc?

0 Answers  

Explain the necessary techniques to control deadlocks?

0 Answers  

What is the best database to use?

0 Answers  

For more Database Management Interview Questions Click Here
Categories