ora-00933 Questions
16
Solved
I have a query which works fine in MySQL, but when I run it on Oracle I get the following error:
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 - "SQL command not properly en...
Antidepressant asked 15/3, 2010 at 11:40
5
Solved
Is there any way to modify an existing check constraint on a table
other than dropping and re-creating it?
create table t ( n number);
ora10g> Tabelle wurde erstellt.
ora10g> alter table t...
3
Solved
I have an issue with using Oracle's union and order by clauses together.
I have two complex queries (with sub queries in them) having an order by clause for each of them. I need to union the outpu...
Appellate asked 18/4, 2014 at 15:0
4
This SQL statement works if I run it from my Oracle client (SQL Developer):
insert into Person (Name) select 'Bob' from dual
It also works if I issue it via Spring JDBC, without using a KeyHolde...
2
Solved
I have Oracle version 12.2.0.1.0
We have generic script which create sequence that need to be reuse for different objects (by renaming sequence name):
CREATE SEQUENCE NAME_SEQ MINVALUE 1 MAXVALUE 9...
Norrisnorrv asked 10/10, 2018 at 1:48
10
Solved
I'm using OLEDB provider for ADO.Net connecting to an Oracle database. In my loop, I am doing an insert:
insert into ps_tl_compleave_tbl values('2626899', 0, TO_DATE('01/01/2002', 'MM/DD/YYYY'), '...
3
Solved
I want to update a table to indicate that some rows are parents of others, so I added a "parentid" column to the table. The following query finds all the parents:
SELECT ca1.id, ca2.id
FROM conta...
Inflight asked 4/3, 2010 at 15:17
3
Solved
The following Oracle statement:
DECLARE ID NUMBER;
BEGIN
UPDATE myusername.terrainMap
SET playerID = :playerID,tileLayout = :tileLayout
WHERE ID = :ID
END;
Gives me the following error:
...
3
I'm trying to create this trigger and getting the following compiler errors:
create or replace
TRIGGER RESTAR_PLAZAS
AFTER INSERT ON PLAN_VUELO
BEGIN
SELECT F.NRO_VUELO, M.CAPACIDAD, M.CAPACIDAD -...
2
Solved
I am using a SQL statement with a Temporary relation, and am getting the error ORA-009933: SQL command not properly ended
I don't see anything wrong with the statement, so any assistance is greatl...
Forspent asked 21/3, 2012 at 19:42
4
I am trying to make an inner join on a select statement like this:
select *
from (select* from bars where rownum <= 10 )as tab1
inner join (select * from bars where rownum <= 10 )as tab2
on ...
3
Solved
I have a sql like this
UPDATE A
SET A.TEMSILCI_KOD = 4
FROM S_MUSTERI A, S_TEKLIF B
WHERE A.TEMSILCI_KOD = 9
AND B.BAYI_KOD = 17
AND A.HESAP_NO = B.HESAP_NO
But i getting an error like this
Err...
Bedelia asked 8/2, 2011 at 15:3
1
Solved
I found a string tokenizer query on the net and packaged it into the below function, which return the dynamic set of tokens. The function compiles successfully but somehow I get the error "ORA-0093...
Coates asked 22/10, 2010 at 20:42
1
I got the following error in Oracle:
SELECT * FROM abcd WHERE name LIKE 'a%' LIMIT 10
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
What is the problem with the command?
1
Solved
I need to update an existing constraint in Oracle database to add a new column there.
ALTER TABLE MY_PARTNER_DETAILS
MODIFY CONSTRAINT UQ_MY_PARTNER_DETAILS
UNIQUE(PARTNER_CODE,PGOOD_CODE,SITE_CO...
Pileous asked 13/11, 2009 at 19:39
1
© 2022 - 2024 — McMap. All rights reserved.