Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation. I once was pulled into a discussion about the ...
You'll have to use dynamic SQL and the EXECUTE IMMEDIATE command to create the index in the procedure. Such a stored procedure may look like the following: CREATE PROCEDURE my_pro AS stmt VARCHAR2(200 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results