Tip Bank

Question: How do I arrange to sort within a GROUP BY clauserather than over the complete result set, e.g. L0 PDV …… L90 PDV …… L180 PDV …… L270 PDV

Question: [Joe Celko’s Equal Sets Puzzle]Set theory has two symbols for subsets. One is a “horseshoe” on its side, which means that set A is contained within set B and

Question: I’ve heard several of the arguments in favor of a server that supports datareplication. What are the potential problems? Answer: For our readers, the advantages of data replication [creating

Question: What is the syntax to get a series of “counts” on a table? An exampleof what I am trying to do is as follows:SELECT col1 = COUNT(tstfield1=’X’),col2 = COUNT(tstfield2=’Y’)

Question: I am using custom toolbars in my application. When I call the QBF form, ithas a default menu bar. How can I get rid of this? Answer: While the

Question: How can I set the flushing of rows to the database or the locking strategy used by Power Objects? Answer: Oracle Power Objects ‘supports’ two ways that rows can

Question: How can I use SQL to specify a query like the example below: select * from mytable where column like ‘a[bc]’This should match both “ab” and “ac” but not

Question: I want to periodically check to see if a user’s database connection has been lost. How can I? Answer: First of all, a solution. You can implement periodic ‘polling’

Question: I have two related tables. I need to go and update atable searching for a value I find in the second table (byjoining both tables). I wrote the following