Software QA (13)
SQL Server (1)
How To Turn On or Off Recycle Bin for the Session
How To Turn On or Off Recycle Bin for the Session? - Oracle DBA FAQ - Managing Oracle Database Tables
If you want to control the recycle bin feature in your own session, you can use the ALTER SESSION statement to turn on or off. Here is an example SQL script:
SQL> connect HR/fyicenter Connected. SQL> SELECT COUNT(*) FROM recyclebin; COUNT(*) ---------- 0 SQL> ALTER SESSION SET recyclebin = off; Session altered. SQL> CREATE TABLE emp_dept_90 2 AS SELECT * FROM employees WHERE department_id=90; Table created. SQL> DROP TABLE emp_dept_90; Table dropped. SQL> SELECT COUNT(*) FROM recyclebin; COUNT(*) ---------- 0
Warning: Turning off the recycle bin feature in your session will give yourself hard times on recovering dropped tables.
2007-05-04, 5069👍, 0💬
. How can a servlet refresh automatically if some new data has entered the database? You can use a c...
If XML does not have closing tag will it work? No, every tag in XML which is opened should have a cl...
Why does malloc(0) return valid memory address? What's the use? malloc(0) does not return a non-NULL...
In which event are the controls fully loaded ? Page_load event guarantees that all controls are full...
What is the value of this expression? +1-2*3/4 -0.5