ORACLE queries one data table and then inserts two of the other tables by traversing

ORACLE queries one data table and then inserts two of the other tables by traversing

Grammar

The first type:
By using the Oracle statement block

-- Specifies that all departments of the document can view DECLARE cursor table_dept  is< /span> Select Id,uname from  g_users where  Utype=2  and Status>-1  ; Begin  for  C in   Table_dept loop INSERT into G_knowdocright (Rid,dirid,docid,userid) VALUES (Sys_guid (),  "  permission number  "  ,  "  document number  "          ,c.id);      End Loop;      Commit End 

The second:
Implemented using pure SQL statements

Select s_tag_tagid.nextval,widgetid,'15895829126','Nanjing  ' from

ORACLE queries one data table and then inserts two of the other tables by traversing