Serge Rielau wrote:
> DA Morgan wrote:
>> berwiki wrote:
>>> Can anybody help me? This query executes perfectly fine in MSSQL, but
>>> I get errors in Oracle.
>>>
>>> SELECT
>>>
>>> CAST(REPLACE(STR(SHCLOG.origtrace,6,0),' ','0')AS CHAR(6)) as
>>> FIXEDTRACE,
>>> SHCLOG.SETTLEMENT_DATE,
>>> SHCLOG.MSGTYPE,
>>> SHCLOG.ORIGMSG,
>>> SUBSTRING(SHCLOG.PAN,1,6) AS ISOBIN,
>>> SHCLOG.PCODE,
>>> SHCLOG.TXNTYPE,
>>> CONVERT(char(13), (CAST((SHCLOG.amount) as money)),1) AS FIXEDAMOUNT,
>>> ' '+CAST(REPLACE(STR(SHCLOG.origtrace,6,0),' ','0')AS CHAR(6)) AS
> <snip>
> Does Oracle support + as a synonym for || ?
> I thought that was a TSQL only feature.
>
> Cheers
> Serge
No. There is so much wrong with the SQL, from an Oracle standpoint, it
is ridiculous. The OP seems to be a typical Microsoft user who thinks
documentation is written for other people to read.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jul 14 2006 - 17:47:43 CDT
