OraFAQ Forum: SQL & PL/SQL » Find the Last Character

Home » SQL & PL/SQL » SQL & PL/SQL » Find the Last Character (Oracle 9i, Forms and Report 6i)

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

Find the Last Character [message #434952]

Sat, 12 December 2009 00:00

cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA

Senior Member

Hi,

I Required to Find the Last Character of a field.

Ex:

GRINNO CHALLANNO
92201169 92250161
92201170 017103
92201171 1974
92201172 2374
92201173 1971
92201174 233
92201175 1188
92201176 1505
92201177 HI-2762

In Challan number i required to take the final Character of the field (Challanno).

Like
GRINNO CHALLANNO
92201169 1
92201170 3
92201171 4
92201172 4
92201173 1
92201174 3
92201175 8
92201176 5
92201177 2

Regards,

C V S

Report message to a moderator

Re: Find the Last Character [message #434955 is a reply to message #434952]

Sat, 12 December 2009 01:19

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SUBSTR

SQL> select substr('MICHEL',-1) from dual;
S
-
L

1 row selected.

Regards
Michel

[Updated on: Sat, 12 December 2009 01:19]

Report message to a moderator

Re: Find the Last Character [message #434957 is a reply to message #434955]

Sat, 12 December 2009 01:42

cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA

Senior Member

Thanks, your reply is useful to me.

Regards,

C V S

Report message to a moderator

Previous Topic:	Crosstab query, Clob columns
Next Topic:	XMLTYPE : CAST(MULTISET....) help ^^

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 00:13:27 CST 2025