Interesting SQL Question, Pivot 1 column into multiple rows

by lewiscunningham in Data Management

on June 23, 2006, 4:52 AM PDT

Interesting SQL Question, Pivot 1 column into multiple rows

This effort is an example of how I decompose a problem and some fun SQL tricks. Not tricks, I guess but maybe a creative use of SQL. A couple of days ago, a question was posted on one of the itToolbox.com email groups: From: Brat Subject: [oracle-sql-l] COnverting one field into multiple rows Message: How ...

This effort is an example of how I decompose a problem and some fun SQL tricks. Not tricks, I guess but maybe a creative use of SQL.

A couple of days ago, a question was posted on one of the itToolbox.com email groups:

From: Brat

Subject: [oracle-sql-l] COnverting one field into multiple rows

Message:

How do I parse this one field in a table into multiple rows:

Field 1

1,2,3,4,56

This post originally appeared on an external website

By lewiscunningham

Account Information

Contact lewiscunningham

Your message has been sent
|
See all of lewiscunningham's content

Editor's Picks

Image: Rawpixel/Adobe Stock

TechRepublic Premium
TechRepublic Premium editorial calendar: IT policies, checklists, toolkits and research for download

TechRepublic Premium content helps you solve your toughest IT issues and jump-start your career or next project.

TechRepublic Staff
Published: March 14, 2023, 9:10 AM EDT Modified: March 15, 2023, 9:16 AM EDT Read More See more TechRepublic Premium
Image: Blue Planet Studio/Adobe Stock

Payroll
The best human resources payroll software of 2023

With a lot of choices in the market, we have highlighted the top six HR and payroll software options for 2023.

Ali Azhar
Published: February 28, 2023, 11:11 AM EST Modified: March 13, 2023, 6:06 AM EDT Read More See more Payroll
Image: Microsoft.

Software
Windows 11 update brings Bing Chat into the taskbar

Microsoft's latest Windows 11 allows enterprises to control some of these new features, which also include Notepad, iPhone and Android news.

Mary Branscombe
Published: February 28, 2023, 2:59 PM EST Modified: February 28, 2023, 2:59 PM EST Read More See more Software
Image: tanatat/Adobe Stock

CXO
Tech jobs: No rush back to the office for software developers as salaries reach $180,000

Salaries for remote roles in software development were higher than location-bound jobs in 2022, Hired finds.

Owen Hughes
Published: March 3, 2023, 3:12 PM EST Modified: March 16, 2023, 12:56 PM EDT Read More See more CXO
Image: Nuthawut/Adobe Stock

Software
The 10 best agile project management software for 2023

With so many agile project management software tools available, it can be overwhelming to find the best fit for you. We've compiled a list of 10 tools you can use to take advantage of agile within your organization.

Brenna Miles
Published: December 27, 2022, 11:45 AM EST Modified: March 16, 2023, 2:25 PM EDT Read More See more Software
Image: Song_about_summer/Adobe Stock

Security
1Password is looking to a password-free future. Here’s why

With phishing-based credentials theft on the rise, 1Password CPO Steve Won explains why the endgame is to 'eliminate’ passwords entirely.

Karl Greenberg
Published: March 2, 2023, 3:44 PM EST Modified: March 7, 2023, 4:10 PM EST Read More See more Security

PURPOSE This policy from TechRepublic Premium provides guidelines for reliable and secure backups of end user data. It outlines the responsibilities of IT departments and employees to identify tasks and action items for each group. The policy can be customized to fit the needs of your organization. From the policy: IT STAFF RESPONSIBILITIES IT staff ...

This policy from TechRepublic Premium provides guidelines for the appropriate use of electronic communications. It covers topics such as privacy, confidentiality and security; ensures electronic communications resources are used for appropriate purposes; informs employees regarding the applicability of laws and company policies to electronic communications; and prevents disruptions to and misuse of company electronic communications ...

PURPOSE Change is inevitable in any technological sector; it brings new features, functions and opportunities and helps businesses prosper through evolution. However, change can be detrimental to company operations if not executed properly through advanced notification of and approval by involved personnel. This change order form is designed to help you plan, implement and track ...

Interesting SQL Question, Pivot 1 column into multiple rows

Interesting SQL Question, Pivot 1 column into multiple rows

Editor's Picks

TechRepublic Premium editorial calendar: IT policies, checklists, toolkits and research for download

The best human resources payroll software of 2023

Windows 11 update brings Bing Chat into the taskbar

Tech jobs: No rush back to the office for software developers as salaries reach $180,000

The 10 best agile project management software for 2023

1Password is looking to a password-free future. Here’s why

End user data backup policy

Electronic communication policy

Change order form

Electronic data disposal policy

Account Information

Interesting SQL Question, Pivot 1 column into multiple rows

Daily Tech Insider Newsletter

Account Information

Share with Your Friends

Account Information

Contact lewiscunningham

Editor's Picks

Daily Tech Insider Newsletter