Werbung / Advertisements 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 VIEWs can be equipped […]
Daily archives: 31. March 2019
5 posts
Werbung / Advertisements The SQL Developer sets implicit automatic COMMITs. This COMMIT is subconsciously and automatically canceled in the following situations. (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 […]
Werbung / Advertisements 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. […]
Werbung / Advertisements 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 […]
Werbung / Advertisements The Mi Band Master is compatible with all Mi Bands including Mi Band 2, Mi Band 3 as well as the new Mi Band 4. The Mi Band 3 is actual really cheap, while the Mi Band 4 with a color display is the perfect present (for […]