Skip to content

Instantly share code, notes, and snippets.

@msmrz
msmrz / change_timestamp_precision.sql
Last active June 29, 2023 10:45
Change precision of timestamp columns
set serveroutput on;
set autoprint on;
declare
type t_temp_storage is table of varchar2(4000);
column_constraints t_temp_storage;
column_indexes t_temp_storage := t_temp_storage();
column_indexes_names t_temp_storage;