How do I create a view only if it doesn't exist. If it does exist, I want to drop the view and redefine it. I also want no warnings or errors.
darn, you beat me to it and i didn't get a notification an answer was posted already. so +1 from me.
Roland Bouman
2010-02-11 16:27:04
A:
CREATE OR REPLACE VIEW <view name>
AS
<your select expression goes here>
Roland Bouman
2010-02-11 16:26:03