Home » SQL & PL/SQL » SQL & PL/SQL » Library function no PL/SQL
Library function no PL/SQL [message #20322] Mon, 13 May 2002 11:01 Go to next message
Mark the Shark
Messages: 15
Registered: February 2002
Junior Member
Hello, I'm trying to capture the second word from a field btitle:

Ghost from the Grand Banks =from
Prints of the 20th Century=of
with using PL/SQL

and I can use a trialing concatinated space(btitle||' ').
and can I also eliminate the second word
thanks
Re: thanks Todd!!! [message #20325 is a reply to message #20322] Mon, 13 May 2002 11:26 Go to previous message
Mark the Shark
Messages: 15
Registered: February 2002
Junior Member
Thanks so much Todd!!
Got it!
Previous Topic: creating a sequence/primary k. based on select dept type
Next Topic: generating sequence/primary key based on dept (a column)type
Goto Forum:
  


Current Time: Fri Apr 26 21:56:16 CDT 2024