Database Administration (MOSC)

MOSC Banner

XML to CLOB taking too much of time

edited Oct 8, 2009 4:47AM in Database Administration (MOSC) 1 commentAnswered
---------------------------------------------------------------**************-----------------------------------------------------------------

-------------------------------------------------------------------------------------------------------------------------------------------

 INSERT /*+ APPEND */ INTO TMP_CONNECTION_ACCOUNTS SELECT :B1 , MPCA.CONNECTION_ID_V , MPCA.ACCOUNT_ID_N , XMLTYPE('<connection-specific><connection value="0"></connection></connection-specific>'). APPENDCHILDXML('/connection-specific/connection',TDFI.FF_XML_X). APPENDCHILDXML('/connection-specific/connection',TDGP.GROUP_XML_X). APPENDCHILDXML('/connection-specific/connection',TDHM.HOMEZONE_XML_X). APPENDCHILDXML('/connection-specific/connection',TDLG.LANGUAGE_XML_X). APPENDCHILDXML('/connection-specific/connection',TDWB.WBLIST_XML_X). APPENDCHILDXML('/connection-specific/connection',TDSM.SEMI_AUTO_XML_X). GETCLOBVAL() FROM TMP_DERIVED_FF_INFO TDFI, TMP_DERIVED_GROUP_INFO TDGP, TMP_DERIVED_HOMEZONE_INFO TDHM , TMP_DERIVED_LANG_INFO TDLG, TMP_DERIVED_WBLIST_INFO TDWB , TMP_DERIVED_SEMIAUTO_INFO TDSM, CONNECTION_ACCOUNT_MAP MPCA

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center