Re: How to grant me permissions to my own tables ?

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: 2000/08/07
Message-ID: <398EBD0E.C4073DD7@edcmail.cr.usgs.gov>#1/1

> In my 15 years of programming and databasing, I had never come across a
> language that doesn't PRESERVE case, but RESPECTS it. I have been doing
> SQL for around 10 years, MS-SQL solidly for 3 years - and now I get a
> chance to work with a real DB, I am finding that programming, database
> development and the like have so far taken less than 20% of my time. The
> other 80% seems to be ironing out quirks in the system, quirks possibly
> preserved through time since version 1.

Quirks in the system, or filling in the gaps in your knowledge?  

> In Oracle (with a table called Fred - note the case).
>
> select * from Fred
>
> it first uppercases the Fred -> FRED
>
> then has the hide to tell me it cannot find FRED.

This only happened because you used quotes around the table name when you created it. When you use the quotes, it preserves the case. For instance, you apparently used:

    CREATE TABLE "Fred" AS ......

If you had used:

    CREATE TABLE Fred AS .....

Then all of the following queries would have worked:

    SELECT * FROM Fred;
    SELECT * FROM FRED;
    SELECT * FROM fReD;

    etc...

I may be wrong about this but I believe that not preserving case, unless explicitly stated by the quotes, is in compliance with the SQL-92 standard.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Mon Aug 07 2000 - 00:00:00 CDT