Home » SQL & PL/SQL » SQL & PL/SQL » Need syntax for indexes
icon4.gif  Need syntax for indexes [message #263714] Thu, 30 August 2007 19:18 Go to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
Hi Forum

I have some indexes in my database & I want to see the sql statement for those( with which they were created). Can anyone please guide me on this.

Thanks a lot in advance.
Re: Need syntax for indexes [message #263717 is a reply to message #263714] Thu, 30 August 2007 19:46 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
DBMS_METADATA.GET_DDL
or
exp help=yes
will give you options on how to obtain DDL; if you are willing to RTFM or use GOOGLE yourself.
Previous Topic: Query Required
Next Topic: create user
Goto Forum:
  


Current Time: Tue Feb 11 16:49:24 CST 2025