how can we store space between two strings in database i.e
oracle
Answer Posted / 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 |
Post New Answer View All Answers
How do I keep my database up to date?
Mention the differences between the clustered and non-clustered index
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
Why does reading require write privileges on database file?
What do you understand by data independence? What are its two types?
What is a join in the sql?
Define sub-query.
What are the database skills?
What is stored procedure in database?
What is normal form in dbms?
What is data example?
Explain data independence?
What are the disadvantages of file processing systems?
What is delimiter in dbms?
Why not phenix, the zelinka/otwinoski libraries, etc?