velppa

SQL> with s as (
    select 1 a,  10 b from dual union all
    select 20 a, 30 b from dual union all
    select 30 a, 40 b from dual union all
    select 50 a, 60 b from dual union all
    select 55 a, 57 b from dual union all
    select 65 a, 75 b from dual union all
    select 70 a, 80 b from dual union all
    select 75 a, 85 b from dual
)

velppa

select rownum 
  from dual 
connect by level <= 1000;

velppa

DECLARE
  n NUMBER;
BEGIN
  FOR rec IN (SELECT owner,
                     table_name
                FROM all_tables WHERE owner = 'OWNER') -- replace OWNER with target schema
  LOOP
    EXECUTE IMMEDIATE 'begin
     select count(*) into :n from '||
      rec.owner||'.'||rec.table_name||';

velppa

^(?!.*(IF .* THEN|END IF;)).*$

velppa

with a as
(select q'{
 Line 1
 Line 2
 Line 3
 
 
 Line 4
    
 

velppa

%s/\(.\+\)\t\(.\+\)\t\(.\+\)\t\(.\+\)/COMMENT ON COLUMN TABLE_NAME.\1 IS '\3 \4';/

velppa

'asdf@gmail.com, , , qwer@gm.com, , '.split(',').map{|i| i.strip()}.find_all{|i| not i.empty?}.join(", ")

velppa

', '.join(filter(lambda x: x != '', [x.strip() for x in 'asdf@gmail.com, , , qwer@gm.com, , '.split(',')]))

velppa

import sys

class ProgressBar():

    def __init__(self, num_steps):
        self.num_steps = num_steps

    def progress(self, step):
        i = int(100.0 * step / self.num_steps)

velppa

declare
  TYPE row_nt IS TABLE OF number;
  a row_nt;

  cursor a_cur is
    select level from dual connect by level <= 100;
  
  n number;

begin