精华内容
下载资源
问答
  • Error: PL/SQL: ORA-01733: virtual column not allowed here Line: 81 Text: MERGE INTO SvcOrderProfit Error: PL/SQL: SQL Statement ignored Line: 81 Text: MERGE INTO SvcOrderProfit 用merge ...
    Error: PL/SQL: ORA-01733: virtual column not allowed here
    
    Line: 81
    Text: MERGE INTO SvcOrderProfit


    Error: PL/SQL: SQL Statement ignored
    Line: 81

    Text: MERGE INTO SvcOrderProfit


    用merge into 的时候提示

    REF  :http://www.cnblogs.com/dongsheng/p/4384754.html


    问题代码:

     WHEN MATCHED THEN
        UPDATE
           SET IncomeRMB                    = pos_2,
               CostRMB                      = pos_3;/*,
               v_dIncomeUSDFee              = pos_4,
               v_dIncomeUSDAccount          = pos_5,
               v_dlCostUSDFee               = pos_6,
               v_dlCostUSDAccount           = pos_7,
               v_dIncomeRMBSales            = pos_8,
               v_dCostRMBSales              = pos_9,


    ROOT CAUSE 本来左边应该是表名,从SQL 转过来的时候却弄成了变量。所以报错 

    solution  :


    表字段的保留, 非表字段的SELECT INTO 到变量里面:

          SELECT NVL((SELECT SUM(SvcOrderFee.NoTaxFeeAmount)
                                  FROM SvcOrderFee
                                 WHERE SvcOrderFee.CurrencyType = 0
                                   AND SvcOrderFee.CreditDebitType = 0
                                   AND (SvcOrderFee.AccountType = 2 OR
                                       SvcOrderFee.AccountType = 3)
                                   AND SvcOrderFee.OrderBillID = v_lOrderBillID),
                                0)

    INTO         v_dCostRMBSales  
                       FROM DUAL;




    展开全文
  • ORA-01733: virtual column not allowed here

    千次阅读 2015-03-17 16:43:35
    ORA-01733: virtual column not allowed here 更新视图1: SQL> update scott.tt set A=2; update scott.tt set A=2  * ERROR at line 1: ORA-01732: data manipulation operation not legal ...
     基表: hr.tt  scott.tt
    
     视图1: 基于 hr.tt  union all  scott.tt ---》 scott.ttt
     视图2: 基于 视图1-》scott.ttt 创建 system.tt


    问题再现:
    SQL> create table hr.tt (a number);
    Table created.
    SQL>  create table lixora.tt (a number);
    Table created.

    SQL> create view  scott.tt as select * from  hr.tt union all select * from lixora.tt;
    View created.


    SQL> create view system.tt as select * from scott.tt;
    View created.

    SQL> select * from system.tt
             A
    ----------
             1

    更新视图2:
    SQL> update  system.tt set a=2;
    update  system.tt set a=2
                          *
    ERROR at line 1:
    ORA-01733: virtual column not allowed here



    更新视图1:
    SQL> update  scott.tt set A=2;
    update  scott.tt set A=2
                  *
    ERROR at line 1:
    ORA-01732: data manipulation operation not legal on this view


    SQL> !oerr ora 1732
    ORA-01733: virtual column not allowed here 
    Cause: An attempt was made to use an INSERT, UPDATE, or DELETE statement on an expression in a view. 
    Action: INSERT, UPDATE, or DELETE data in the base tables, instead of the view.

    总结:

    无法对包含表达式的view 进行dml 操作


    展开全文
  • 解决方案: 当数据以char的形式存在时,应加单引号,则插入数据库就不会出现类似错误

    解决方案:
    当数据以char的形式存在时,应加单引号,则插入数据库就不会出现类似错误

    在这里插入图片描述
    如何知道数据是什么形式:点击查看

    展开全文
  • column not allowed here

    千次阅读 2011-10-25 17:00:22
    ORA-00984: column not allowed here,看了看values里的值,好像没有什么问题。再仔细看发现大部分字段值都是数字,唯独有一个SKIN_NAME字段,这个字段类型是VARCHAR2(200)。不会是这的问题吧,给它加了一个单引号 ...
      
    

    ORA-00984: column not allowed here,看了看values里的值,好像没有什么问题。再仔细看发现大部分字段值都是数字,唯独有一个SKIN_NAME字段,这个字段类型是VARCHAR2(200)。不会是这的问题吧,给它加了一个单引号 ‘ ‘。

    再次执行,好了!原来是没有办法转换了。

    展开全文
  • Oracle ORA-00984: column not allowed here

    万次阅读 2012-09-10 09:20:43
    ORA-00984错误: 列在此处不允许 当数据以char的形式存在时,应加单引号,则插入数据库就不会出现类似错误.
  • 今天在用JPA 做一个简单的数据保存的时候,一直提示 The value specified for generated ‘xxxxx’ column is not allowed 。Error 3105 .这个数据的错误。经过一番检查发现,是因为我的数据表中有个字段是虚拟字段...
  • ** you may not use this file except in compliance with the License. ** You may obtain a copy of the License at ** ** http://www.apache.org/licenses/LICENSE-2.0 ** ** Unless required by applicable law ...
  • How To Use Virtual Column

    2017-08-25 10:59:33
    Oracle Database 11g (11.1) and later versions can store expressions directly in base tables as Virtual columns...
  • 上一篇我介绍和测试了oracle 11g版本引入的虚拟列新特性,本文继续测试分区键基于表的虚拟列: Prior releases of Oracle only allowed a table to be parti...
  • Virtual Column Dynamic Column https://mariadb. com/kb/en/dynamic-columns/ Dynamic Column的限制 1.单个dynamic column最多65535例 2.不管max_allowed_packet是多少,dynamic column最大长度为1GB ...
  •   生成列(generatedco column)的值是根据列定义中包含的表达式计算得出的。 生成列包含下面两种类型: virtual生成列:当从表中读取记录时,将计算该列。 stored生成列:当向表中写人新记录时,将计算该列并将...
  • MySQL Generated Column(衍生列)

    千次阅读 2018-12-12 16:11:02
    ERROR 3105 (HY000): The value specified for generated column 'col2' in table 'test1' is not allowed. mysql> insert into test1 values (1,8); ERROR 3105 (HY000): The value specified for generated column...
  • Create a Virtual Network for Site-to-Site Cross-Premises Connectivity This tutorial walks you through the steps to create a cross-premises virtual network. The type of connection we will create is a ...
  • Wno-dev -Wwrite-strings -Wno-strict-aliasing -Wno-unused-parameter -Woverloaded-virtual" -DMY_MAINTAINER_C_WARNINGS="-Wall -Wextra -Wno-dev -Wunused -Wwrite-strings -Wno-strict-aliasing -...
  • Mysql错误编码和解释表

    万次阅读 2017-09-19 20:58:54
    错误:1072SQLSTATE: () 42000 ER_KEY_COLUMN_DOES_NOT_EXITS 消息:表列中不存在键列’%s’ 错误:1073SQLSTATE: () 42000 ER_BLOB_USED_AS_KEY 消息:BLOB列’%s’不能用于使用表...
  • ALTER TABLE json_test ADD COLUMN user_info JSON DEFAULT NULL; 3 、插入数据 二、JSON字段相关查询 1 、查询全部结果 2 :JSON_EXTRACT 查询 JSON_EXTRACT这个函数主要用作精确匹配,如查找user_info中...
  • 数据的population表示把新数据放入IM Column Store, repopulation则表示对已存在数据进行更改,因为IMCU及IMEU均为只读结构所以所谓更新即为重建 population与repopulation的过程其实是有区别的,前者会从磁盘及...
  • 3.5. Window Functions

    2020-01-08 17:57:48
    The fourth column represents an average taken across all the table rows that have the same depname value as the current row. (This actually is the same function as the non-window avg aggregate, but...
  • mysql使用虚拟列需要考虑的一个问题

    千次阅读 2018-07-12 11:04:50
    mysql5.7版本的虚拟列功能在很多场景下都能使用,但是需要注意一点,在后续维护的时候,如果包含虚拟列的表在添加字段,做... is not allowed. 可见在使用这个功能的时候需要考虑到这一点,否则线上变更影响比较大。
  • 一些常见的SQL报错

    万次阅读 2014-12-18 15:21:48
    This section lists messages generated when SQL statements are parsed by the Oracle Server. Most, but not all, messages in this section indicate incorrect SQL syntax. For more information about SQL syn
  • ORA-01733: 此处不允许虚拟列

    万次阅读 2017-03-15 18:57:07
    原因分析:一般对视图的更新,只能对简单视图进程更新,而不能对多表关联形成的视图进程更新。 对视图的更新,最终要反映到对表的字段的更新上。 Update 视图时,如果视图有分组函数、GROUP BY 子句、DISTINCT ...
  • DB2的SQLSTATE值

    万次阅读 2014-06-27 10:57:29
    The null value has been assigned to a host variable, because the non-null value of the column is not within the range of the host variable. +304 01517 A character that cannot be ...
  • DB2-SQLCODE 错误码大全---[IBM官方]

    万次阅读 2017-04-11 16:00:28
    SQL error codes ### SQLCODE Description ### -007 statement contains the illegal character invalid-character ### ... the string constant beginning string is not terminated ### -011
  • AnalyticDB错误码文档

    千次阅读 2016-10-21 09:44:13
    MULTIVALUE/TIME/DATE is not allowed for partition column data type. 多值列、TIME、DATE类型的列不能作为分区列,请修改。 18049 CREATE_18049_REALTIME_SUB_PART_COLUMN_NOT_PRIMARY Subpartition ...
  • For example, if the application is allowed to write to a certain registry location by the operating system, even if the plug-in can’t break out of the Win32 limits it can still trash our game’s ...
  • Hadoop常见问题处理技巧汇总

    千次阅读 2018-01-08 18:51:55
    18、Log aggregation has not completed or is not enabled. 解决方法:在yarn-site.xml中增加相应配置,以支持日志聚合 19、failed to launch org.apache.spark.deploy.history.History Server full log in ...
  • 7.2.1. The FROM Clause

    2021-01-01 20:44:13
    The result of the FROM list is an intermediate virtual table that can then be subject to transformations by the WHERE, GROUP BY, and HAVING clauses and is finally the result of the overall ...

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 2,198
精华内容 879
关键字:

allowedcolumnnotvirtual