Posts by GaberRB • 21 points

• 0

  votes

  1

  answer

  70

  views

  A: Log trigger that saves the numbering of the JOB that executed the change

  CREATE OR REPLACE TRIGGER TL_MAP_PRODUTO_LOG AFTER UPDATE ON PRODUTO REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW DECLARE ------------------ --- VARIAVEIS --- …

  oracle pl-sql

  answered 4 years, 6 months ago GaberRB 21

• 0

  votes

  1

  answer

  70

  views

  Q: Log trigger that saves the numbering of the JOB that executed the change

  I need an oracle resource to use on a Trigger, which searches which JOB or Scheduler_job executed such a change. I am using Sys_context to get some example information: User, Terminal, Program…

  oracle pl-sql

  asked 4 years, 6 months ago GaberRB 21

• 0

  votes

  0

  answers

  152

  views

  Q: Trunc date oracle, Tuning SQL

  Is there any way to optimize query sql, where it is necessary to truncate two dates of a column? Select * from work_table a where trunc(a.datetime) = trunc(a.datetime);…

  sql oracle

  asked 5 years, 3 months ago GaberRB 21

• 0

  votes

  1

  answer

  342

  views

  A: Oracle dynamic query in columns

  I solved the problem using Run Immediet, in this way it is possible to save the value of the columns in a variable to perform the update. This script is using when there is creation of columns in…

  sql oracle pl-sql oracle11g

  answered 5 years, 4 months ago GaberRB 21

• 2

  votes

  1

  answer

  342

  views

  Q: Oracle dynamic query in columns

  I have the following situation, I need to create a dynamic query between the columns to mount a Script. Assuming there is a change in the versions where an extra column is added in the table, the…

  sql oracle pl-sql oracle11g

  asked 5 years, 4 months ago GaberRB 21