By Max Mangoni – Coalescing tablespace extents is fundamental when the database contains a lot of fragmentated tablespaces. This happens when database objets are often truncated or droppend and re-created. This simple korn shell script helps to automate cleaning of tablespaces.

Oracle9i and SQL Server 2000 add enhancements to the standard SQL language that enable you to use the database to implement your business rules and processes SQL Server with Transact-SQL and Oracle with PL/SQL. Find out why the Oracle database engine is better suited for this role.

Amar Kumar Padhi shares usage tips and examples of EXECUTE IMMEDIATE, which replaced DBMS_SQL package in Oracle 8i and above.

By Peter Galli – Oracle Corp. plans to spend some $150 million this year on a new initiative designed to greatly increase the number of applications available to customers on the Unbreakable Linux platform.

By Gareth Morgan – Oracle has cut the price of its e-business software suite as it tries to drum up business, but analysts warn that deployment and ongoing costs are more important than upfront bargains.

By Sergey Solodilov – This tip decreases the size of files of a tablespace to the bare minimum. It’s useful when you have many files in a tablespace and you’ve moved some tables or indexes into another tablespace, and then you want to decrease the size of the first tablespace.

By James Niccolai – Oracle is launching a program to encourage its software partners to offer versions of their applications for Linux, and it will pay out some $150 million a year as part of the initiative to help with their marketing and development efforts.

by Sunil Bhola – Everyone knows that how to get the first row from a table but what if you want to get the last row and don’t know how many rows are in the table? This query will solve it!

by T.R. Bharath Rajkumar – Normally I use FOR UPDATE NOWAIT to acquire a lock on rows. This statement either locks all the selected rows or the control is returned without acquiring any lock (i.e. even on rows which are available for locking) after throwing an exception.But there is an featu

When Larry Ellison asked him to design a Linux-based Internet appliance, Wim Coekaerts reported back with a plan a couple of weeks later–and won himself a new task.