我有以下问题:
UPDATE o
SET o.supervisor = e.supervisor
FROM orders o
INNER JOIN employees e on e.employee_id = e.employee_id
WHERE o.supervisor IS NULL;
当列supervisor中存在空值时,查询应该使用来自表employees的数据来更新表orders。
当我运行这个查询(在DB visualizer上)时,我得到这个错误:ORA-00933: SQL-Befehl wurde nicht korrekt beendet,德语是什么意思
ORA-009
我试图用某种限制来创建查询。
SELECT * FROM ALARMS WHERE OBJECT_ID=0 AND TIMESTAMP<=1525677504171 AND ROWNUM<=51 ORDER BY TIMESTAMP DESC
我使用行,但首先它有一个限制,然后它选择有序的。然而,我需要先订购,然后限制。我在这里发现,应该使用FETCH FIRST 51 ROWS ONLY。不幸的是它不起作用了。
SELECT * FROM ALARMS WHERE OBJECT_ID=0 AND TIMESTAMP<=1525677504171 ORDER BY TIMES
我试图组合多个表来显示数据,但失败了。
下面是我的代码:
`SQL> SELECT CUST_ID, CUST_PHONE, MOVIE_COPY.COPY_NUM, RENTAL.COPY_NUM,BRANCH_NUM,RENTED_DATES,RETURN_DATES
2 FROM RENTAL,CUSTOMER,MOVIE_COPY
3 ON RENTAL.COPY_NUM = MOVIE_COPY.COPY_NUM
4 WHERE CUST_ID=11004
5 ORDER BY COPY_NUM DESC;
我收到"ERROR at line 3
我的查询以错误"ora-00933 sql命令未正确结束“结束。
查询:
create table tmp_cleaner
as (
SELECT dd.bigtriggerid
FROM documentdata dd
inner join ipl_bigtrigger bt on dd.bigtriggerid = bt.triggerid
inner join documentinfo di on dd.bigtriggerid = di.bigtriggerid
where bt.processed = 'T'
and di.status in (1, 2)
查询和相关错误如下:
SQL> insert into test(name) values('Raju') where sadd='Hyd';
insert into test(name) values('Raju') where sadd='Hyd'
*
第1行中的错误:
ORA-00933: SQL命令未正确结束
我有一个脚本来创建数据库链接如下。但是脚本遇到了错误ORA-00933: SQL command not properly ended
CREATE DATABASE LINK "MIG_61_TO_74" CONNECT TO "ABC_DEV" IDENTIFIED BY 'ABC_DEV' USING 'info001:1521/orcl';
SELECT * FROM SMFTABLE WHERE (Upper(SYMBOL) LIKE '%A%' );
上面的查询提供了一个
ORA-00933: SQL命令未正确结束异常
查询由以下代码构建:
buff.append("SELECT * FROM ").append(smftable).append(" WHERE (Upper(" + (String) colNames).append(") LIKE '%").append(secString.toUpperCase()).append("
我有一个错误,指出“ORA-00933: SQL命令没有正确结束”
rs = st.executeQuery("select * from msg_new_to_bde t where t.ACTION = 804 and t.seq > ? order by t.seq desc" + sequenceID);
我想更新oracle中日期字段的第一行表基。
update table1 set dfry = 9, ctxotb = 10000 where pan = '6363' AND
dfry = 2 and rownum<=1 order by txdate;
错误是: ORA-00933: SQL命令未正确结束。
谢谢。
它不停地说: ORA-00933: SQL命令没有正确结束。
请帮助我,或者给我一个解决方案的链接。
UPDATE emprunts
SET etat = 'RE'
FROM emprunts A
JOIN detailsemprunts B
ON A.numero = B.emprunt
WHERE B.rendule is not null;```
你好,我正在尝试这个查询:
DECLARE
v_week NUMBER;
BEGIN
SELECT WEEK FROM WEEKDESTINATION INTO (v_week)
WHERE STARTDATE BETWEEN '02-JAN-2010'AND '09-JAN-2010';
END;
但它抛出以下错误: PL/ SQL : ORA-00933: SQL命令未正确结束
请帮帮忙
创建Oracle序列时出错
CREATE SEQUENCE HR.order_entry_id
AS BIGINT START WITH 1 INCREMENT BY 1;
CREATE SEQUENCE HR.USER_PROFILE_SEQ
AS BIGINT START WITH 1 INCREMENT BY 1
在第1行ORA-00933处出错: SQL命令未正确结束
这个create语句有问题吗?
Select A.CUST_ID, A.CUST_FNAME
From BANK_CUSTOMER A
Where A.CUST_TYPE=’IND’
And A.CUST_ID in (select CUST_ID from BANK_CUST_CONTACT where CONTACT_TYPE =’OFFICE’);
我收到错误了
java.sql.SQLSyntaxErrorException: ORA-00933: SQL命令未正确结束
cursor.execute("select name,marks from student order by marks desc limit 5")
cx_Oracle.DatabaseError: ORA-00933: SQL命令未正确结束
如何解决此错误?还有其他方法可以重述查询吗?这个查询有什么问题?
我可以在没有问题的情况下运行这个闪回查询:
select x from a as of timestamp sysdate;
但是,如果使用表别名,则会得到一个错误。
select foo.x from a foo as of timestamp sysdate;
ORA-00933: SQL command not properly ended
如何在表别名中使用"as of“?
我不知道为什么不能将这些值插入到下表的table.For中:
create table info
(serial_no number(10),
name varchar(10));
insert into info(serial_no,name)
values(1,'g'),(2,'u'); /*For this query an error is coming*/
错误:
ORA-00933: SQL命令未正确结束
我想运行以下查询:
SELECT
*
FROM
TABLE1
WHERE
COL1 = :DynamicValue1
AND COL2 = :DynamicValue2
USING
USERENTEREDVALUE1, USERENTEREDVALUE2;
我不想使用EXECUTE IMMEDIATE。
如何在选择查询中使用using关键字?当我运行它时,我会弹出输入值,但是它会产生错误Ora-00933。
insert into OPT (email, campaign_id) values('mom@cox.net',100)
where not exists( select * from OPT where (email ="mom@cox.net" and campaign_id =100)) ;
错误报告: SQL : ORA-00933: SQL命令未正确结束00933。00000 - "SQL命令未正确结束“*原因:
*行动:
如果Oracle中不存在新行,如何插入它?
我试着执行下一个:
SELECT l.id AS id
FROM s.process AS l
JOIN s.item AS r ON l.id = r.id;
但我得到了:
Query execution failed
Reason:
SQL Error [933] [42000]: ORA-00933: SQL command not properly ended
使用:
DBeaver
ojdbc7.jar作为驱动程序
我正在尝试对select语句进行内部联接,如下所示:
select *
from (select* from bars where rownum <= 10 )as tab1
inner join (select * from bars where rownum <= 10 )as tab2
on tab1.close=tab2.close
我得到了以下错误: ORA-00933 SQL命令没有正确结束任何帮助,谢谢!
我试图更新存储在字段中的数字,这是我使用的代码
Select *
From MEDICATION
UPDATE medication
set seq_number = 2
where pet_id = "PO145"
AND vet_id = "V01"
AND MEDICINE ='Soothing Cream';
错误返回状态
ORA-00933: SQL命令未正确结束