By Jim Czuprynski – Oracle Label Security (OLS) is a relatively new feature of Oracle 9i. It offers a powerful implementation of row-based security that’s perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. This article presents a high-lev
Tag: Oracle
Database Revolution
By Kelli Wiseth – The world’s first self-managing, grid-ready database is here. Oracle Database 10g, Oracle’s new database release, takes manageability and performance to a new level while ushering in the era of commercial grid computing. Can you scale up your processing power as needed without scal
BECOME ONE OF THE FIRST ORACLE9i FORMS DEVELOPER OCPS
Take the Oracle9i Forms Developer: Build Internet Applications exam (#1Z1-141) to upgrade your Oracle9i PL/SQL Developer Certified Associate (OCA) credential to Professional status (OCP). The Beta Exam period has been extended until October 1, 2003.
Oracle 10G: Not Just A Database
By Barbara Darrow & Steven Burke – Oracle is turning up the volume on the message that its software stack, above and beyond its database, is in the big leagues. At OracleWorld in San Francisco this month, the company will continue to beat the grid-computing drum and hone in on its upcoming Or
Oracle’s grid technology should reopen your one-stop shop question
By David Berlind – It’s time for yet another OracleWorld, where the ever-charismatic CEO Larry Ellison is expected to deliver another keynote that’s full of hyperbole and verbal assaults on his main competitors. IBM, Microsoft, and probably BEA will not escape unscathed. But the two major issues of
Free Tablespace Report (including Autoextend)
by Michael Dinh – I am more concerned with tablespace storage FREE versus tablespace storage USED. The following script provides tablespace storage FREE, taking autoextend into consideration.
Oracle Optimizer: Moving to and working with CBO – Part 2
By Amar Kumar Padhi – Part 2 of this series covers the Initialization parameters and Hidden or Internal Oracle parameters that influence the Optimizer in choosing execution plans. It is very important to setup these parameters properly.
Oracle e-Mails Raise Questions About Motive
By Renee Boucher Ferguson – The release of uncensored court documents around Oracle Corp.’s hostile bid for PeopleSoft Inc. has raised the mudslinging between the two companies to a near fever pitch.
Oracle PL/SQL Best Practices
Book By Steven Feuerstein – Oracle PL/SQL Best Practices is a concise, easy-to-use summary of best practices in the program development process. It covers coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in pack
Enable Logical Object Representation in Your Database
by Sergey Savouchkine – This article discusses the three properties (complex data, type inheritance, and object behavior) that characterize the object-oriented database management system and explains how two object-relational languages (SQL3 and Zigzag) compare when used within each property.
