oracle 10g 还原表格,在oracle 10g中取消表格

所以我为我的表创建了这个触发器：

CREATE OR REPLACE

PROCEDURE POPULATE_ACTOR_QUOTES (id_actor char)

AS

CURSOR quote_recs IS

SELECT m.title,

m.year,

r.roleName,

q.quotechar

from quote q,

role r,

rolequote rq,

actor a,

movie m

where rq.quoteID = q.quoteID

AND rq.roleID = r.roleID

AND r.actorID = a.actorID

AND r.movieID = m.movieID

AND a.actorID = id_actor;

BEGIN

FOR row IN quote_recs

LOOP

INSERT INTO table(

SELECT quotes

FROM actor_quotes aq

WHERE aq.actorId = id_actor)

VALUES(

ACTOR_QUOTE_TYPE(row.title, row.year, row.roleName, row.quotechar)

);

end loop;

END POPULATE_ACTOR_QUOTES;

/我现在想通过使用一个类似于QUOTES表的查询来解除任何ACTORID表的QUOTES表，并列出其中的所有四个数据项。

这是原始表格模式

CREATE TABLE ACTOR_QUOTES (

ACTORID CHAR(5),

QUOTES AQ_NT

)

NESTED TABLE QUOTES STORE AS ACTOR_QUOTES_NT

/