oracle 不能更新 PL/SQL 点击“edit data”报“ these query results are not updateable”
来源:互联网 发布:linux php ssh2 编辑:程序博客网 时间:2024/06/15 12:58
你可以选择在查询语句的最后加上 for update,就可以打开编辑锁,直接修改数据。
而在默认查询下,点击Edit data,会报错:The query results are not updateable.
SQL代码示例
select * from table_name for update; (table_name为要编辑的表)
- oracle 不能更新 PL/SQL 点击“edit data”报“ these query results are not updateable”
- PL/SQL dev工具 使用for update-->Edit Date 时出错"These query results are not updateable,Include the ROWID to get updateable results."
- these query results are not updateable
- 关于Oracle数据库修改时出现“these query results are not updateable”的问题
- These query results are not updateable.Include the ROWID to get updateable results.
- 关于oracle数据库中直接修改表中数据点击小锁出现"these query results are not updateable"的问题
- 在PL/SQL DEV里面有把锁一样的按钮,点击它会跳出“these query result are not updateable,include the ROWID to get updateab
- 在PL/SQL DEV进行查询后,点开把锁一样的按钮修改,点击它会跳出“these query result are not updateable,
- PL/SQL报错:NLS_LANG is not defined on the client.Character set conversion may cause unexpected results
- System.Data.OleDb.OleDbException: Operation must use an updateable query
- oracle pl sql 更新游标
- SSIS 连接Oracle报错 These components are supplied by Oracle Corporation and are part of the Oracle Versi
- Oracle Data Mining PL/SQL API
- These regular express are not tested.
- pl/sql链接64位oracle数据库报错Could not initialize oci.dll
- PL/SQL报错:Initialization error Oracle client not properly installed
- PL/SQL报错:Initialization error Oracle client not properly installed
- Randomly Sorting Query Results in SQL
- getElementById;getElementsByName;getElementsByTagName获取对象的区别
- JBoss
- NET-SNMP 中snmp做agent的一些笔记
- 统一建模语言UML入门
- Javascript的Boolean类型
- oracle 不能更新 PL/SQL 点击“edit data”报“ these query results are not updateable”
- 项目竞标
- 图片的简单截取与拉伸
- 扩展JavaScript Date format
- Windows Mobile之注册表修改
- PL_SQL 复习笔记
- 电子科技大学的Ubuntu8.10源速度很快
- JavaScript的document和window对象详解
- javascript获取日期