Execute ".SQL" file with PL/SQL
hi all,
i need to complete following task, is there any way to complete this task,
---
DECLARE
v_index_name VARCHAR2(40);
BEGIN
SELECT INDEX_NAME
INTO v_index_name
FROM USER_IND_COLUMNS
WHERE TABLE_NAME='MY_TABLE'
AND COLUMN_NAME ='MY_COL1';
EXCEPTION
WHEN NO_DATA_FOUND THEN
@C:\Work\Oracle\create_index.sql;
END;
/
---
Thanks
Tharindu Dhaneenja