Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DESC in index column

DESC in index column

From: Daud <daud11_at_hotmail.com>
Date: 20 Aug 2002 02:32:25 -0700
Message-ID: <f0bf3cc3.0208200132.61cf0fcb@posting.google.com> 





Hi



If I create an index like below in 8i basically I am creating a
function-based index. What does it do if I execute the command in prev
release of Oracle (7.3.4, 8.0.5 etc.)? Is the DESC just ignored? Sorry
I check since I dont have prev rel of Oracle.



CREATE INDEX MyIndexName ON MyTable (MyCol DESC);



rgds


Daud
Received on Tue Aug 20 2002 - 04:32:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US