摘要： select创建表 oracle: create table table2 as (select * from table1); sqlserver: select * into table2 from table1;递归查询 oracle: connect by select ... from <TableName> where <Conditional-1> start with <Conditional-2> connect by <Conditional-3> sqlserver: cte ;with cte(id, name, pid, 阅读全文