Home » SQL & PL/SQL » SQL & PL/SQL » Significance of 'last' in oracle.
Significance of 'last' in oracle. [message #266390] Mon, 10 September 2007 13:13 Go to next message
nageswara
Messages: 9
Registered: August 2007
Junior Member
One of the sql quaries is as below, where it is expected to return only 1 value in normal situation.

select VALUE as FG from TEST where KEY='2556';

But in exceptional situation it may return more than one value.

so the requirements says "If multiple records are returned, then assign the last VALUE as FG"

What is the significance of 'last' in requirements? Is it a testable condition at all?

Thanks for help

Regards
Nageswara
Re: Significance of 'last' in oracle. [message #266392 is a reply to message #266390] Mon, 10 September 2007 13:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What is the significance of 'last' in requirements

None for Oracle unless YOU define an order.

Regards
Michel
Re: Significance of 'last' in oracle. [message #266393 is a reply to message #266390] Mon, 10 September 2007 13:22 Go to previous message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
If a basket has many colored balls in it & there is more than 1 red ball, which red ball is the "last" red ball?
Previous Topic: problem with set define off
Next Topic: Help with PK constraint
Goto Forum:
  


Current Time: Mon Dec 05 13:08:17 CST 2016

Total time taken to generate the page: 0.07568 seconds