| Updating Data [message #390453] |
Fri, 06 March 2009 06:42  |
mankensin
Messages: 2
Registered: March 2009
|
Junior Member |
|
|
Please help me out. I am currently new in PL/SQL. I have a table in my Oracle DB with the column names and data as indicated in the attached Sample_Data.csv file.
I need to achieve the following on the table;
A procedure that query the table, starting from the first row and check if the (Deal_Type) column is "Fixed Call Money" then go to the next row, if on this next row the (Descriptn) Column is "Place Money Reversed" and the (Amount) value on this row is equal to the (Amount) value in the previous row, it should update the (Descriptn) value to "Place Fixed Money Reversed". If not it should go to the next row and check this same condition.
The procedure should continue this to the end of the row in the table.
Thank you,
Austin Olojede
|
|
|
|
| Re: Updating Data [message #390455 is a reply to message #390453] |
Fri, 06 March 2009 06:53  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
|
Are you expecting us to do your work for you? If you read the forum guide you will find that we expect you to show us what you have tried along with DDL and DML statements to create a test case.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
