--- In IBDI@y..., "Claudio Valderrama C." <cvalde@u...> wrote:

> > SQL 92 Intermediate Level. You might also note: Remember to bring
> > Oxygen.
>
> Ah, so it's not mandatory at the entry level of conformance.

Correct.

> And what happens with NULL v/s not NULL? I've seen people

complaining for this.

Ummm, what is the context?

The SQL standard says that, by default, all columns allow nulls,
unless there is a NOT NULL column constraint or equivalent. There is
no specific syntax in SQL92 that you can use to indicate that nulls
are welcome in a particular column ...

I know that some vendors support (or require) syntax whereby you can
explicitly specify that a column can be NULL ... probably as a
consequence of the fact that, way back in history, their default
didn't match SQL standard, and they wanted to support standard but
also support existing customers ...

But perhaps I guessed the wrong question?

Cheers,
db (brownd@...)