Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- EXTRACTVALUE(SYS.XMLTYPE.createxml(PEDIDO_FAT_NFE.PEDF_NFE), '/nfeProc/NFe/infNFe/ide/dEmi/text()','xmlns="http://www.portalfiscal.inf.br/nfe"') d_Emi,
- EXTRACTVALUE(SYS.XMLTYPE.createxml(PEDIDO_FAT_NFE.PEDF_NFE), '/nfeProc/NFe/infNFe/ide/nNF/text()','xmlns="http://www.portalfiscal.inf.br/nfe"') n_NF
- ,EXTRACT(SYS.XMLTYPE.createxml(PEDIDO_FAT_NFE.PEDF_NFE), '/nfeProc/NFe/infNFe/det/prod/xProd/text()','xmlns="http://www.portalfiscal.inf.br/nfe"').getStringVal() x_Prod
- FROM PEDIDO_FAT_NFE
- WHERE PEDIDO_FAT_NFE.PEDF_PEDF_EMP_ID = 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement