Home » SQL & PL/SQL » SQL & PL/SQL » Find the Last Character (Oracle 9i, Forms and Report 6i)
Find the Last Character [message #434952] Sat, 12 December 2009 00:00 Go to next message
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
Re: Find the Last Character [message #434955 is a reply to message #434952] Sat, 12 December 2009 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member


Thanks, your reply is useful to me.

Regards,

C V S
Previous Topic: Crosstab query, Clob columns
Next Topic: XMLTYPE : CAST(MULTISET....) help ^^
Goto Forum:
  


Current Time: Sun Sep 25 06:08:46 CDT 2016

Total time taken to generate the page: 0.09091 seconds