When Oracle receives a SQL statement to execute, it first looks to see ifthe execution plan already exists in its cache. If the statement does existin the cache, the previous
The following code allows you to move a form by clicking anywhere on the formand dragging it: Option Explicit’define module level variables to store the last position of the form,
Counting the number of object instances of a certain class can be necessary in debugging and performance tuning. To do that, declare a static data member as a counter, and
The following will replace all single quotes in a SQL statement [CHR(39)] with anapostrophe [CHR(180)]. This is useful if you are trying to add names to adatabase as parameter values
The standard function template std::numeric_limits (defined in < limits >) returns the implementation-dependent number of digits that a certain type has: #include int main(){std::numeric_limits < float >::digits10; //6 on my
If you work with SQL Server or Oracle you at some point probably will need todetermine your unique connection identifier. For SQL Server, the connectionidentifier is called a Server Process
When granting permissions through roles, it is important to know that rolesare disabled while packages are compiled. For example, consider two schemas: User_A and User_B. Let’s create Role_A: CREATE ROLE
Question: How can I dynamically load a class and call its constructor which has a primitive data type as one of its parameters? Answer: Using reflection to dynamically instantiate a
Question: In a code I’m developing, I am getting a “can’t find project or library” error message when it gets to the following functions: Chr(), Right(), Left(). Aren’t these VB