Question: What are the pros and cons of creating extended stored procedures? Answer: The pros are that you can implement additional functionality and access data from DLLs from within SQL

Question: From a database-efficiency standpoint, which is better for SQL when inserting new rows into a table: issuing ad hoc SQL statements in the form of “Insert Into…” or using

Question: I have a memo field in a table, which has been scattered to memvar. I need to append a standard statement to the field once the user has completed

Question: How do I print out all of the tables, the fields the tables contain, and the datatype of the fields in my accounting database (for report creation)? I am

A class’s size can change simply by playing with the order of its members’ declaration. For example: struct A{ bool a; int b; bool c;}; // sizeof (A) == 12

A class’s size can change simply by playing with the order of its members’ declaration. For example: struct A{ bool a; int b; bool c;}; // sizeof (A) == 12

Question: We’ve developed a TV scheduling program in HTML, but we have problems with speed (connectivity as well as display refresh) and the inherent functional limitations of HTML. We need

Question: I am trying to populate a drop-down listbox with the data from a table within my database and a blank line. The code I am using is as follows:

This code will generate code to do a column-by-column comparison against a table, assuming that you are joining the inserted table (aliased as “i”) with the deleted table (aliased as

If you need a garbage collector, you can either install one or implement it by yourself. Which type of garbage collection should you use? A conservative garbage collector and a

Applications that are free from memory leaks but perform dynamic memory allocation and deallocation frequently tend to show gradual performance degradation if they are kept running for long periods. Finally,

Templates can have default type parameters. The compiler uses these default types when you don’t provide them explicitly in a template instantiation. For example: template < class T1=char, class T2=char

Hardcoded literal strings can become a serious maintenance problem. Suppose you have numerous message boxes in your application that display a hardcoded text message and you want to change that

Question: I have written an applet which uses a Graphics object to draw movingcircles. However, when multiple threads accesses the same Graphics object,the circles disappear after being on screen for

Question: I have been looking everywhere for information on HashMaps,particularly how to put one hash map into another HashMap. Answer: This is where the expression RTFM (Read That Fine Manual)

Question: Only Objects can be popped from, or push onto, a stack. That means Ihave to wrap a primitive data type, such as int, with something akin toInteger before pushing

Question: How do I determine if a Unix process has stopped writing to a file,so that my Java program can start reading it? Answer: If you are not able to

Question: I’m building an application that has several different frames. Eachhas a button that when pressed should bring up a new frame and closethe calling frame. How can I display

Question: I need to extend class A which resides in a different package, butclass A has only one constructor which is package protected. I get a compile error in class

Question: How do I write a Java program that generates random numbers withinlimits, such as 1 to 100, or 1 to 1000? Answer: The java.util package includes a Random class

Question: How do you stop a Thread without using the stop() method? Answer: The recommended method for stopping threads in Java is for each thread topoll a boolean value or

Question: Is there a significant speed advantage to using Hashtables over Vectors? Answer: The answer depends on how you are using those containers classes. Ifyou are only using them for

Question: Is it possible to have a trigger invoke code in a running application (either via a register-notify type of thing or by calling entry points of a DLL or…)?

Question: How do I set a default for a date field having sysdate, current_date or date as the value? Answer: To use the current date as a default value in

When you are inserting data into Oracle tables in SQL*Plus using hard-coded string, some of the character fields may contain the ampersand character (&). The following is an example: insert

Although an index is not mandatory on your foreign keys, if they are not indexed you will cause additional locking when certain Data Manipulation Language statements are executed against the

Many programmers create stored procedures out of large bodies of database trigger codes. This has primarily been because while stored procedures are stored in compiled form, database triggers are compiled

In a PL/SQL block, if you are querying a database table, you need to declare data variables to hold column values returned from the query. The variables can be declared