SQL> desc scott.test
Name Null? Type
----------------------------------------- -------- -------------------------
NAME VARCHAR2(5)
IP_ADDR VARCHAR2(100)
session 1:
SQL> insert into scott.test values('test','127.0.0.1');
1 row created.
session 2:
SQL> select * from scott.test;
no rows selected
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
9 consistent gets
0 physical reads
108 redo size
318 bytes sent via SQL*Net to client
376 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
0 rows processed
Name Null? Type
----------------------------------------- -------- -------------------------
NAME VARCHAR2(5)
IP_ADDR VARCHAR2(100)
session 1:
SQL> insert into scott.test values('test','127.0.0.1');
1 row created.
session 2:
SQL> select * from scott.test;
no rows selected
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
9 consistent gets
0 physical reads
108 redo size
318 bytes sent via SQL*Net to client
376 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
0 rows processed
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7192804/viewspace-346788/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7192804/viewspace-346788/