Advertisement
Guest User

Untitled

a guest
Jan 16th, 2018
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DECLARE
  2. BEGIN
  3.  FOR KOT IN (SELECT PSEUDO FROM KOCURY)
  4.  LOOP
  5.  EXECUTE IMMEDIATE
  6.  'CREATE TABLE TMP_KONTO_' || KOT.PSEUDO ||
  7.  '(NR NUMBER(2) CONSTRAINT ' || KOT.PSEUDO || '_nr_pk PRIMARY KEY,' ||
  8.  'WAGA_MYSZY NUMBER(2) CONSTRAINT ' || KOT.PSEUDO ||'_wa_ch CHECK (waga_myszy BETWEEN 15 AND 20))';
  9.  END LOOP;
  10. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement