ORA-00913 is an Oracle/PLSQL Error Message. This error is cause when you tried to execute an SQL statement that required two sets of equal values, but you entered more items in the second set than was in the first set.
Questions tagged [ora-00913]
16 questions
8
votes
4 answers
SQLException while trying to insert a double value into Oracle database
I have to develop a small program that inserts some data into an Oracle database. Unfortunately I have some trouble with a SQL Statement and the execution of it. This is the code I am using:
db.execute(
String.format("INSERT INTO tops VALUES…
Patrick Vogt
- 898
- 2
- 14
- 33
5
votes
3 answers
"ORA-00913: too many values" error when I run SQL query
I'm getting a "too many values" error and I'm not sure how to approach it. The problem starts at the first nested SELECT
SELECT p.name, p.phone_number
FROM person p WHERE
(SELECT ks.title, ks.ks_code
FROM required_skills rs JOIN…
Caffeinated
- 11,982
- 40
- 122
- 216
2
votes
1 answer
Oracle error code ORA-00913 - IN CLAUSE limitation with more than 65000 values (Used OR condition for every 1k values)
My application team is trying to fetch 85,000 values from a table using a SELECT query that is being built on the fly by their program.
SELECT * FROM TEST_TABLE
WHERE (
ID IN (00001,00002, ..., 01000)
OR ID IN (01001,01002, ...,…
explorer da
- 97
- 1
- 7
2
votes
2 answers
ORA-00913: too many values
getting ORA-00913: too many values. don't know how to resolve this issue please anyone could help me?
con2 = DriverManager.getConnection("Jdbc:Oracle:thin:@localhost:1521:XE", "system",
"oracle123");
File image=new…
Ganesan S
- 85
- 1
- 3
- 13
1
vote
2 answers
Oracle Trigger error PL/SQL: ORA-00913: too many values
I am trying to create a trigger but is having errors....
SQL> CREATE OR REPLACE TRIGGER INV_TOTAL
2 BEFORE INSERT OR UPDATE ON INVOICE
3 FOR EACH ROW
4 BEGIN
5 SELECT
6 NVL((SELECT R.SUBTOTAL FROM HOLIDAY_RESERVATION R WHERE…
David Garcia
- 3,056
- 18
- 55
- 90
1
vote
2 answers
ORA_00913 in a PRODUCT table (SQL)
I am trying to insert some rows to a PRODUCT table and I get an ORA_00913: too many values
at first and third line, column 13
insert into PRODUCT (prod_id, group_id, prod_name, price)
values ('000004', '0000045666', 'lampaan', 95,15);
insert into…
Σοφία Ιασωνίδου
- 23
- 1
- 3
1
vote
2 answers
Using IN operator in Subquery with Group By
I'm having some trouble with a query. I'm supposed to pull up all the client info where the client has only taken 1 test and passed. I was told to use the IN operator. This is what I have:
SELECT *
FROM Client
WHERE ClientName IN (SELECT…
Cyrallia
- 37
- 2
- 5
1
vote
2 answers
SQL, Too many values, Result consolidation
I have a problem with an SQL query, in fact when i try to execute this i have this response :
what i want to do is to calculate the sum and the count
Can you help me please ? thank you a lot
ORA-00913: too many values
00913. 00000 - "too many…
user2008204
- 11
- 2
0
votes
0 answers
I got few errors in this following query . the errors are says too many values and how do I create tables for those?
INSERT INTO PERSON VALUES(158,'Bouquet','John','M','31/8/2021','11 Vaude Avenue','Armidale',2350,154);
INSERT INTO PERSON VALUES(159,'Bouquet','Maria','F','31/8/2021','11 Vaude Avenue','Armidale',2350,154);
SELECT
p1.first_name||'…
Saiteja Varma
- 1
- 1
0
votes
2 answers
ORA-00913: too many values error when I run a query in SQL*Plus
I am trying to get the dname, loc, and count the ename's, plus I want to include the sal from the table. Can someone tell me what I am doing wrong.
Heres my statement with the error I get
SQL> select dname, loc, (select count(ename), sal from emp…
user770022
- 2,899
- 19
- 52
- 79
0
votes
1 answer
Oracle sql worksheet
I'm trying to compare 2 columns and the goal is the return of the lines that don't match. For example I have in column 1 and 2 the following
1 2
id name age job id name age job
1 aaa 11 bbb 1 aaa 11 bbb
2…
0
votes
1 answer
Delete logic for duplicate data is throwing ORA-00913: too many values
I am trying to perform delete on a table containing Duplicate values using the SQL logic below but oracle is throwing ORA-00913: too many values error when executed.
DELETE
FROM
UT_USER
WHERE
ROWID NOT IN
(
SELECT
MAX(ROWID),
…
karthik
- 185
- 3
- 13
0
votes
1 answer
PL/SQL: ORA-00913: too many values
i am trying to create a sql function that prints the reservations made by a customer when his name is beeing given. The customers names are in a table called CLIENTS.FNAME CLIENTS.MNAME CLIENTS.LNAME and the reservations searched by an id- foreign…
Ivan M
- 209
- 1
- 2
- 9
0
votes
0 answers
ORA-00913: too many values Error (Even though I have checked my table and entries)
Here's is the table :
create table Student(
student_id char(6) primary key,
name varchar(10) not null,
department char(20),
grade char(6),
percentage smallint,
contact_no char(12),
address varchar(50)
);
This is what…
Shubham Kumar
- 53
- 1
- 1
- 8
0
votes
1 answer
ORA-00913: too many values insert wm_concat string into table
When I use wm_concat to concatenate several tuples into one tuple.
For example
ID Items
1 'apple'
2 'peach'
2 'banana'
declare
v_name_l: varchar(100);
v_name_b: varchar(100);
begin
select…
user1831190
- 87
- 5