Oracle PL/SQL question

From: Dmitry Shulman <dmitry_at_umich.edu>
Date: 1997/04/21
Message-ID: <335B7622.3AB7@umich.edu>#1/1

Is there a place somewhere where I can obtain some sample PL/SQL code?

I have a table with a number and value and I want to create a new table combining numbers into a range if values are same.

current table
1 a
2 a
5 b
6 c
7 c
8 c

new table
1 2 a
3 4 - (blank)
5 5 b
6 8 c

I just got a PL/SQL manual and started going over it. It would be nice if there was a source of programs that I could take a look at. Thanks. Is this the right newsgroup to post this? If this is not, please let me know. Received on Mon Apr 21 1997 - 00:00:00 CDT