What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-01-21 23:42:02
oracle show running job
SELECT * FROM USER_SCHEDULER_RUNNING_JOBS; -- connected scheme SELECT * FROM ALL_SCHEDULER_RUNNING_JOBS; -- granted to connected scheme SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS; -- all jobs (DBA) -- More details (DBA) SELECT DISTINCT r.OWNER, r.JOB_NA... Add solution -
SQL 2022-01-21 23:41:54
mysql select and count left join
select t.Topic, t.Title, count(distinct s.starID) as StarCount, count(distinct m.User) as UserCount, count(distinct m.messageID) as MessageCount from Topics t left join Messages m ON m.Topic = t.Topic left join Stars_Given s ON s.Topic = t... Add solution -
SQL 2021-11-22 04:39:12
insert into in DBT prehook
{%- macro profile_schema(table_schema) -%} {{ config(schema='profiles') }} {% set not_null_profile_threshold_pct = ".9" %} {% set unique_profile_threshold_pct = ".9" %} {% set tables = dbt_utils.get_relations_by_prefix(table_schema,... Add solution -
TypeScript 2021-11-20 05:38:11
longest increasing subsequence when elements hae duplicates
#include <iostream> #include <algorithm> using namespace std; // define maximum possible length of X and Y #define N 20 // lookup[i][j] stores the length of LCS of subarray X[0..i-1], Y[0..j-1] int lookup[N][N]; // Functio... Add solution