Some basic SQL Questions

[Steven O.]

First, this may not be the correct newsgroup. I have some relatively
basic questions on SQL. I tried to find a newsgroup that was
specifically just about SQL, and was surprised to find that all the
SQL-related newsgroups seem to be product related. But if I missed
something, and someone can steer me to a correct newsgroup, please do
so.

My specific questions:

1. I want to put comments in an SQL script. For example, I want
something like

CREATE TABLE myTable
(field1 CHAR(10), /* References the field1 table */
field2 DECIMAL(3,2) /* References field2 table */
);

Here, I've used C-style comments, but I don't think that works with
SQL. Is there any other syntax for sticking comments in a script?

2. I am writing my script based on some texts from an Oracle class I
took a year ago. But an online .pdf tutorial I found lists some data
types that are not in my text:
varchar2(n)
number(o,d)
Are these valid!?

3. Is there any kind of "memo" field in SQL? My database references
some text that may be arbitrary in length (like ingredients for a
recipe), and a way to link to memo fields would be helpful. Or, is
that the purpose of the varchar2 data type?

Thanks in advance for all replies.

Steve O.
Standard Antiflame Disclaimer: Please don't flame me. I may actually *be* an idiot, but even idiots have feelings.