Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BEGIN
- EXECUTE IMMEDIATE 'CREATE TABLE test AS (
- SELECT duration AS NUM1
- FROM event WHERE
- duration IS NOT NULL
- )WITH NO DATA';
- EXECUTE IMMEDIATE 'INSERT INTO test (
- SELECT duration AS NUM1
- FROM event WHERE
- duration IS NOT NULL
- )';
- END
Advertisement
Add Comment
Please, Sign In to add comment
