database | panticz.de

Install SQuirreL SQL

<?php
$URL="https://raw.githubusercontent.com/panticz/installit/master/install.squirrel-sql.sh";

echo "wget $URL -O - | bash -";
echo "<div><pre>";
</pre></div>

$c = curl_init();
curl_setopt($c, CURLOPT_URL, $URL);
curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);

echo htmlspecialchars(curl_exec($c));

curl_close($c);

echo "";

Oracle Jobs

view jobs
select *
from user_scheduler_jobs

create job
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'YOUR_JOB_NAME',
job_type => 'stored_procedure',
job_action => 'testproc',
start_date => TRUNC(SYSDATE),
repeat_interval => 'freq=DAILY;byhour=5',
-- repeat_interval => 'freq=hourly;byminute=5',
-- repeat_interval => 'freq=DAILY; BYDAY=MON,TUE,WED,THU,FRI; BYHOUR=7,15',
enabled => TRUE
);
END;

delete job
exec dbms_scheduler.drop_job('YOUR_JOB_NAME')

Databases

DB Clients
http://www.squirrelsql.org - SQuirreL SQL, universal SQL Client, supports MS SQL and other DB

Connect from OpenOffice / LibreOffice to MsSQL Server
http://www.oooforum.org/forum/viewtopic.phtml?t=24036

Links
https://flywaydb.org/getstarted/ - database migrations

database