Interested to Buy Any Domain ? << Click Here >> for more details...
in sql table follw columns r their
vehicle_no|servicetype|date|location|
1234 |1FS |1-JAN|PUNE|
4561 |2FS |5-JAN|PUNE|
1234 |PS |7-JAN|PUNE|
1234 |PS |15-JAN|MUMB|
i want o/p below
vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS
DATE|2PSLOCA
e.g
1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI
PLS help me out to execute using sql query
- 1 Answers
- 3102 Views
- I also Faced
- E-Mail Answers
Answer / mathivanan
select listagg(vehicle_no||'|'||servicetype||'|'||date||'|'||location,'|') within group (order by vehicle_no) from table_name
| Is This Answer Correct ? | 0 Yes | 0 No |
what is global variable in pl/sql
What is the difference among union, minus and intersect?
What are commit, rollback, and savepoint?
What is the use of partition by in sql?
Explain what is sql*plus?
Why we use sql profiler?
Explain how can you save or place your msg in a table?
What are field types?
Explain select statements in sql?
What is Collation Sensitivity ? What are the various type ?
Is truncate ddl or dml?
What's the procedure?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
