drop and create sequence from a stored procedure

[efrijters]

Originally posted by liorjsb
how can I check if the sequence exists before I create it?

Maybe old news, but you can create a cursor like 'select view_name from user_views where view_name="my_view";'