PL/sql

sam70 · #1 (**permalink**) 04-19-04, 22:32

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 me

Littlefoot · #2 (**permalink**) 04-20-04, 03:21

Here's the example:

PHP Code:


			
/* 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';

Internet Services

Web Development

Digital Marketing

Consumer Tech