Hi,
I have a stage Oracle witch create a table in replace mode. I want to create 2 index on this table after it was created.
I succeed in create one index in Close command but no more.
Is it possible to do that.
Remark : I don't want to write the Create table SQL statement, just index statements.
thanks,
Martin.
Close command in OCI Oracle
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you want to do this many times or just once?
If many times, why not assemble the CREATE INDEX statements into a stored procedure and execute that?
Otherwise, how have you attempted to execute multiple statements? Have you tried terminating the first one with a double semi-colon (";;")?
If many times, why not assemble the CREATE INDEX statements into a stored procedure and execute that?
Otherwise, how have you attempted to execute multiple statements? Have you tried terminating the first one with a double semi-colon (";;")?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.