Results 1 to 2 of 2

Thread: PL/sql

  1. #1
    Join Date
    Apr 2004
    Location
    USA
    Posts
    14

    Exclamation Unanswered: PL/sql

    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

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    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'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •