insert into是向表中插入数据;
Oralce中还没有 像select into :a from b 这样的建表方法,SELECT A INTO VAL 是给VAL赋值;
如果要查询建表,用CREATE TABLE AS SELECT * FROM TABNAMEselect * into a from b 是SQL SERVER中的方法
Oralce中还没有 像select into :a from b 这样的建表方法,SELECT A INTO VAL 是给VAL赋值;
如果要查询建表,用CREATE TABLE AS SELECT * FROM TABNAMEselect * into a from b 是SQL SERVER中的方法
select a into v_a from table 是PL/SQL语法。v_a是定义的变量,如:
declare
v_a varhcar2(10);
begin
select a into v_a from tabl;
dbms_output.put_line(v_a);
end;
/