top of page

LazyDeploy.com
It's just one click!
Search
Get DDL for Oracle object
set feed off set long 1000000 set longchunksize 1000000 set pages 0 set lines 32767 set trimspool on set feed off set wrap on set...
mdvorkin
Oct 27, 20211 min read
Cancelled scheduled concurrent requests
This SQL query returns all concurrent requests that were scheduled in the past and are not scheduled currently. It can be used for...
mdvorkin
Oct 27, 20211 min read
Foreign key constraint violation
/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...
mdvorkin
Oct 27, 20212 min read
From Concurrent to Trace
-- Find running concurrent request's database session SELECT fcr.request_id, ftl.user_concurrent_program_name program_name, v.meaning...
mdvorkin
Sep 30, 20211 min read
bottom of page