I have the table like this
S.No Name ID
01 Xyz 123
I want the result as
01Xyz123
How to write the query to retrieve the entire row data in a
single column?

Answer Posted / g sivanagaraju

SELECT S.NO||NAME||ID
FROM <table_name>

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is meant by nl2br()? : Sql dba

570


How will you distinguish a global variable with a local variable in pl/sql?

631


Does sql use python?

567


Does a join table need a primary key?

537


What are the uses of merge?

726






How many types of literals are available in pl sql?

522


What is the difference between microsoft access and sql?

500


Mention what are the benefits of pl/sql packages?

542


Do we need commit after truncate?

619


Is sql a programming?

550


What is microsoft t sql?

494


how to get a list of indexes of an existing table? : Sql dba

521


Can we use two order by clause in query?

551


which types of join is used in sql widely? : Sql dba

542


Is full outer join same as cross join?

505