PL/SQL Check Constraint & Unique Index

Add Check Constraint
alter table table_name
add constraint chk_table_name_column_name
check (column_name=nls_upper(adi,'NLS_SORT=XTURKISH')) enable;

Create Unique Index
create unique index "schema_name"."ind_table_name_column_name" on "schema_name"."table_name"
  (
    "column_name"
  );

Drop Index
drop index ind_table_name_column_name;

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"