Home » SQL & PL/SQL » SQL & PL/SQL » PL-Sql function
icon4.gif  PL-Sql function [message #292161] Tue, 08 January 2008 01:53 Go to next message
swamitvk
Messages: 14
Registered: November 2007
Junior Member
Hi

is there any function in PL/SQL to fetch the previous value of a column?

(example) edetails(amount number);
amount
======
1
3
5
The amount column of the edetails table contains 1,2,3.

The query result should be 3.

regards
swami

[Updated on: Tue, 08 January 2008 02:33] by Moderator

Report message to a moderator

Re: PL-Sql function [message #292175 is a reply to message #292161] Tue, 08 January 2008 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LAG

Regards
Michel
Re: PL-Sql function [message #292176 is a reply to message #292161] Tue, 08 January 2008 02:35 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
LAG

beat me to it Smile

[Updated on: Tue, 08 January 2008 02:36]

Report message to a moderator

Re: PL-Sql function [message #292181 is a reply to message #292175] Tue, 08 January 2008 02:55 Go to previous messageGo to next message
swamitvk
Messages: 14
Registered: November 2007
Junior Member


Thank you Michel.
Re: PL-Sql function [message #292182 is a reply to message #292181] Tue, 08 January 2008 02:55 Go to previous message
swamitvk
Messages: 14
Registered: November 2007
Junior Member


Thank you Pablolee
Previous Topic: Row to columns based on delimiter!
Next Topic: Help on Group subquery
Goto Forum:
  


Current Time: Mon Dec 05 02:29:59 CST 2016

Total time taken to generate the page: 0.11593 seconds