Alter Hase
Date of registration: Oct 9th 2002
Location: Zimbabwe-Island Ost Beiträge: 3.427
Occupation: Informatiker
Source code |
|
1 2 3 4 |
DECLARE BEGIN dbms_output.put_line('Tabelle: ' || create_stat_table('TEST')); END; |
Alter Hase
Date of registration: Oct 9th 2002
Location: Zimbabwe-Island Ost Beiträge: 3.427
Occupation: Informatiker
This post has been edited 1 times, last edit by "Ray-D" (Jun 13th 2005, 1:35pm)
Source code |
|
1 |
EXECUTE add_statistic('MOVIEDB', 'PERSON'); |
Source code |
|
1 |
SELECT COUNT(cname) INTO totvar FROM tname; |
Source code |
|
1 |
EXECUTE IMMEDIATE 'SELECT COUNT(:7) INTO totvar FROM :8' USING cname, tname; |
Source code |
|
1 |
SELECT 8*8 INTO totvar FROM dual; |
Source code |
|
1 |
EXECUTE IMMEDIATE 'insert into :1 values (:2, :3, :4, :5, :6)' USING tname, tabelle, colname, total, diff, nulls; |
Source code |
|
1 |
EXECUTE IMMEDIATE 'insert into ' || tname || ' values (:1, :2, :3, :4, :5)' USING tabelle, colname, total, diff, nulls; |
Quoted
Original von mDev
zu 1a)
man soll zwei primärschlüssel definieren, er meckert aber dass es nur einen geben kann
zu 1d)
wie kann ich den offenen cursor aus 1b) benutzen?