CodeSnip: How to Select the Records from a Table Following a Pattern without Using ROWNUM

• CodeSnip: Using Dynamic Cursor in a Procedure Using Oracle 9i In this code snippet, Deepankar examines the usage of dynamic cursors in a procedure where the table name is passed as an input parameter. After listing the SQL code sample, he analyzes it and then provides a screenshot of the final out ...

• Article :: Regular Expressions in Perl?Pattern Matching Learn what they are and how to use t ...

• CodeSnip: Unexpected behavior with C# auto-implemented properties In this code snippet, Joseph examines a scenario of an unexpected behavior which will happen while using C# auto-implemented properties with reflection. After providing a step-by-step description of the scenario, he provides the complete code listing of all the C# files used in the sample project al ...

• External table intermittent errors I'm having a problem with External tables. Most of the time I can read the data in the table without any issue. But when I issue the query below I get an error. <b>Contents of test.csv file</b> <code>Tool type,ID Common,1 Type1,2 Type2,3 ...

• A Decorator Pattern - Delphi OOP Chapter 27 in Delphi OOP :: In this chapter we look at situations where it is not necessary to change the core characteristics of an object at run time, but rather optionall ...

• Select Which Panel Displays AutoHint in Delphi's TStatusBar in Delphi TIPS :: The TStatusBar Delphi control displays a row of panels, usually aligned at the bottom of a form. When AutoHint is true, the status bar automaticall ...

• MySQL Table Manager MySQL engine permits user level locks. The program explains how to manipulate these lock ty ...

• Using the SelectDirectory Delphi routine - to Select a Directory/Folder in Delphi TIPS :: You can display a dialog to the user to allow directory/folder selection without using a TOpenDialog component. First, add FileCtrl unit to the uses clause o ...

• CodeSnip: How to make use of parameterized cursor in Oracle Often it is convenient to pass a given set of values as input parameter to a cursor. It is very useful where nested cursors are used. Parameterizing the cursor makes it more usable and avoids the limitation of hard coding values in where the clause. In this code snippet, Deepankar examines this tech ...

• WPF Command-Pattern Applied Usage of the Command Pattern in a WPF applicat ...