PIVOT
should work fine – SQL Fiddle demo (schema borrowed from bluefeets answer)
SELECT *
FROM source
PIVOT (
MIN(org) AS org,
MIN(position) AS position
FOR lang
IN('EN' AS en, 'FI' AS fi, 'SV' AS sv)
);
More Related Contents:
- I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
- How do I do top 1 in Oracle? [duplicate]
- REGEX to select nth value from a list, allowing for nulls
- Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
- How can I select from list of values in Oracle
- PLS-00428: an INTO clause is expected in this SELECT statement
- How to get the last row of an Oracle table
- Using pivot on multiple columns of an Oracle row
- How can I get the number of days between 2 dates in Oracle 11g? [duplicate]
- INSERT SELECT statement in Oracle 11G
- Sleep function in ORACLE
- SQL Error: ORA-00942 table or view does not exist
- Oracle – How to create a materialized view with FAST REFRESH and JOINS
- Nth max salary in Oracle
- Oracle – ORA-01489: result of string concatenation is too long [duplicate]
- Display names of all constraints for a table in Oracle SQL
- Autoincrement in oracle to already created table
- Oracle 11g – Check constraint with RegEx
- Issue when comparing result of to_char(myDate, ‘DAY’) to a string
- How to use a dynamic parameter in a IN clause of a JPA named query?
- Why does the wm_concat not work here?
- The network adapter could not establish the connection – Oracle 11g
- Oracle string aggregation
- Curious issue with Oracle UNION and ORDER BY
- Subtracting Dates in Oracle – Number or Interval Datatype?
- How to call Oracle MD5 hash function?
- Oracle RAC and sequences
- Using bind variables with dynamic SELECT INTO clause in PL/SQL
- Insert into from CTE
- PARTITION BY with and without KEEP in Oracle