SELECT S.NO||NAME||ID FROM <table

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?

Question Posted / g sivanagaraju

1 Answers
4654 Views
I also Faced
E-Mail Answers

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 a behavioral trigger?

930

what is innodb? : Sql dba

1033

Can we use threading in pl/sql?

971

Is there a way to automate sql execution from the command-line, batch job or shell script?

918

What sql database should I use?

1072

Is delete faster than truncate?

958

What is sql server and ase?

976

Why do we create stored procedures & functions in pl/sql and how are they different?

888

How do I create an index in word?

966

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1383

Can a procedure in a package be overloaded?

982

how to convert character strings to numeric values? : Sql dba

1024

What are inner and outer joins examples of both?

879

What is an implicit commit?

990

Is and as keyword in pl sql?

904