How to enable/disable case sensitive passwords in Oracle11g?

Case-sensitive passwords are a new security feature introduced in Oracle 10g, however this feature is enabled by default in Oracle 11g.If you utilise an older version of Oracle Forms (6i in my instance) with an Oracle 11g...

Read More

How to delete duplicate rows from a table

 SQL> SELECT * FROM EMP;        ID NAME---------- --------------------        10 SCOTT        10 SCOTT       ...

Read More

Send Email From Oracle Database

 The steps to send emails from an Oracle database are as follows:Step 1:CREATE DIRECTORY MYEMAIL AS 'C:\file_data';GRANT READ,WRITE ON DIRECTORY MYEMAIL TO SCOTT;Step 2:CREATE OR REPLACE PROCEDURE send_mail (p_to ...

Read More

Oracle Forms: Avoid duplicated records in a block

 Rejecting two records with duplicate values is the goal.Two computed items are utilised, one in the data block and the other in the control block.The DEPT block now contains the first computed item (:DEPT.MATCH FOUND)....

Read More