Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to find the latest row and check against parent row?
Sorry. Forgot to mention that both tables contain a timestamp columns.- Chadi
- Post #3
- Forum: Oracle: All versions
-
How to find the latest row and check against parent row?
Hi I have two table: header and history. The header record contains Primary Key, PNum and a Status column that can be either 'Open', 'In Progress' or 'Closed'. The header record can only move statuses in that order, ie. from 'Open' to 'In Progress' to finally 'Closed'. In the History table...- Chadi
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Getting column value based on column name from another table?
Cool, Malcolm. You are absolutely right. It is so much easier to do this sort of thing with report writers. Unfortunately, I can not use a report write and have to rely on SQL only. The main reason for using SQL only is because I need to SQL to plug into an Oracle Alert I am designing. With... -
Getting column value based on column name from another table?
I am bit surprised that this would not be possible. There should be a method to substitute a variable in SQL with the value and then the SQL can fetch that value as a column name in a table. If I have to resort to programming logic then it would look something like this (this is simplified... -
Getting column value based on column name from another table?
Hi. I have two predefined tables: Errors and Transactions. Columns in Errors table are Transaction ID, Error Code, Error Column, Error Message. Columns in Transactions table are Transaction ID, Quantity, Unit Price, Approval, etc. I would like (one) SQL statement that will look up all the... -
Java development question....
Hi octopus! thanks fo your time...:D<br><br>I realise my question wasn't clearly asked lasttime around, and i apologize... <br><br>Basically, my question was: How do i put a Jframe in a JTabbedPane? -
Java development question....
In my project,I have four Jframe in wich the pricipal one is JtabbedPane with 4 pages. what should I do for my 4 pages contain the 4 Jframes? What is the method I should use to put a Jframe in a page?<br><br>Thank you for your time in advance, and I would appreciate a quick reply...<br><br>In...
