Re: Index SQL source?

From: Mike Moore <hicamel_at_mail.home.com>
Date: Sat, 07 Apr 2001 02:52:04 GMT
Message-ID: <ohvz6.8515$4L4.918268_at_news1.frmt1.sfba.home.com>


I don't think so. I came from a database system where you could say things like
"display record order as syntax."
The result would be the exact command that you used to create the record. I was very surprised to find that there is nothing like this in Oracle.

Mike

gkigk <gk-igk_at_ka.tel.hr> wrote in message news:9ac8ac$a101$1_at_as121.tel.hr...
> Beside looking at "v$indexfiles", to see what some indexes do,
> can I maybe see the source code (SQL - create index name1 on table name2
> ...) ?
>
> Thanks
>
>
Received on Sat Apr 07 2001 - 04:52:04 CEST

Original text of this message