-
Change Default Display
How to change the default display? For deptno 10 show "Financial Department", for deptno 20 show "Account Department", for deptno 30 show "Management Information System", for deptno 40 show "Electronic Data Processing"
-
-
Oracle Apps standard Calendar
How to Show apps standard Calendar in Query Mode ?. Can anyone tell me how to show calendar in query mode in Standard/Custom forms. It is working fine in insert mode.RegardsSatish Shrivastava
-
-
-
-
What is the output of the following pl/sql block ?declare v_empno emp.empno%type;begin select empno into v_empno from emp where empno = 10;exception when others then dbms_output.put_line ( 'no data found'); when no_data_found then dbms_output.put_line ( 'ther is no data found ');end;
when others then *ERROR at line 6:ORA-06550: line 6, column 2:PLS-00370: OTHERS handler must be last among the exception handlers of a blockORA-06550: line 0, column 0:PL/SQL: Compilation unit analysis terminated
-
What are various constraints used in SQL?
NULLNOT NULLCHECKDEFAULT