(Jim Czuprynski) Oracle Label Security (OLS) offers a powerful implementation of row-based security that is perfect for restricting user access to specific data, especially in a data mart or data warehousing environment. Previous articles presented a brief overview of how these features work, and ho
Other News
Creating a Number (Sequentially incrementing values) table in T-SQL
There are many methods to create a Number/Sequencing table. With these methods, you will end up with a table of sequentially incrementing integer values that can be used for many SQL shortcuts & tricks.
Set-Operation Alternatives
(Itzik Ben-Gan) ANSI SQL defines three operations—UNION, INTERSECT, and EXCEPT—that you can apply to two sets. These operations let you combine rows from different sets, locate which rows exist in both input sets, or find which rows exist in one set but not the other. Each of these operations has ma
What’s Your Government Doing with XML? – With the advent of XML authoring tools, it’s more than you might think
(Bryan Baker) Popular wisdom dictates that governments are slow to adopt anything new, especially when it comes to new technologies. But if you look closely, you might find something unexpected. Across the U.S. and around the world, governments are integrating XML into their workflow. From legis
Edge 2004 East – Development Technologies Exchange
This conference is for developers. There will be 5 Tracks, Five Session Flavors for i-Technology Professionals. Sessions are on Java, web services, .Net, XML and MX. Discounts of up to $400 for early registration.
Compiling DB2 UDB Stored Procedures with GCC on Windows
(Jim Haungs) Historically, using stored procedures in DB2 has required a separately installed (and sometimes costly) C compiler. The solution outlined in this document describes how to install and use the GNU C Compiler (GCC), a free open-source C compiler. DB2 Universal Database stored procedure
Oracle Technical Interview Questions Answered – Part 2
(James Koopmann) This is the second part of the two part series on helping you answer those tough questions that you might experience in your quest for an Oracle DBA position. The Oracle Technical Interview can be quite daunting. You never quite know what to study for and how to prepare. I am fu
Tip: Screen XML documents efficiently with StAX
(Berthold Daum) With the Streaming API for XML (StAX), you can screen XML documents efficiently without the drawbacks of traditional push parsers. This tip shows you how to retrieve specific information from XML documents and how to stop the parsing process once this information is collected. The s
Unified ODBC functions
In addition to normal ODBC support, the Unified ODBC functions in PHP allow you to access several databases that have borrowed the semantics of the ODBC API to implement their own API. Instead of maintaining multiple database drivers that were all nearly identical, these drivers have been unified in
Oracle ADF Data Binding Primer
(Steve Muench) The new Oracle Application Development Framework (ADF) in Oracle JDeveloper 10g evolves our road-tested BC4J framework to a new level of flexibility and openness. By introducing a new “data control” abstraction for back-end business services and generalizing our existing data binding