Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to grant me permissions to my own tables ?
In article <398EBD0E.C4073DD7_at_edcmail.cr.usgs.gov>, Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
>> 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.
Gaps in my knowledge are things like PL/SQL and the like. Quirks are illogical things that must be learnt only by error. This is a quirk - no other language uses this philosophy for identifiers.
>
>> 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.
Well I didn't put quotes around it to create it, as a matter of fact I hadn't even used quotes before. The tables were created from an ODBC source.
All I can say is - its illogical to discard case AND respect it in the syntax of any language.
>
> HTH, Brian
>
>
Received on Tue Aug 08 2000 - 00:00:00 CDT