Enable/Disable autocommit in Toad.

Enable/Disable autocommit Toad

You can Enable or Disable the autocommit in Toad.

Utilities -> Toad Options -> Oracle -> Transactions -> Commit After Every Statement.

Enable/Disable autocommit in Toad. was last modified: October 1st, 2017 by Justin Antony

PlSql Filter code for SSRS Report

Filter code SSRS

where TO_DATE(COL_Date, 'mm/dd/yyyy') = :Date_VAR
AND TO_CHAR(NVL(COL_CHAR,'*')) = REPLACE( :CHAR_VAR,'ALL',NVL(COL_CHAR,'*'))
And  NVL(TO_CHAR((COL_NUMERIC)),'*') = REPLACE( :COL_NUMERIC,'ALL',NVL(TO_CHAR((COL_NUMERIC)),'*'))
PlSql Filter code for SSRS Report was last modified: October 1st, 2017 by Justin Antony