16:31:56 SQL> create table "1" (aa number);表已创建。实际:4376
16:32:10 SQL> insert into "1" values(1);已创建 1 行。
16:32:32 SQL> select * from "1"; AA
---------
1实际:230
16:32:38 SQL>
16:32:10 SQL> insert into "1" values(1);已创建 1 行。
16:32:32 SQL> select * from "1"; AA
---------
1实际:230
16:32:38 SQL>
a varchar2(10);
str varchar2(50);
begin
a:='1';
str:='create view "'||a||'" as select * from info';
execute immediate str;
end;
/SQL> select * from "1";EMPLOYEENO EMPLOYEEPD
---------- ----------
0212 123456
0213 123456
0221 123456
0214 123456
0211 123456
mysql="create view " & '"'& view_name & '"'
或者
mysql="create view " & """" & view_name & """"