如何在Oracle中编写FOR UPDATE语句以将值设置为列 [英] How to write FOR UPDATE statement in oracle for setting value to a column

问题描述

以下是我的查询，我需要设置Grade_code的值，类似于名称

  SELECT  PR_GRADE_MASTER.NAME，PR_GRADE_MASTER.GRADE_CODE，PR_GRADE_MASTER.ACTIVE，PR_GRADE_MASTER.PROB_PERIOD，
 PR_GRADE_MASTER.LEVEL_NO，PR_GRADE_MASTER.UNION_MEM，PR_GRADE_MASTER.NOTICE_PERIOD，
 PR_GRADE_MASTER.NOTICE_PERIOD_PROB，PR_GRADE_MASTER.MIN_AGE，PR_GRADE_MASTER.MAX_AGE，PR_GRADE_MASTER.ASC_NOTICE_PERIOD，
                           PR_CATEGORY_MASTER.ID PR_CATEGORY_MASTER_ID，
                           PR_CATEGORY_MASTER.NAME CATEGORY_NAME
                            FROM 
                            (PR_GRADE_MASTER 左  OUTER   JOIN  PR_CATEGORY_MASTER 打开
                            PR_GRADE_MASTER.PR_CATEGORY_MASTER_ID = PR_CATEGORY_MASTER.ID)
                             位置 PR_GRADE_MASTER.ID =  1  > FOR   UPDATE   set  PR_GRADE_MASTER.GRADE_CODE = '  GRADE1'

但是上面的查询给出了错误:missing or invalid option.


PR_GRADE_MASTER已经创建，我刚刚添加了列GRADE_CODE，现在是我在PR_GRADE_MASTER中的上一个记录，我想从Name

解决方案

<中更新GRADE_CODE值blockquote>您好，

由于我不清楚您要从哪个表2更新PR_GRADE_MASTER表的GRADE_CODE中的数据.请替换所需的表名/列名/以下查询中的条件.

 更新 PR_GRADE_MASTER
设置
GRADE_CODE = '   您的第二张表.必需的 '
来自
'   您的第二个Tabl  e '
其中
'   匹配cols条件 ' 

希望对您有帮助.

Below is my query i need to set the value for Grade_code similar as name

SELECT PR_GRADE_MASTER.NAME, PR_GRADE_MASTER.GRADE_CODE, PR_GRADE_MASTER.ACTIVE, PR_GRADE_MASTER.PROB_PERIOD,
 PR_GRADE_MASTER.LEVEL_NO, PR_GRADE_MASTER.UNION_MEM,PR_GRADE_MASTER.NOTICE_PERIOD,
 PR_GRADE_MASTER.NOTICE_PERIOD_PROB,PR_GRADE_MASTER.MIN_AGE,PR_GRADE_MASTER.MAX_AGE,PR_GRADE_MASTER.ASC_NOTICE_PERIOD,
                           PR_CATEGORY_MASTER.ID PR_CATEGORY_MASTER_ID,
                           PR_CATEGORY_MASTER.NAME CATEGORY_NAME
                           FROM
                            (PR_GRADE_MASTER LEFT OUTER JOIN PR_CATEGORY_MASTER ON
                            PR_GRADE_MASTER.PR_CATEGORY_MASTER_ID = PR_CATEGORY_MASTER.ID)
                             WHERE  PR_GRADE_MASTER.ID= 1 FOR UPDATE set             PR_GRADE_MASTER.GRADE_CODE = 'GRADE1'

but the above query is giving error : missing or invalid option.


PR_GRADE_MASTER was already created i just added the column GRADE_CODE , now for my previous record in PR_GRADE_MASTER i want to update the GRADE_CODE value from Name

解决方案

Hi,

Since i am not clear about your 2 table from which you want to update data in GRADE_CODE of PR_GRADE_MASTER table. Kindly replace the required table name / column name / where conditions in below query.

update PR_GRADE_MASTER
set
GRADE_CODE='Your 2nd Table.Required Col'
from
'Your 2nd Table'
where
'Matching cols conditions'

Hope this will help you.

这篇关于如何在Oracle中编写FOR UPDATE语句以将值设置为列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！