Tip Bank

Question: [Joe Celko’s Employment Agency Puzzle]You are running an employment agency that has requests for jobs and applications from candidates. Both of these forms include a list of the skills

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

Question: Can an OPO application act as an OLE client and use OLE automation with an OLE server? Answer: OPO Version 2.0 can act as an OLE server, but not

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