Oracle SQL语法 [英] Oracle SQL syntax

问题描述

这是我的表结构.在尝试使不同的东西起作用时，我遇到很多问题.

This is my table structure . I have many problems in trying to make different things work .

1. 如何在星期一= 62的任务中输入值?

1. How do I enter the values into task where Monday = 62 ?

INSERT INTO it_time_track (task,percentage)
VALUES ('Support',null) where Monday=62; commit ;

这给我一个错误

-通过将其设置为Oracle Apex上的交互式网格并进行选择以显示该表，对其进行了修复，然后我继续对其进行手动编辑.

-- I fixed it by making it an interactive Grid on Oracle Apex and doing a select to display this table and then I went on to edit it manually .

推荐答案

UPDATE it_time_track 
SET Monday = (SELECT SUM(Monday)  
                  FROM it_time_track 
                  ) 
WHERE Id = 7

这篇关于Oracle SQL语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！