Thanks for the question, Joseph.
Asked: August 01, 2017 - 3:05 pm UTC
Last updated: August 01, 2017 - 3:59 pm UTC
Version: ORACLE 11G
Viewed 10K+ times! This question is
create table t as select * from user_objects; create table t1 as select * from t; update t set created = ( select created from t1 where object_id = t.object_id ), object_name = ( select object_name from t1 where object_id = t.object_id ), object_type = ( select object_type from t1 where object_id = t.object_id ) MY ORIGINAL CODE UPDATE DOBS.CP_ITEMIZED SET DOBS.CP_ITEMIZED.PHYSICIAN_FIRST_NAME = ( SELECT P.First_Name_1 FROM DOBS.CP_FED_HCP_FOR_RPT H INNER JOIN DOBS.CP_NPI_TAKEDAID_MATCH M ON H.TAKEDA_ID = M.TAKEDA_ID INNER JOIN DOBS.CP_CMS_PHYSICIAN_LIST P ON H.DCH_NPI = P.NPI WHERE DOBS.CP_ITEMIZED.TAKEDA_ID = H.TAKEDA_ID AND H.In_CMS_list = 'Yes' AND H.Valid_For_Federal = 'Yes' AND H.In_NPI_Match = 'Yes' ), DOBS.CP_ITEMIZED.PHYSICIAN_MIDDLE_NAME = ( SELECT P.Middle_Name_1 FROM DOBS.CP_FED_HCP_FOR_RPT H INNER JOIN DOBS.CP_NPI_TAKEDAID_MATCH M ON H.TAKEDA_ID = M.TAKEDA_ID INNER JOIN DOBS.CP_CMS_PHYSICIAN_LIST P ON H.DCH_NPI = P.NPI WHERE DOBS.CP_ITEMIZED.TAKEDA_ID = H.TAKEDA_ID AND H.In_CMS_list = 'Yes' AND H.Valid_For_Federal = 'Yes' AND H.In_NPI_Match = 'Yes' ) WHERE EXISTS ( SELECT 1 FROM DOBS.CP_FED_HCP_FOR_RPT WHERE DOBS.CP_FED_HCP_FOR_RPT.TAKEDA_ID = DOBS.CP_ITEMIZED.TAKEDA_ID );
select object_id, object_type from user_objects where object_name = 'T'; no rows selected create table t ( x int ); select object_id, object_type from user_objects where object_name = 'T'; OBJECT_ID OBJECT_TYPE 117341 TABLE
Joseph Giallombardo, August 01, 2017 - 4:04 pm UTC
The Oracle documentation contains a complete SQL reference.