例如,下面创建了一个T表 EXECUTE IMMEDIATE 'CREATE TABLE T (NAME VARCHAR2(20))'你上次说写了会报错，你能把你写的过程贴出来么！！
and if the person posting this question used thedbms_statspackage to“collect the stats”thechain_cntwould remain unaltered. If he wants to get rid of thatchain_cnthe will have to run“analyze table XXX delete statistics;”or use theanalyzeto collect the new statistics (and this...
Procedure xxx (P_TNAME VARCHAR2,P_ERROR VARCHAR2)IS a varchar2(1000):='ANALYZE TABLE '||TNAME||' COMPUTE STATISTICS '; BEGIN EXECUTE IMMEDIATE A; P_ERROR :='SUCCESS'; EXCEPTION WHEN OTHERS THEN P_ERROR :=SQLERRM; END; Regards Himanshu Upvote 0 Downvote Not open for further replies...
CREATE SCHEMA retail_data; SET current_schema='retail_data'; DROP TABLE IF EXISTS STORE; CREATE TABLE STORE ( ID INT, STORECODE VARCHAR(10), STORENAME VARCHAR(100), FIRMID INT, FLOOR INT, BRANDID INT, RENTAMOUNT NUMERIC(18,2), RENTAREA NUMERIC(18,2) ) WITH (ORIENTATION = COLUMN, ...
table_write | table_read | session_id | session_start | command_id | optimization_cost | start_query_cost | get_next_cost | extended_cost | plan | statistics | visualization_info | query_detail | query_extinfo ---+---+---+---+---+---+---+---+---+---...