Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL - Find Continuous Records

752564Feb 9 2010 — edited Feb 10 2010
I am looking for some SQL advice on finding continuous records in a table. The table in questions looks something like this:

ID LITH DEPTH

1-1 SAND 150
1-1 COAL 200
1-1 SAND 250
1-1 COAL 300
2-2 SAND 75
2-2 COAL 100
2-2 COAL 150
2-2 COAL 200
2-2 COAL 250
2-2 SAND 300
2-2 COAL 400
2-2 COAL 450

I am trying to locate the records marked in bold above and count the number of times they occur. In the example above I would hope to return:

id count
1-1 null
2-2 4
2-2 2

I know this is a problem that can be solved outside of the database, with excel for example. However, I would really appreciate any advice on how to solve this problem with SQL.
This post has been answered by 730428 on Feb 9 2010
Jump to Answer

Comments

843807
Depending on experience I suggest writting it by hand. This will take time but you should get familiar with swing. Having said that. Before you go out to buy JBuider ( expensive ), I suggest you go and download netbeans. Its a free IDE with GUI builder. This is a Sun based product and again its free. www.netbeans.org.

With this tool as with most java gui builders you can drop your own beans in. Both visible and invisible. So for example you have: MyTextbox extends JTextField you can add this to your component pallete. . meaning that you are able to drag and drop your own components into the frame.

There are some rules that you should adhear to. . When editting the code in netbeans the necessary generated code is non-editable. You can edit it in another editor, but it may not load and display properly the next time you look at the class in the GUI editor../ . Imagine this to be the same with most editors. Anywho, I've said to much already. . .have fun with this one
843807
Thank you for the information!,

So it sounds like you strongly recommend net beans over Forte For Java?
Is this true? I like Forte For Java but it seems to be slow.
843807
Interestingly, Forte for Java is based on the NetBeans IDE !!
Therefore, if you are of the idea to use NetBeans, you may as well continue using Forte itself..

Try initially to code by hand. That will help you build a strong foundation. Then u can go ahead with using a visual builder. As far as I am concerned, Forte is probably the best IDE for Java, If u r planning to buy, then go in for IBM Visual Age. It is equally good.

Also, if u r still bent on using JBuilder, u can download a free personal edition..

cheers
Ramanujam
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 10 2010
Added on Feb 9 2010
16 comments
12,644 views