| |||||||||||||
Oracle: SELECT * FROM SunOracle: SELECT * FROM SunPosted Apr 21, 2009 0:28 UTC (Tue) by emak (guest, #488)In reply to: Oracle: SELECT * FROM Sun by vivo Parent article: Oracle: SELECT * FROM Sun
BEGIN;
INSERT INTO oracle (SELECT interesting_stuff FROM sun WHERE likely_to_make_money = 1);
DROP sun;
COMMIT;
(Log in to post comments)
Oracle: SELECT * FROM Sun Posted Apr 21, 2009 8:03 UTC (Tue) by nix (subscriber, #2304) [Link]
You want PostgreSQL for that there transctional DDL. Oracle can't do
it. ;)
Oracle: SELECT * FROM Sun Posted Apr 21, 2009 20:47 UTC (Tue) by flewellyn (subscriber, #5047) [Link]
Yet another reason to prefer Postgres, then!
Oracle: SELECT * FROM Sun Posted Apr 21, 2009 21:51 UTC (Tue) by nix (subscriber, #2304) [Link]
Oh god yes. I work with Oracle's RDBMS every day and I would give *so*
much to be able to use PostgreSQL instead. But big banks are scared of it (and I suppose it probably doesn't scale quite as well either).
|
|||||||||||||