Pavel Popov velppa

## seq.sql
select rownum
  from dual
connect by level <= 1000;

## num_of_rows.sql
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||';

## data_as_inserts.sql
set heading off
set linesize 1000
rem set pagesize 50000
set echo off
set serveroutput on
SET FEEDBACK OFF
SPOOL out.sql

DECLARE
  cur SYS_REFCURSOR;

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

## newline.sql
with a as
(select q'{
 Line 1
 Line 2
 Line 3


 Line 4


## vim-ora-columncomment.txt
%s/\(.\+\)\t\(.\+\)\t\(.\+\)\t\(.\+\)/COMMENT ON COLUMN TABLE_NAME.\1 IS '\3 \4';/

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

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

## progress_bar.py

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)

## nt.pls
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
	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\|\|';
	set heading off
	set linesize 1000
	rem set pagesize 50000
	set echo off
	set serveroutput on
	SET FEEDBACK OFF
	SPOOL out.sql

	DECLARE
	cur SYS_REFCURSOR;

	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)
	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