Home » SQL & PL/SQL » SQL & PL/SQL » index using PL/SQL
index using PL/SQL [message #273781] Thu, 11 October 2007 12:17 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello All,

I'd like to know how to create an index using a PL/SQL procedure.

I know how to do that in SQL but in Pl/SQL i'm not knowing how to create a index using a PL/SQL procedure. I've searched but could'nt find any.

Regards,

Raj
Re: index using PL/SQL [message #273784 is a reply to message #273781] Thu, 11 October 2007 12:20 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Look at EXECUTE IMMEDIATE.
Re: index using PL/SQL [message #273785 is a reply to message #273781] Thu, 11 October 2007 12:20 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
You should NOT be creating indexes (do any DDL) from PL/SQL.
Re: index using PL/SQL [message #273790 is a reply to message #273785] Thu, 11 October 2007 12:32 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello Sir,

Like first of all let me know can we create indexes using stored procedures i.e., Execute Immediate.

With Execute Immediate , I know that we can create tables, but dont know how to create indexes.

Can you help me .

Regards,

Raj

[mod-edit] illiterate IM speak removed.

[Updated on: Thu, 11 October 2007 12:34] by Moderator

Report message to a moderator

Re: index using PL/SQL [message #273792 is a reply to message #273790] Thu, 11 October 2007 12:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you knwo how to create table with execute immediate and know how to create index without execute immediate then you know how to create index with execute immediate.

Regards
Michel
Re: index using PL/SQL [message #273817 is a reply to message #273792] Thu, 11 October 2007 15:07 Go to previous message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
...and maybe how to create a table without execute immediate too Wink
Previous Topic: How to get complete SQL given the hash_value
Next Topic: how we create index
Goto Forum:
  


Current Time: Thu Dec 08 02:06:26 CST 2016

Total time taken to generate the page: 0.12932 seconds