Write protection can be applied to tables. This prevents DDL (Data Definition Language) and DML (Data Manipulation Language) changes during maintenance mode. The statement: ALTER TABLE tablename READ ONLY; -- nur mehr lesbar ALTER TABLE tablename READ WRITE; -- Read and write possible Werbung / Advertisements VIEWs can be equipped […]
Daily archives: 31. March 2019
4 posts
The SQL Developer sets implicit automatic COMMITs. This COMMIT is subconsciously and automatically canceled in the following situations. Werbung / Advertisements (1) SQL Developer quits normally, with no COMMIT or ROLLBACK statement. In this case, a COMMIT is sent before the program is terminated. However, this does not happen in […]
In principle, Snippet and Code Template serve the same purpose: Previously created code is inserted at the desired location. The only difference between the two tools is the paste option. Snippets require the Snippets window first. This can be dragged to any location in the SQL Developer. In addition, the […]
Accidentally, important data was deleted. Of course not in a test system but during operation. The pulse and blood pressure rises. But do not worry – it is not always necessary to back up a backup. At least not if the error is noticed early. Crucial for this is the […]
