Tip Bank

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: 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 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: 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

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…)?

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