devxlogo

Tip Bank

Predicate Pushing

Oracle supports the pushing of predicates into a given view. Suppose you have a set of layered views: –View OneCREATE VIEW vw_layer_oneAS SELECT * FROM emp;– View TwoCREATE VIEW vw_layer_two_dept_100AS

Organizing and Loading Common/Specific Properties

Oftentimes, you’ll need to use common properties across projects, while being able to override or load new properties that are project specific. Java’s Properties class allows for flexibility when organizing

Using Namespace Aliases in .NET

In most cases, when there are namespace conflicts, developers tend to use the complete qualified name in the code. For example: using System.Web.UI.WebControls;using MyComponent.Web.UI.WebControls; This is usually okay for simple

Improved Pinging in .NET 2.0

Using the Send method of the Ping class (in System.Net.NetworkInformation namespace) takes the hostname as a parameter. This captures the reply in the PingReply object, as shown below: //CodePing ping