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
What is database normalization? Explain types of it.
How do we select distinct values from a table?
What is 1nf 2nf 3nf in dbms?
What is cold backup, hot backup, warm backup recovery?
when All datafiles related to a Tablespace are removed ?
Difference between data and information, and how are they related in a database?
How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?
What is meant by database server?
What is flag in database?
What is database development process?
When connection to database is failed, Which exception will be thrown?
I want to export the data date to date from oracle database then what can i do?
What is difference between database and file?
how to restore particular schema from rman full backup?
Is sql a rdbms?