PL/SQL Create&Replace&Alter View


create or replace force view "xyz"."vew_test_table_name"
as
select * from test_table_name;

alter view "xyz"."vew_test_table_name"
add constraint pk_vew_test_table_name_id primary key (id) disable;

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Getting Umbraco Content - IPublishedContent vs IContent vs Node vs Document