RE: Index question

From: Mohan, Ross <Ross.Mohan_at_PictureVision.com>
Date: Tue, 10 Oct 2000 14:58:57 -0400
Message-Id: <10645.118896@fatcity.com>

Did you check the current list of oracle KEY/RESERVED words?

I mean, you can name a table "TaBlE" if you want.

You can even name it "TABLE", if you protect the keyword with quotes.....

methinks.....

-----Original Message-----
From: Shaw, John B [mailto:jbshaw_at_ingr.com] Sent: Tuesday, October 10, 2000 3:20 PM
To: Multiple recipients of list ORACLE-L Subject: Index question

I ran sql analyze and it came back with a recommended index CREATE INDEX MAIN_ID

     ON MAIN
        (MAIN_ID,
         "LAST",
         FIRST)

    LOGGING
    INITRANS 2
    MAXTRANS 255
    TABLESPACE INDX
    PCTFREE 0
    STORAGE (

        INITIAL 128K
        NEXT 128K
        PCTINCREASE 0
        MINEXTENTS 1
        MAXEXTENTS 1024);

Why is the second column in quotes "LAST" - what does this do?

.... . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw
Intergraph Public Safety
mailstop LR24A4
jbshaw_at_ingr.com
256-730-8038
All the usual disclaimers and some of the certifications
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Shaw, John B
  INET: jbshaw_at_ingr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 10 2000 - 13:58:57 CDT