I have problem in creating index on particular column with pL/SQL procedure . I dont know what command to and how to use?
how to run that PL/sql procedure. And howto check that wether index is created or not?
Please guide meHere's the example:
/* create a procedure */
CREATE OR REPLACE PROCEDURE brisime
AS
ci VARCHAR2 (255);
BEGIN
ci := 'create index i1 on tob_pool_ocit (pool_id, omm_id)';
EXECUTE IMMEDIATE ci;
END;
/* execute the procedure */
BEGIN
brisime ();
END;
/* checking whether it is created */
SELECT *
FROM user_indexes
WHERE index_name = 'I1';
No comments:
Post a Comment