Ora-00933 Sql Error
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson ora 00933 sql command not properly ended in select query Blog
ora-00933 sql command not properly ended insert ORA-00933: SQL command not properly ended Question: on ORA-00933: SQL command not properly ended CODE UPDATE PEOPLE sql command not properly ended select SET PEOPLE.SURNAME = HR_DATA_IMPORT.SURNAME INNER JOIN PEOPLE ON HR_DATA_IMPORT.NI.NO = PEOPLE.NI_NUMBER; ORA-00933: SQL command not properly ended ORA-00933: SQL command not properly ended Cause: The SQL statement ends with an inappropriateOra-00933 Sql Command Not Properly Ended Group By
clause. For example, an ORDER BY clause may have been included in a CREATE VIEW or INSERT statement. ORDER BY cannot be used to create an ordered view or to insert in a certain order. Action: Correct the syntax by removing the inappropriate clauses. It may be possible to duplicate the removed clause with another SQL statement. For example, to order the rows sql command not properly ended join of a view, do so when querying the view and not when creating it. This error can also occur in SQL*Forms applications if a continuation line is indented. Check for indented lines and delete these spaces. Answer by Chenn: I am never able to run an update using a join. You need a subselect. Filter it by pushing your field from the main query into the subselect. I'm not sure what your NI.No field is so you may need to take a look at that... UPDATE PEOPLE a SET a.SURNAME = ( select b.SURNAME from PEOPLE b where b.NI.NO = a.NI_NUMBER ) Get the Complete Oracle SQL Tuning Information The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. �� Burleson is the American Team Not
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies ora-00933: sql command not properly ended in java of this site About Us Learn more about Stack Overflow the company
Ora-00933 Update
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges
Ora-00933 Group By
Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: http://www.dba-oracle.com/t_ora_00933_sql_command_ended.htm Sign up SQL: ORA-00933 error in select up vote 2 down vote favorite I'm trying to perform a somewhat complex select from 3 tables, all joined by a b_id: select max(bs.b_id), h.b_type_id, t.name_id from b_state as bs, t_info as t, history as h where bs.b_id = t.b_id and bs.b_id = h.b_id and t.name_id in (???) and bs.is_detached = ? group by h.b_type_id, http://stackoverflow.com/questions/8817532/sql-ora-00933-error-in-select t.name_id In MySQL it gives exactly what I want, but it seems to fail in PSQL and Oracle, plus execution in Oracle results in: "ORA-00933: SQL command not properly ended" (which usually occurs in INSERT queries as Google suggests). I suppose there is a DB independent way to do the same. Please advice. sql oracle share|improve this question edited Jan 11 '12 at 10:17 Ollie 11.5k22849 asked Jan 11 '12 at 10:13 Maxim 11229 How are you executing this query in Oracle - ie. via JDBC, ODBC, through SQLPlus ...? –Mark Bannister Jan 11 '12 at 11:26 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote accepted Try: select max(bs.b_id), h.b_type_id, t.name_id from b_state bs inner join t_info t on bs.b_id = t.b_id inner join history h on bs.b_id = h.b_id where t.name_id in (???) and bs.is_detached = ? group by h.b_type_id, t.name_id share|improve this answer answered Jan 11 '12 at 10:18 aF. 22.9k2694151 The same - thanks, I will check your variant. –Maxim Jan 11 '12 at 10:24 That is the proble
Digital Records Management Enterprise Content Management Strategy Digital Asset Management Oracle Imaging & Process Management Web Content Management Oracle WebCenter Portal Enterprise Portal Support Enterprise https://www.tekstream.com/resources/ora-00933-sql-command-not-properly-ended/ Portal Strategy Enterprise Portal Upgrade Oracle WebCenter Sites Sourcing Staffing & Recruiting Recruiting Managed Services Candidate Registration Technical Focus Client Opportunities Support Solutions Training Legacy to Oracle WebCenter Oracle Documents Cloud Service Next Generation AP Automation & Dynamic Discounting Oracle WebCenter Contract Lifecycle Management (CLM) Search ORA-00933:SQL command not properly endedYou sql command are here: Home / Resources / ORA-00933:SQL command not properly ended ORA-00933 Error Message SQL A vast majority of Oracle mistakes are the result of simple mix-ups. Whether it is through copying and pasting across programs, mistaking program functions, or just plainly getting distracted during your work, programming an Oracle database sql command not can run into user errors that are relatively easy to create. Thankfully, the user-friendly nature of Oracle means that these problems, such as an ORA-00933 message, can often be fairly straightforward in remedying. The ORA-00933 error message is triggered by an SQL command being ended with an improper clause. SQL statements in Oracle have standard clauses that can be used in conjunction. When a clause that does not typically fall under the command of a particular SQL statement is inserted, the ORA-00933 error message is the outcome. An ORA-00933 error can commonly occur in response to an attempt to execute an INSERT statement with a ORDER BY clause. In Oracle, and ORDER BY clause cannot be used in statements to insert items in a particular order or with CREATE VIEW to create an ordered view. In practice, it means that prior to your semi-colon to end the statement, you began with an INSERT statement and