In MySQL, there's a limit on how big SQL queries can be.  This limit
can be determined with the following query:
SHOW VARIABLES LIKE 'max_allowed_packet';
Is there a similar limit for PostgreSQL or any other DBMSs?

I was wondering if anyone has heard of or has used a tool that will
allow me to point to a database and listen for any changes in any of
the tables.  For example, I have a third party app that points to an
Oracle database.  The application updates columns and inserts new rows

Through referential integrity it is possible for a customer not to have a
sales rep number, but it is not possible for a customer to have an invalid
sales rep number. What does that mean? Give a specific example.
Thank you all.

I've encountered something that seems impossible to do with a SELECT
statement. But maybe it's not impossible, & I just can't figure out
how.
I have a table in which each record describes an object. Each object

I'm a newbie and have a general question about the organisation of data
in RDBMS using primary and foreign keys. Am I right that one
principally could organize data which is spread over several tables
(and connected by primary and foreign keys) in one big table? Splitting

Is there a better way to UNION to SELECTs together that have a
different number of columns other than by adding 0's to them?  eg.
SELECT product_id, product_name, description, price, quantity, etc
FROM products4sale

I need a sql statement wich would return all matching SecID and
SourceID where the quantity are different but the SecID are the same
SecurityID     SourceID     Quantity
-------------  -----------  -----------

Dear mysql-ians,
I am performing a query that takes ages before showing a result. I
suppose it is very time consuming because of the JOIN I perform. My
question therefore is if you have any suggestions to optimize my query?

I'm trying to use the C API to Berkeley Databases, I have the following
code:
int main()
{

I have one procedure in Oracle that receives two in/out parameters,
that are
PL/SQL structures. The parameters are changed by the procedure and the
results must be read from them, that were updated by the procedure.

I wonder what is the best practice to create data needed for report
Target (which is entered from form) versus sales data from
transactional database.
Do I have to create separate table and then load data from two sources

I've tried to construct an algorithm myself in vain for quite some time
now for the following problem. Could anyone help me out?
Given a table R with a primary key consisting of columns { K1, K2, ...,
Kp }, p >= 1, and two arbitrary rows a and b, I want to query all rows

I'm trying to convert a database created with FireBird  into Open
Office-Base. Is there anyone who can help me?
Thanks

Imagine a recipe database application that ships with built-in recipes.
The application allows users to add their own recipes to the database.
How do you manage application updates that include corrections and
additions to the original database?

I was wondering if anyone had any ideas on what I could use to source
the "weather" at a specific city (or lat/long) for the past 5 years.
Ideally this lookup would consist of each day in the past 5+ years,
with a type of weather, sunny, rainy, snowy, etc......