OraFAQ Forum: SQL & PL/SQL » how to find max if data type is varchar2

Home » SQL & PL/SQL » SQL & PL/SQL » how to find max if data type is varchar2

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to find max if data type is varchar2 [message #228058]

Sat, 31 March 2007 01:54

anitar
Messages: 4
Registered: January 2007
Location: Aurangabad

Junior Member

hi

i have one table with column pf_number of varchar2 datatype
and in this column data gets stored in format MH/32336/126
i want to find max of pf_number i can use hear SUBSTR and to_number function but it returns me only 126
i want advanced SQL function for it which returns me complete
string in format'MH/32336/126

thanks

rgards
anitar

Report message to a moderator

Re: how to find max if data type is varchar2 [message #228061 is a reply to message #228058]

Sat, 31 March 2007 02:13

narayanan.v
Messages: 29
Registered: September 2005

Junior Member

Hi,

Could give more details on this, with more samples.

Report message to a moderator

Re: how to find max if data type is varchar2 [message #228112 is a reply to message #228058]

Sat, 31 March 2007 14:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

MAX works with VARCHAR2 datatype column values as well; why do you think you need a number?

Also, what kind of advanced SQL function are you looking for? What could it do that SUBSTR couldn't?

Report message to a moderator

Re: how to find max if data type is varchar2 [message #228183 is a reply to message #228058]

Mon, 02 April 2007 00:43

Frank
Messages: 7901
Registered: March 2000

Senior Member

MH/32336/126 is NOT a format. It is an example of one of your codes.
Since it does not show us how it can vary, how would you expect us to help you find your 'max' ??

Report message to a moderator

Previous Topic:	materialized views
Next Topic:	execute procedure in SqlDeveloper which returns recordset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 08 17:48:40 CST 2024