SHARE
TWEET

Untitled

a guest Apr 20th, 2019 85 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. --IMPORTANTE: O ÚLTIMO PARAMENTRO INDICA QUAL O GRUPO QUE SERÁ RETORNANDO, VIDE EXEMPLO:
  2.  
  3. -- RECUPERA DA MENSAGEM O NOME DA USUÁRIO/SCHEMA, RETORNANDO  "SCHEMA"
  4. SELECT REGEXP_SUBSTR('ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_NAME"."COLUMN_NAME")','"(.*?)"',1,1) FROM DUAL;
  5.  
  6. -- RECUPERA DA MENSAGEM O NOME DA TABELA, RETORNANDO  "TABLE_NAME"
  7. SELECT REGEXP_SUBSTR('ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_NAME"."COLUMN_NAME")','"(.*?)"',1,2) FROM DUAL;
  8.  
  9. -- RECUPERA DA MENSAGEM O NOME DA COLUNA, RETORNANDO  "COLUMN_NAME"
  10. SELECT REGEXP_SUBSTR('ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE_NAME"."COLUMN_NAME")','"(.*?)"',1,3) FROM DUAL;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top