Home » SQL & PL/SQL » SQL & PL/SQL » I am an arrogant SOB - string compare
I am an arrogant SOB - string compare [message #251537] Sat, 14 July 2007 07:50 Go to next message
yesukannan
Messages: 14
Registered: May 2007
Junior Member
hi,
can you please tell which pl/Sql function is used for comparing two string.

regards
yesukannan

[Updated on: Mon, 16 July 2007 08:07] by Moderator

Report message to a moderator

Re: !Urgent :string compare [message #251539 is a reply to message #251537] Sat, 14 July 2007 08:43 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
There is none besides the equal sign.
Re: !Urgent :string compare [message #251567 is a reply to message #251537] Sat, 14 July 2007 17:45 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
What type of comparison do you need? For pattern matching there is LIKE with the basic wildcards '%' and '_', and (in 10g) regular expressions. Prior to 10g you can often get by with combinations of INSTR, SUBSTR, TRANSLATE and REPLACE.
Previous Topic: Mutating trigger error
Next Topic: Help required in returning a cursor of varray
Goto Forum:
  


Current Time: Sun Dec 04 20:53:59 CST 2016

Total time taken to generate the page: 0.08560 seconds