Facebook
From Diminutive Peccary, 1 Year ago, written in SQL.
Embed
Download Paste or View Raw
Hits: 72
  1. CREATE OR REPLACE FORCE VIEW "TECHAC188"."AD_TGFHISLOCH" (
  2.     "CODPARC",
  3.     "DTDEVREAL",
  4.     "DTPREVDEV",
  5.     "DTRETIRADA",
  6.     "NUEQP",
  7.     "NUNOTA",
  8.     "QTDDIASVENC",
  9.     "SEQUENCIA",
  10.     "TOTALMULTA",
  11.     "VLRMULTA",
  12.     "VLRTOT"
  13. ) AS
  14.     SELECT
  15.         0                     AS CODPARC,
  16.         TO_DATE('01/01/1970') AS DTDEVREAL,
  17.         TO_DATE('01/01/1970') AS DTPREVDEV,
  18.         TO_DATE('01/01/1970') AS DTRETIRADA,
  19.         0                     AS NUEQP,
  20.         0                     AS NUNOTA,
  21.         0                     AS QTDDIASVENC,
  22.         0                     AS SEQUENCIA,
  23.         1.0                  AS TOTALMULTA,
  24.         1.0                  AS VLRMULTA,
  25.         1.0                  AS VLRTOT
  26.     FROM
  27.         DUAL;
  28.