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?
- 1 Answers
- 4341 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
What is a constraint?
Explain the purpose of %type and %rowtype data types?
What do you understand by pl/sql packages?
How can I delete duplicate rows?
When is the update_statistics command used?
How to place comments in pl/sql?
How can get second highest salary in sql?
What is the difference between the conventional and direct path loader? : aql loader
what is normalization? : Sql dba
How to set up sql*plus output format in oracle?
Is sqlite good enough for production?
Is primary key a clustered index?
What is the difference between cross join and natural join?
what is foreign key? : Sql dba
How to order siblings in oracle hierarchy queries?
