Home » SQL & PL/SQL » SQL & PL/SQL » index syntax
index syntax [message #7409] Thu, 12 June 2003 00:37 Go to next message
rajool
Messages: 13
Registered: May 2003
Junior Member
Hi,

Can somebody help me.
i want to create an index for a column.
what will be the syntax for creating index.

Bye,
Re: index syntax [message #7413 is a reply to message #7409] Thu, 12 June 2003 03:18 Go to previous message
Paramjeet Singh
Messages: 2
Registered: May 2003
Junior Member
The syntax for writing an index will be :
CREATE [[UNIQUE&#124NONUNIQUE&#124BITMAP]] INDEX index_name ON table_name(column_name);
Previous Topic: connect by prior, to find parent levels from all levels
Next Topic: ORA-02074
Goto Forum:
  


Current Time: Thu Mar 28 19:07:43 CDT 2024