471,108 Members | 1,263 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,108 software developers and data experts.

Some basic SQL Questions

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.
Jul 19 '05 #1
0 1251

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Steven O. | last post: by
12 posts views Thread by Vibhajha | last post: by
193 posts views Thread by Michael B. | last post: by
1 post views Thread by danilo of TUP | last post: by
3 posts views Thread by aziz001DETESTSPAM | last post: by
2 posts views Thread by Water Cooler v2 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.