(Murthy Mamidanna) Here is a SQL query that lists the start and end dates of the weeks that passed in the month at any given date. For example, suppose that today’s date is 28 April 2003, and you want to list the start and end dates of the weeks (weeks are defined as starting on Monday and ending on

(James Koopmann) In Part I of this series, we saw how to create an abstract data type and define an array within a table. The mechanisms for inserting data into this structure and selecting data from this structure was not too difficult but did require some thought processes and will no doubt look a

(Amar Kumar Padhi) On occasion, it may be necessary to implement business logic where, when one routine or business process is being run by a user, certain other routine(s) should not be allowed to run and vice versa. This requirement may be a functional or a technical need.

(Pasupuleti Sailaja) To display a blank line you can use chr(0) with DBMS_OUTPUT.PUT_LINE. To display beginning spaces you can use chr(9) or chr(160) with DBMS_OUTPUT.PUT_LINE.

Until now, the export/import toolset has been the utility of choice for transferring data across multiple platforms with minimal effort, despite common complaints about its lack of speed. Import merely reads each record from the export dump file and inserts it into the target table using the usual I

(Arup Nanda) Ensuring appropriate information privacy is a pressing concern for many businesses today, given privacy legislation such as the United States’ HIPAA (Health Insurance Portability and Accountability Act), Gramm-Leach-Bliley Act, Sarbanes-Oxley Act, and the EU’s Safe Harbour Law. Other pr

This webcast with coauthor of the “Oracle9iAS Administration Handbook” focuses on the techniques Oracle professionals use to detect and correct performance bottlenecks in Oracle9iAS. (R)

(Carol Francum) Listening in to a conversation between Oracle users can be very confusing: Imagine stepping into the break room and you hear Phil and Bill say, “We’re looking at migrating to 11i, we’re on 10.7 using 8.1.4.”

(Sidhartha Upadhyay) Use this function to find the number of days between two given dates.

The Oracle Index Tuning wizard is a software application that identifies tables with inefficient indexes and makes recommendations which will improve access to those tables. The Index Tuning wizard: –Identifies tables in need of index changes –Presents its findings in reports –Implement