set long 1000
  set pages 1000
  select DBMS_METADATA.GET_DDL('VIEW', VIEW_Name) from user_views where view_name = 'V_KOFAX_LEVERANCIER'


Alternatief : select dbms_metadata.get_ddl('VIEW','V_KOFAX_LEVERANCIER') from dual;


DBMS_METADATA.GET_DDL('VIEW',VIEW_NAME)
--------------------------------------------------------------------------------

CREATE OR REPLACE FORCE VIEW "VERSEON"."V_KOFAX_LEVERANCIER" ("LEVID", "LEVNAAM", "REKNR", "POSTCODE", "ZOEKVELD", "LEVEID") AS
SELECT NAWExternApplicatieID, NAWNaam, nawbankrekening, nawpostcode, to_char(NAWBankrekening), NAWExternApplicatieID
FROM cios_object WHERE classid='F1E0D7A1-351B-43BC-97C4-B9118556B610'
UNION 
select NAWExternApplicatieID, NAWNaam, nawbankrekening, nawpostcode, trim(lower(substr(NAWNaam, 1, 4))), NAWExternApplicatieID
from cios_object
where classid='F1E0D7A1-351B-43BC-97C4-B9118556B610'
UNION
SELECT NAWExternApplicatieID, NAWNaam, nawbankrekening, nawpostcode, (upper(nawpostcode)), NAWExternApplicatieID
FROM cios_object
WHERE classid='F1E0D7A1-351B-43BC-97C4-B9118556B610'




Gesponsorde koppelingen