Profile
Join date: Oct 5, 2020
Posts
Oct 27, 2021 ∙ 1 min
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...
3
0
Oct 27, 2021 ∙ 1 min
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...
3
0
Oct 27, 2021 ∙ 2 min
Foreign key constraint violation
/* This PL/SQL script checks violations of foreign key constraints Example of the tables: CREATE TABLE temp_supplier ( supplier_id...
1
0
mdvorkin
Admin
More actions