Error At Line 3 Ora-00933 Sql Command Not Properly Ended
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 java sql sqlsyntaxerrorexception ora 00933 sql command not properly ended About Us Learn more about Stack Overflow the company Business Learn more
Ora 00933 Sql Command Not Properly Ended In Select Query
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss java sql sqlexception ora 00933 sql command not properly ended Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL Error: ORA-00933:
Ora 00933 Sql Command Not Properly Ended Insert Multiple
SQL command not properly ended up vote 7 down vote favorite I am trying to update a record in oracle SQL developer by using Joins. Following is my query- UPDATE system_info set field_value = 'NewValue' FROM system_users users JOIN system_info info ON users.role_type = info.field_desc where users.user_name = 'uname' However, when I tried to execute it, I got following error- Error report: SQL Error: ORA-00933: ora-00933 sql command not properly ended update SQL command not properly ended 00933. 00000 - "SQL command not properly ended" I tried removing JOINS UPDATE system_info info SET info.field_value = 'NewValue' FROM system_users users where users.user_name = 'uname' AND users.role_type = info.field_desc but still having same error can anybody tell me the error reason and solution sql oracle share|improve this question edited Jan 20 '12 at 11:10 Mark Bannister 34.4k32450 asked Jan 20 '12 at 11:07 Microsoft DN 5,05932345 I think your sqlDevelepor executed the previous line. put a semi colon before and after your sql statement and try again –You Qi Jan 20 '12 at 11:11 I tried your solution, but not working for me –Microsoft DN Jan 20 '12 at 11:16 add a comment| 5 Answers 5 active oldest votes up vote 9 down vote accepted Oracle does not allow joining tables in an UPDATE statement. You need to rewrite your statement with a co-related sub-select Something like this: UPDATE system_info SET field_value = 'NewValue' WHERE field_desc IN (SELECT role_type FROM system_users WHERE user_name = 'uname') For a complete description on the (valid) syntax of the UPDATE statement, please read the manual: http:
here for a quick overview of the site Help Center Detailed answers to any
Ora-00933 Sql Command Not Properly Ended Insert
questions you might have Meta Discuss the workings and policies of
Sql Command Not Properly Ended Select
this site About Us Learn more about Stack Overflow the company Business Learn more about sql command not properly ended oracle hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow http://stackoverflow.com/questions/8940471/sql-error-ora-00933-sql-command-not-properly-ended is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle ORA-00933: SQL command not properly ended? up vote 3 down vote favorite I keep getting this error. How do I solve this problem? Error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly http://stackoverflow.com/questions/22325809/oracle-ora-00933-sql-command-not-properly-ended ended Code:
Register Login [Solved] SQL command not properly ended Creating tables and queries Post a reply 11 posts • Page 1 of 1 [Solved] SQL command https://forum.openoffice.org/en/forum/viewtopic.php?t=34336 not properly ended by bartjeman » Wed Sep 22, 2010 10:38 pm http://dba.stackexchange.com/questions/71834/ora-00933-sql-command-not-properly-ended I set up a new db using the Oracle jdbc driver.I created a query based on a single table.When I run the query, an error window pops up: "The data content could not be loaded" "ORA-00933: SQL command not properly ended"The sql, however, looks just fine:SELECT sql command "C_BPARTNER_ID", "AD_CLIENT_ID", "NAME", "ISCUSTOMER", "SALESREP_ID" FROM "COMPIERE"."C_BPARTNER" AS "C_BPARTNER"Thanks for your help! Last edited by bartjeman on Tue Sep 28, 2010 1:21 am, edited 1 time in total. OpenOffice 4.0.1 on Windows 7 bartjeman Posts: 127Joined: Sun Jan 03, 2010 6:23 amLocation: Toronto Top Re: SQL command not properly ended by Villeroy » Thu Sep 23, 2010 sql command not 10:34 am Try to append a semicolon. Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.Ubuntu 14.04, OpenOffice 4.x & LibreOffice 5.x Villeroy Volunteer Posts: 22530Joined: Mon Oct 08, 2007 1:35 amLocation: Germany Top Re: SQL command not properly ended by bartjeman » Thu Sep 23, 2010 1:55 pm Hi VilleroyI appended the semi colon, same error.Code: Select all Expand viewCollapse viewSELECT "C_BPARTNER_ID", "AD_CLIENT_ID", "NAME", "ISCUSTOMER", "SALESREP_ID" FROM "COMPIERE"."C_BPARTNER" AS "C_BPARTNER";however this does work:Code: Select all Expand viewCollapse viewSELECT "C_BPARTNER_ID", "AD_CLIENT_ID", "NAME", "ISCUSTOMER", "SALESREP_ID" FROM "COMPIERE"."C_BPARTNER"Why do you think it barfs on Code: Select all Expand viewCollapse viewAS "C_BPARTNER" ? OpenOffice 4.0.1 on Windows 7 bartjeman Posts: 127Joined: Sun Jan 03, 2010 6:23 amLocation: Toronto Top Re: SQL command not properly ended by keme » Thu Sep 23, 2010 2:36 pm bartjeman wrote:Hi VilleroyI appended the semi colon, same error.Code: Select all Expand viewCollapse viewSELECT "C_BPARTNER_ID", "AD_CLIENT_ID", "NAME", "ISCUSTOMER", "SALESREP_ID" FROM "COMPIERE"."C_BPARTNER" AS "C_BPARTNER";however this does work:Code: Select all Expand viewCollap
log in tour help Tour Start 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 more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ORA-00933: SQL command not properly ended up vote 1 down vote favorite I have created a database link to a remote database, MIGRERDOSSIER.US.ORACLE.COM, then I use it to insert records in a table in a local database. Here is the request I am trying to execute: insert into Dossier(num_dossier,indice,code_service,num_secteur,date_depot,type_dossier,SUP_DECL_ARE,SUP_DECL_CE,SUP_DECL_HE,SUP_DEF_ARE,SUP_DEF_CE,SUP_DEF_HE) select s.num_dossier,s.indice,s.code_service,s.num_secteur,s.date_depot,s.cod_sous_typ,s.SUP_DECL_ARE,s.SUP_DECL_CA,s.SUP_DECL_HE,s.SUP_DEF_ARE,s.SUP_DEF_CA,s.SUP_DEF_HA from MIGRERDOSSIER.US.ORACLE.COM@Dossier s but Oracle is displaying the error ORA 00933: SQL command not properly ended. I can't figure the problem with my request, any help would be greatly appreciated. sql database-link oracle-9i share|improve this question edited Jul 21 '14 at 9:57 Mat 6,55622234 asked Jul 18 '14 at 11:10 mounaim 2271315 You're not missing the ; at the end, are you? –Vérace Jul 18 '14 at 11:34 add a comment| 1 Answer 1 active oldest votes up vote 4 down vote accepted Your syntax for using the database link is incorrect, you've got the link and table identifiers in the wrong order. It should be: sele