var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to create view in if statement in oracle
When No Data Found
create view a as select * from abc;
Error show at line create view .This code present in one exception block procedure.
This sounds as a very wrong approach to any problem you might have.
I can't imagine scenario which includes creating a view if an exception is raised. By the way, even if you do that (once), it would fail the second time (as the view would already exist).
Anyway: dynamic SQL (EXECUTE IMMEDIATE) can be used to perform DDL from a PL/SQL procedure but - once again - this is most probably wrong.
Which problem are you trying to solve?
Tags for this Thread