foobarbaz-pl

for i in *.mov; do ffmpeg -i "$i" -vcodec h264 -acodec mp2 "${i%.*}.mp4"; done

foobarbaz-pl

alter session set "_fix_control"='20648883:OFF';

select * from v$system_fix_control where bugno = '20648883';
select * from v$session_fix_control where bugno = '20648883';

foobarbaz-pl

begin
    for i in 1..nvl(owa.num_cgi_vars, 0) loop
        htp.p(owa.cgi_var_name(i) || ': ' || owa.cgi_var_val(i));
    end loop;
end;

foobarbaz-pl

#<ig-static-id> .a-GV-w-hdr{
  overflow: auto!important;
}

foobarbaz-pl

git clone --no-checkout <REPOSITORY> <DIR>
cd <DIR>
git sparse-checkout init --cone       # checkout root dir files
git sparse-checkout set <SUBDIR_LIST> # subdirs list to include
git checkout

foobarbaz-pl

# clone repo
makepkg -sCLf
pacman -U --noconfirm *.pkg.tar.zst

foobarbaz-pl

select sid
  from v$lock
 where type = 'TO'
   and id1 = (select object_id
                from dba_objects
               where object_name = '&temp_table_name');

foobarbaz-pl

-- activate substitution variables
set define on
-- suppress echo for substitution variables
set verify off
-- activate stdout
set serveroutput on

define _IF_MASTER_INSTANCE="--"
col master_instance new_value _IF_MASTER_INSTANCE  noprint

foobarbaz-pl

declare
  l_sql        varchar2(32767);
  l_variables  varchar2(1000) := '';
  l_rac varchar2(50) := 'FALSE';
begin
  if dbms_utility.is_cluster_database then
    l_rac := 'TRUE';
  end if;

  l_variables := l_variables || 'RAC:' || l_rac || ',';

foobarbaz-pl

declare
  c_gr_len constant pls_integer := 4;
  l_enc  varchar2(100) := '&encoded_pwd';
  l_dec  varchar2(100);
  l_key  number;
  l_val  number;
  l_mask number;
  l_chars pls_integer;
begin
  l_chars := length(l_enc) / 4 - 1;