(1):查询一个数据库中是否存在某个表(两种方式):假设表名为table_nameif exists(select * from sysobjects where name='table_name')drop table table_nameif object_id('table_name') is not nulldrop table t...
准备表和测试数据create table A( id varchar2(10), name varchar2(20));create table B( id varchar2(10), age number);insert into A values (101,'zs');insert into A values (102,'ls');insert into A value...