1 Replies - 659 Views - Last Post: 09 November 2015 - 07:33 PM

#1 DarenR   User is offline

  • D.I.C Lover

Reputation: 637
  • View blog
  • Posts: 4,224
  • Joined: 12-January 10

query that needs to run on orcle and sql

Posted 01 October 2015 - 06:46 AM

i have the following:


Select
bridge.BRKEY,
bridge.BRIDGE_ID,
bridge.STRUCT_NUM,
bridge.STRUCNAME,
bridge.bridge_gd,
MULTIMEDIA.CONTEXT,
MULTIMEDIA.FILELOC,
MULTIMEDIA.FILEREF,
MULTIMEDIA.REPORTFLAG,
MULTIMEDIA.NOTES,
MULTIMEDIA.SEQUENCE,
INSPEVNT.INSPEVNT_GD,
[b](SELECT  OPTIONNAME,OPTIONVAL, 
 ROW_NUMBER() OVER(PARTITION BY pc.OPTIONVAL ORDER BY OPTIONVAL DESC)
FROM PON_COPTIONS pc ) as row_num,
--WHERE pc.OPTIONNAME = 'MULTISERVER5' or pc.OPTIONNAME = 'MULTISERVER' )as row_num,
(SELECT   OPTIONVAL FROM PON_COPTIONS pc WHERE pc.OPTIONNAME = 'MULTISERVER5' or pc.OPTIONNAME = 'MULTISERVER' and row_num = 1) DIR[/b]
from MULTIMEDIA
inner JOIN INSPEVNT ON INSPEVNT.DOCREFKEY = MULTIMEDIA.DOCREFKEY
inner join BRIDGE on BRIDGE.bridge_gd = INSPEVNT.bridge_gd 
WHERE MULTIMEDIA.CONTEXT = 'INSPECTION' and
MULTIMEDIA.FILETYPE in ('jpg','JPG','gif','GIF','bmp','BMP','png','PNG','tif','TIF', 'pdf', 'PDF', 'DWG', 'dwg') and
INSPEVNT.INSPEVNT_GD =



how can i make the above query as a whole run in oracle and sql

Is This A Good Question/Topic? 0
  • +

Replies To: query that needs to run on orcle and sql

#2 zerocool1   User is offline

  • D.I.C Head
  • member icon

Reputation: 10
  • View blog
  • Posts: 62
  • Joined: 31-August 15

Re: query that needs to run on orcle and sql

Posted 09 November 2015 - 07:33 PM

With a complicated query I think you will have to develop an oracle version and run each query individually. I don't think you have an option for just 1 query for both DBs.
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1