| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index question
It is:
1 select * from v$reserved_words
2* where keyword = 'LAST'
07:42:03 ORINTFD2:killoughm> /
KEYWORD LENGTH ---------------------------------------------------- ---------- LAST 4
Mike
>From: Steven Monaghan <MonaghaS_at_mscdirect.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Index question
>Date: Tue, 10 Oct 2000 12:25:46 -0800
>
>Is LAST a reserved word? If it is, the only way oracle will not be
>confused
>is to wrap it in double quotes.
>
>Steve
>-------------------------------------
>Steven Monaghan
>Oracle DBA
>MSC Industrial Direct Co., Inc.
>Melville, NY
>MonaghaS_at_mscdirect.com
>-------------------------------------
>
> > -----Original Message-----
> > From: Shaw, John B [
> > 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).
> >
>
>
>This e-mail is intended for the use of the addressee(s) only and may
>contain
>privileged, confidential, or proprietary information that is exempt from
>disclosure under law. If you are not the intended recipient, please do not
>read, copy, use or disclose the contents of this communication to others.
>Please notify the sender that you have received this e-mail in error by
>replying to the e-mail. Please then delete the e-mail and destroy any
>copies of it. Thank you.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Steven Monaghan
> INET: MonaghaS_at_mscdirect.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).
 |
 |