oracle ±íÖвåÈë¶àÐÐ

·½·¨Ò»£º
SQL>create table aa(a number);
´´½¨³É¹¦¡£
SQL> select * from aa;
A
--------
2
SQL>
SQL> insert all
2 into aa values(1)
3 into aa values(2)
4 select * from dual;
ÒÑ´´½¨2ÐС£
SQL> commit;
Ìá½»Íê³É¡£
SQL> select * from aa;
A
----------
2
1
2
·½·¨¶þ£º
SQL>create table a(a number);
´´½¨³É¹¦¡£
SQL>desc a;
Ãû³Æ ÊÇ·ñΪ¿Õ ÀàÐÍ
----------- -------------- ----------
SQL>insert into a values(&a);
ÊäÈëaµÄÖµ£º1 (»Ø³µ)
//Ô­Öµ 1£ºinsert into a values(&a)
//ÐÂÖµ 1£ºinsert into a values(1)
ÒÑ´´½¨1ÐС£
SQL>/
ÊäÈëaµÄÖµ£º1 (»Ø³µ)
Ô­Öµ 1£ºinsert into a values(&a)
ÐÂÖµ 1£ºinsert into a values(2)
ÒÑ´´½¨1ÐС£
SQL>select * from a;
A
--------
1
2