This example, tested on Oracle 11, shows how you can define bind variables in SQL*Plus, assign values to them in PL/SQL then display those values afterwards back in SQL*Plus:
SQL> variable bv1 varchar2(3)
SQL> variable bv2 number
2 select 'ABC' into :bv1 from dual;
3 select 123 into :bv2 from dual;
PL/SQL procedure successfully completed.
SQL> print bv1
SQL> print bv2
I wanted to test the effect of RMAN backup compression on an Oracle 126.96.36.199 database running on Windows. I configured the flash recovery area, closed the database and mounted it. Then I did a backup without compression:
C:UsersAJ0294094>rman nocatalog target=andrew/reid
Recovery Manager: Release 188.8.131.52.0 - Production on Fri Mar 11 18:42:42 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
The second new item is the UNDO tablespace. This is a special tablespace that is only used for internal purposes and one that users cannot put any tables or indexes into.
This seemed perfectly reasonable so I wondered what might happen if I tried to do it. In an Oracle 184.108.40.206 database Oracle returned (more...)
I went on my first DBA course in 1997 and the lecturer there explained that readers do not block writers in an Oracle database. I had an issue recently which appeared to contradict this so I have reproduced it below in an Oracle 220.127.116.11 database.
I noticed in OEM that there was some issue in the database. As usual, click on the images to enlarge them and bring them into focus (more...)