Oracle Sql Error 913
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn too many values error in sql query more about Stack Overflow the company Business Learn more about hiring developers or posting
Too Many Values Oracle Subquery
ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack java.sql.sqlexception: ora-00913: too many values Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL Error: ORA-00913: too many values up vote 6 down vote pl sql ora-00913 too many values in bulk collect favorite Two tables are identical in terms of table name, column names, datatype and size. These tables are located in separate databases, but I am use to current Log in in hr user. insert into abc.employees select * from employees where employee_id=100; I can not give use original query from corporate office. Error starting at line 1 in command: insert into abc.employees select * from employees where employee_id=100;
Ora-00913 Too Many Values In Oracle Insert
Error at Command Line:1 Column:25 Error report: SQL Error: ORA-00913: too many values 00913. 00000 - "too many values" *Cause: *Action: sql oracle share|improve this question edited Jan 23 '14 at 10:37 Kent Pawar 79011125 asked Sep 11 '13 at 9:25 user2703444 46123 add a comment| 4 Answers 4 active oldest votes up vote 4 down vote You should specify column names as below. It's good practice and probably solve your problem insert into abc.employees (col1,col2) select col1,col2 from employees where employee_id=100; EDIT: As you said employees has 112 columns (sic!) try to run below select to compare both tables' columns select * from ALL_TAB_COLUMNS ATC1 left join ALL_TAB_COLUMNS ATC2 on ATC1.COLUMN_NAME = ATC1.COLUMN_NAME and ATC1.owner = UPPER('2nd owner') where ATC1.owner = UPPER('abc') and ATC2.COLUMN_NAME is null AND ATC1.TABLE_NAME = 'employees' and than you should upgrade your tables to have the same structure. share|improve this answer edited Sep 11 '13 at 11:14 answered Sep 11 '13 at 9:26 Parado 19.1k73261 Not is possible because original tables in 112 columns and work on large table 800+ so .................. –user2703444 Sep 11 '13 at 9:32 employees table has 112 columns !? –Parado Sep 11 '13 at 9:33 SHOW TO 1
here for a quick overview of the site Help Center Detailed answers to any questions you might oracle too many rows have Meta Discuss the workings and policies of this site About ora-00913 too many values materialized view Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads
Ora-00913 Too Many Values In Case Statement
with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million http://stackoverflow.com/questions/18737369/sql-error-ora-00913-too-many-values programmers, just like you, helping each other. Join them; it only takes a minute: Sign up “ORA-00913: too many values” error when I run SQL query up vote 4 down vote favorite 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 http://stackoverflow.com/questions/8353165/ora-00913-too-many-values-error-when-i-run-sql-query p.name, p.phone_number FROM person p WHERE (SELECT ks.title, ks.ks_code FROM required_skills rs JOIN knowledge_skills ks USING (ks_code) WHERE rs.pos_code = 'CS1') IN (SELECT ks.title, ks.ks_code FROM courses_taken ct JOIN course_learning_units clu USING (c_code) JOIN learning_unit_skills lus USING (lu_code) JOIN knowledge_skills ks USING (ks_code)) I looked up info about this error and I believe it's because the subquery in the WHERE returns too many columns. The table data is below. But how can I whittle that down? I appreciate any pointers, Thanks required_skills POS_CODE VARCHAR2(10 BYTE) Yes 1 KS_CODE VARCHAR2(10 BYTE) Yes 2 learning_unit_skills LU_CODE VARCHAR2(10 BYTE) Yes 1 KS_CODE VARCHAR2(10 BYTE) Yes 2 person PER_ID NUMBER(38,0) No 1 NAME VARCHAR2(255 BYTE) Yes 2 STREET VARCHAR2(255 BYTE) Yes 3 CITY VARCHAR2(60 BYTE) Yes 4 ZIP_CODE VARCHAR2(60 BYTE) Yes 5 PHONE_NUMBER VARCHAR2(255 BYTE) Yes 6 GENDER VARCHAR2(6 BYTE) Yes 7 course learning units C_CODE VARCHAR2(10 BYTE) Yes 1 LU_CODE VARCHAR2(10 BYTE) Yes courses taken C_CODE VARCHAR2(10 BYTE) Yes 1 PER_ID NUMBER(38,0) Yes 2 sql oracle
with a mandatory word, e.g. keyword2 keyword1 +keyword2 Questions excluding a https://developer.ibm.com/answers/questions/183297/why-am-i-getting-a-sqlcode-913-sqlstate57033-error.html word, e.g. keyword2 keyword1 -keyword2 Questions with a specific tag and keyword(s) +[tag1] keyword1 Questions with two or more specific tags and keyword(s) +[tag1] +[tag2] keyword1 To search for all posts by a user or all posts with a specific tag, start typing too many and choose from the suggestion list. Tags Spaces API Connect Appsecdev BPM Blockchain Bluemix CICS Cloud Analytics Cloud marketplace Content Services (ECM) Continuous Testing Courses DB2 LUW DataPower Decision Optimization DevOps Services Digital Experience Hadoop IBM Design IIDR ITOA InformationServer Integration Bus Internet of too many values Things LinuxONE MDM Mainframe Messaging Node.js ODM Open Predictive Analytics PureData for Analytics Push Run Book Automation Storage Streamsdev Swift UrbanCode WASdev WSRR Watson dW Answers Help dW Premium developerWorks Team Watson Health More Users Badges Ask a question Why am I getting a SQLCODE=-913, SQLSTATE=57033 error-message when executing a WebSphere batch-job? Question by Ayron Fears ( 1839) | Mar 31, 2015 at 07:22 AM waswebsphere application serverwebspherewebsphere batch I am getting SQLCODE=-913, SQLSTATE=57033 error-messages when executing a WebSphere batch-job. The detailed exception stack-trace was: StepManagerIm E com.ibm.ws.gridcontainer.batch.impl.StepManagerImpl executeStep ERROR-->exception during job execution: com.ibm.batch.api.BatchContainerRuntimeException: CWLRB1520E: [Long Running Job Container [Batch Data Stream outputStream] [job