SQL> create table xyz (id number);
Table created.
SQL> create table t1 as select * from xyz;
Table created.
SQL>BEGIN
FOR i IN (SELECT table_name FROM user_tables WHERE table_name IN ('T1','XYZ'))
LOOP
EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || i.table_name;
END LOOP;
END;
/
SQL> select * from xyz;
no rows selected
SQL> select * from t1;
no rows selected
Table created.
SQL> create table t1 as select * from xyz;
Table created.
SQL>BEGIN
FOR i IN (SELECT table_name FROM user_tables WHERE table_name IN ('T1','XYZ'))
LOOP
EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || i.table_name;
END LOOP;
END;
/
SQL> select * from xyz;
no rows selected
SQL> select * from t1;
no rows selected
1B7F278720
ReplyDeleteTakipçi Satın Al
PK XD Elmas Kodu
Algida ile Kazan Puan Hilesi
Age Of History 3 Hile Kodları
Tiktok Jeton Hilesi
Nedir.info.tr
Google Adres Ekleme
Cami Süpürgesi
Sevgiliyle Oynanacak Oyunlar