Split varchar into separate columns in Oracle

by

Depends on the consistency of the data – assuming a single space is the separator between what you want to appear in column one vs two:

SELECT SUBSTR(t.column_one, 1, INSTR(t.column_one, ' ')-1) AS col_one,
       SUBSTR(t.column_one, INSTR(t.column_one, ' ')+1) AS col_two
  FROM YOUR_TABLE t

Oracle 10g+ has regex support, allowing more flexibility depending on the situation you need to solve. It also has a regex substring method…

Reference:

More Related Contents:

  1. Receive an unexpected symbol error in my PLSQL query [closed]
  2. SQL Query to concatenate column values from multiple rows in Oracle
  3. Select First Row of Every Group in sql [duplicate]
  4. Paging with Oracle
  5. Comparing Dates in Oracle SQL
  6. Oracle Differences between NVL and Coalesce
  7. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  8. SQL – How to store and navigate hierarchies?
  9. GROUP BY / aggregate function confusion in SQL
  10. Oracle “(+)” Operator
  11. How do you create a temporary table in an Oracle database?
  12. Calculating difference between two timestamps in Oracle in milliseconds
  13. How can I find which tables reference a given table in Oracle SQL Developer?
  14. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  15. How to check the maximum number of allowed connections to an Oracle database?
  16. Select without a FROM clause in Oracle
  17. Is there any way to flush output from PL/SQL in Oracle?
  18. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  19. PLSQL Insert into with subquery and returning clause
  20. SELECT from table with Varying IN list in WHERE clause
  21. How to populate calendar table in Oracle?
  22. Does Oracle use short-circuit evaluation?
  23. Oracle 11g – Check constraint with RegEx
  24. Advice Using Pivot Table in Oracle
  25. What does a (+) sign mean in an Oracle SQL WHERE clause? [duplicate]
  26. Subtracting Dates in Oracle – Number or Interval Datatype?
  27. Connecting to Oracle Database using Sql Server Integration Services
  28. Retrieve Oracle last inserted IDENTITY
  29. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  30. Why are aggregate functions not allowed in where clause

Leave a Comment