| |||||||||||||
Oracle: SELECT * FROM SunOracle: SELECT * FROM SunPosted Apr 20, 2009 22:12 UTC (Mon) by vivo (subscriber, #48315)Parent article: Oracle: SELECT * FROM Sun
more like
UPDATE `Sun` SET owner="Oracle";
(Log in to post comments)
Oracle: SELECT * FROM Sun Posted Apr 20, 2009 23:18 UTC (Mon) by bronson (subscriber, #4806) [Link]
SELECT employee FROM oracle LEFT JOIN sun ON (employee.task IN ('Java', 'Solaris'))
Oracle: SELECT * FROM Sun Posted Apr 21, 2009 0:28 UTC (Tue) by emak (guest, #488) [Link]
BEGIN;
INSERT INTO oracle (SELECT interesting_stuff FROM sun WHERE likely_to_make_money = 1);
DROP sun;
COMMIT;
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).
|
|||||||||||||