Databases Reference
In-Depth Information
8. Set the auto-trace feature and define a variable for binding:
SET AUTOT TRACE EXP
var aid number;
9.
Query for records in
MY_TEST
where the value for
ID
equals 2, using bind variables:
exec :aid := 2;
SELECT * FROM sh.MY_TEST WHERE ID = :aid;
10. Query for records in
MY_TEST
where the value for
ID
equals 1, using bind variables:
exec :aid := 1;
SELECT * FROM sh.MY_TEST WHERE ID = :aid;
11. Query for records in
MY_TEST
where the value for
ID
equals 2, without
bind variables:
SELECT * FROM sh.MY_TEST WHERE ID = 2;
12. Query for records in
MY_TEST
where the value for
ID
equals 1, without
bind variables:
SELECT * FROM sh.MY_TEST WHERE ID = 1;
13. Stop the auto-trace:
SET AUTOT OFF
14. Connect as
SYSDBA
:
CONNECT / AS SYSDBA
15. Prepare the session for tracing:
ALTER SYSTEM SET TIMED_STATISTICS = TRUE;
ALTER SYSTEM SET MAX_DUMP_FILE_SIZE='100M';
ALTER SESSION SET SQL_TRACE=TRUE;
16. Execute the query in step 9:
var aid number;
exec :aid := 2;
SELECT * FROM sh.MY_TEST WHERE ID = :aid;
17. Execute the query in step 10:
exec :aid := 1;
SELECT * FROM sh.MY_TEST WHERE ID = :aid;
18. Stop tracing:
ALTER SESSION SET SQL_TRACE=FALSE;
