Jedi powers, step one SQL

 
--the view isn't present:
select * from user_views
where  view_name = 'INTO_EXISTENCE';

-- if we don't FORCE it...
create view into_existence as 
  select i_want_to_refer_to_it,
         despite_selecting
  from   a_table_that_doesnt_exist;

-- ... it's still not here
select * from user_views
where  view_name = 'INTO_EXISTENCE';

create force view into_existence as 
  select i_want_to_refer_to_it,
         despite_selecting
  from   a_table_that_doesnt_exist;
  
desc into_existence

-- now it is though, hurrah! (though it is invalid...)
select * from user_views
where  view_name = 'INTO_EXISTENCE';
  
drop view into_existence;

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)