Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- BEGIN
- FOR KOT IN (SELECT PSEUDO FROM KOCURY)
- LOOP
- EXECUTE IMMEDIATE
- 'CREATE TABLE TMP_KONTO_' || KOT.PSEUDO ||
- '(NR NUMBER(2) CONSTRAINT ' || KOT.PSEUDO || '_nr_pk PRIMARY KEY,' ||
- 'WAGA_MYSZY NUMBER(2) CONSTRAINT ' || KOT.PSEUDO ||'_wa_ch CHECK (waga_myszy BETWEEN 15 AND 20))';
- END LOOP;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement