RE: HELP..URGENT....NOT
I don't know if this is it but, I find the following very useful: Atul Mehta's o r a c l e World http://www.orakle.com/ -Original Message- Sent: Thursday, January 16, 2003 5:29 AM To: Multiple recipients of list ORACLE-L A while back I posted a link to a website that has hundreds of Oracle links. It's a site that is good for Unix and Windoze bigots, pick your flavor. Well, I lost my hard drive and my internet favorites. If anyone has that link that I posted I would greatly appreciate it if you can now post it cuz I cannot remember the name of it. Thanks Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Bogacz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Right()
SUBSTR(char,m[,n]) A subtring of char beginning at byte m, n bytes long (if n omitted m to end of char) i.e. If a = 'ABCDEFGHI' substr(a,7,3) = 'GHI' substr(a,7) = 'GHI' -Original Message- Sent: Monday, December 23, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Please don't laugh. What is the equivalent of a Right() function in Oracle? I want to be able to sort a column numerically whose string contents takes the format v1, v2, v3, v4. I was after something like: ORDER BY Cast(Right(lt_tk_id, Length(lt_tk_id - 1)) as int) but it's not playing nice. Order by Right(lt_tk_id, 1) gives the same error, so I assume that's where it's falling down. I've searched everywhere I can think of for right function, Oracle online docs, Enterprise Manager docs, Google, but nothing seems to come close. BTW, is it my imagination or do the docs leave a lot to be desired? Thanks -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Aidan Whitehall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Bogacz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DUAL
') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wolfgang Bogacz INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).