view coming from oracle
-
Please need help to rewritten this views which comes from oracle.
SELECT PEO.ID ID_PERSON, PEO.NAME NAME_PERSON, PEO.FIRSTNAME FNAME_PERSON, ORG.NAME ORG_PERSON,
(SELECT PAR.PARAM_VALUE FROM T_USR_PROFILE_ASSIGN_PARAMETER PAR, V_REF_OBJECT_TYPES OBJ, V_REF_ENTITY_PROFILES REF2
, T_USR_PROFILE_ASSIGNMENT PRO2
WHERE PAR.PROFILE_ASSIGNMENT_ID = PRO2.ID
AND REF2.LABEL = 'EXPERT'
AND PRO2.PROFILE_ID = REF2.ID
AND PRO2.ORIGINAL_ID = PEO.ID
AND PRO2.DESTINATION_ID = ORG.ID
AND OBJ.LABEL = 'DEPARTMENT'
AND PAR.OBJECT_TYPE_ID = OBJ.ID
AND PAR.VALID_FLG = 'Y'
AND PRO2.VALID_FLG = 'Y'
) DPT_PERON,
PEO.TELEPHONE PHONE_PERSON, PEO.FAX FAX_PERSON, PEO.EMAIL EMAIL_PERSON, ORG.ID ORG_ID
FROM T_USR_ORGANISATION ORG, T_USR_PEOPLE PEO, T_USR_PROFILE_ASSIGNMENT PRO, V_REF_ENTITY_PROFILES REF
WHERE
REF.LABEL = 'DOA_PEOPLE'
AND PRO.PROFILE_ID = REF.ID
AND ORG.ID = PRO.DESTINATION_ID
AND PEO.ID = PRO.ORIGINAL_ID
AND PRO.VALID_FLG = 'Y'
AND ORG.VALID_FLG = 'Y'
AND PEO.VALID_FLG = 'Y'
thanks ina advance
-
So... what's the problem? -- Any error?
Do you have those tables/views available?
Do you have the right privs on them?
_____________________________________
Pablo (Paul) BerzukovAuthor of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice. -
Hello ,
My concerrn is that it comes from Oracle and I want to rewrite for MSSQL 2008.
-
Hadrian (5/20/2010)
My concerrn is that it comes from Oracle and I want to rewrite for MSSQL 2008.Start by executing underlying query and see what it does
This is a pretty simple piece of code, for future reference remember table names in oracle are usually in the SCHEMA_NAME.TABLE_NAME format ... not this time as far as I can see.
Point your underlying query to the location of your SS objects and you may be fine... some of the "tables" in the query may be "views", just my guess 'cause of naming convention.
_____________________________________
Pablo (Paul) BerzukovAuthor of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply