বুধবার, ২৭ এপ্রিল, ২০২২

DML Checking in view

select table_name,column_name,updatable,insertable,deletable from

USER_UPDATABLE_COLUMNS where table_name='MM_ITEM_INFO_V'


CREATE VIEW EMP_SAL AS SELECT EMPNO, ENAME ,SAL FROM EMP WHERE SAL < 2000 WITH CHECK OPTION;