例えば、
通常:select A from table1 where rownum < 100
uipathのVBで:“select A from table1 where rownum < 100”
今下記通常のsqlをVBで書きたいですが、ダブルクォーテーションが多くよく分からなくなってきました。どなたが教えていただきますか?
通常:
*************************
select ‘"’ || nvl(TRIM(EMR_EMP_ID), ‘’) || ‘"’ AS EMR_EMP_ID
,‘"’ || nvl(EMR_CORP_ID,‘’)|| ‘"’
, ‘"’ || nvl(EMR_RINGS_HANSH_CD,‘’)|| ‘"’
, ‘"’ || nvl(EMR_RINGS_EMP_CD,‘’)|| ‘"’
, ‘"’ || nvl(TRIM(EMR_DISPLAY_FLG),‘’)|| ‘"’ AS EMR_DISPLAY_FLG
, ‘"’ || nvl(TRIM(EMR_MAIN_HANSH_FLG),‘’)|| ‘"’ AS EMR_MAIN_HANSH_FLG
, ‘"’ || nvl(UPDATE_CORP_ID,‘’)|| ‘"’
, ‘"’ || nvl(TRIM(REGISTER_USER_ID),‘’)|| ‘"’ AS REGISTER_USER_ID
,‘"’ || nvl( REGISTER_USER_NAME,‘’)|| ‘"’
,‘"’ || nvl(TRIM(UPDATING_USER_ID),‘’)|| ‘"’ AS UPDATING_USER_ID
, ‘"’ || nvl(UPDATING_USER_NAME,‘’)|| ‘"’
, ‘"’ || nvl(TO_CHAR(REGISTER_DATE, ‘YYYY/MM/DD HH24:MI:SS’),‘’)|| ‘"’ AS REGISTER_DATE
, ‘"’ || nvl(TO_CHAR(UPDATING_DATE, ‘YYYY/MM/DD HH24:MI:SS’),‘’)|| ‘"’ AS UPDATING_DATE
, ‘"’ || nvl(REGISTER_PROGRAM_ID,‘’)|| ‘"’
, ‘"’ || nvl(UPDATING_PROGRAM_ID,‘’)|| ‘"’
From TJMOB230_EMP_RINGS Where EMR_DISPLAY_FLG=‘1’ AND EMR_CORP_ID IN ( ‘000001’)
****************************