限制此視圖只能select,不能進行DML(update,delete,insert)操作,可以保護源表的數據不被改動。 CREATEVIEWXXXXX_VASselectXXX,XXX1,XX2FromawherexxxWITH READ ONLY
Oracle 的 create view 语句可以带有 WITH READ ONLY 选项。为了使 Oracle 的 sql 代码更方便迁移到 LightDB 中,24.1 版本中新增了 WITH READ ONLY 语法。目前用户不能在只读视图上执行 update/insert 操作更新基表,但可以在只读视图上执行 delete 从基表删除数据。 用例 CREATETABLEemployees( last_namevarchar(1...
简单的来说，一般的oracle会给这个操作加个锁，其余的用户在这个期间无法操作这个表。等你的操作结束后，这个锁自动消失。WITH READ ONLY：只是查看，不做做更新。速度上会加快，不需要加锁。
据说是：通知ORALCE，只是查看，不做做更新，速度上会加快
ORDER BY a.area_name WITH READ ONLY; 经过几次测试发现只要ORDER BY 和WITH READ ONLY同时出现就会报这个错。 后来在网上搜索了相关的信息,说是只需调整一下SQL的写法即可。如下: CREATE OR REPLACE VIEW AREA_TOWN AS SELECT area_name,cuid FROM (SELECT a.area_name,a.cuid ...
2.1.1. Connecting to an Oracle Database You can create a connection to a database using theData Source Explorer view, as follows: To open the Database Development perspective, clickWindows > Open Perspective > Otherfrom the Main menu, and then selectDatabase Developmentfrom theOpen Perspective...
Philippe Marschall opened SPR-15210 and commented Previously (with the 9i and 10g) Oracle JDBC driver read only Spring transactions resulted in read only Oracle transactions. With the 12c Oracle JDBC driver this is no longer the case (I'...
Linux OS - Version Oracle Linux 6.7 with Unbreakable Enterprise Kernel [4.1.12] and later: Oracle Linux: lvextend Fails With Error "Read-only locking type set. Write
Oracle Fail Safe did not allocate enough space for theopen_modecolumn which resulted in theORA-1406error. This problem has been corrected. The space allocated for fetching the open mode is increased to accommodate theREAD ONLY WITH APPLYstring. In addition, Fail Safe now properly starts and poll...
Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party....