Benjamin Intsiful on Oracle APEX

Abstract: A function you can use to calculate business days. Includes provisions for after hours calculations. There are quite a number of examples already on the web for calculating business days on Oracle. However, none of these did exactly what I needed for a job I was doing. What's different about my environment is the need to consider multiple geographic regions and to consider work hours and that different regions might have different work hours. Here are the deciding factors for how this function decides what to with timestamp after hours (both weekends and during the week) If the start date is after the end of the work day, and before midnight, it is advanced to the beginning of next work day. If the start date is before the beginning of the day (and therefore after midnight), it is advanced to the beginning of the current work day. If the start date is on a Saturday, it is advanced to the beginning of work day on the following Monday. If the start date is on a

The following are step-by-step instructions on using SSMA to migrate Oracle’s sample HR schema to SQL Server 2008: 1. Download the SQL Server Migration Assistant for Oracle from here . After download, extract the installation files. 2. Install SSMA for Oracle on your client machine 3. Install SSMA for Oracle extension pack on the target SQL server machine. 4. Start the application by double-clicking the shortcut on your desktop: 5. Obtain a license key. The first time you use SSMA for Oracle, you will be directed to a registration site from which you can obtain a license key (stored in a file called oracle-ssma.license). You will have to indicate the directory in which you will save this file (for example: C:\install\): Click Refresh License and SSMA tool will open. 6. Change default project setting. By default , SSMA loads only basic Oracle system schemas and packages. You need to customize project settings to allow loading of HR sample schema. Click on Tools from the