Skip to content

Instantly share code, notes, and snippets.

@douglaslise

douglaslise/ora600.sql

Created November 30, 2015 18:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save douglaslise/192c5c40b6d141b88c8e to your computer and use it in GitHub Desktop.
Save douglaslise/192c5c40b6d141b88c8e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ora600.sql
declare
a clob;
begin
a := '2015-11-26 20:21:42`a,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] 2015-11-26 20:21:42,715 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/WMobileServer]] I, [2015-11-26T20:21:42.715000 #29889] ';
UPDATE "MOB_SINCRONIZACOES" SET "DT_ULTIMA_ETAPA" = sysdate, "LOG" = a, "ULTIMA_ETAPA" = 'abc' WHERE "MOB_SINCRONIZACOES"."W_ID" = 149961;
end;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment