Oracle Error Code 933
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
Ora-00933 Error Select
Don Burleson Blog
sql command not properly ended oracle ORA-00933: SQL command not properly ended Question: on ORA-00933: SQL command not properly endedSql Command Not Properly Ended Oracle Select
CODE UPDATE PEOPLE 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 ora-00933: sql command not properly ended insert with an inappropriate 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 sql command not properly ended join example, to order the rows 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. ��
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta
Ora-00933 Sql Command Not Properly Ended Group By
Discuss the workings and policies of this site About Us Learn ora-00933 sql command not properly ended in java more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us
Ora-00933: Sql Command Not Properly Ended Delete
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 programmers, just like http://www.dba-oracle.com/t_ora_00933_sql_command_ended.htm you, helping each other. Join them; it only takes a minute: Sign up ora-00933:SQL command not properly ended up vote 3 down vote favorite I have the following code: begin for i in 1..2 loop insert into dba_xy.despatch select desp_id_seq.nextval, dbms_random.string('U',5), trunc(dbms_random.value(0000,9999)), prod_id from dba_xy.product prod_name from dba_xy.product; end loop; end; When I run it, oracle gives http://stackoverflow.com/questions/1319992/ora-00933sql-command-not-properly-ended me the following error message: prod_name from dba_xy.product; * ERROR at line 8: ORA-06550: line 8, column 29: PL/SQL: ORA-00933: SQL command not properly ended ORA-06550: line 3, column 2: PL/SQL: SQL Statement ignored What I'm trying to do is link the existing prod_id and prod_name with new data inserted into the despatch table. I have set prod_name as a unique key in the product table and prod_id as the primary key and have set both as foreign key constraints in the despatch table. I need to include the prod_name into the despatch table to allow readers of the table to have more understanding of what prod_name needs to be found etc, rather than just giving the prod_id which will make no sense to them at all. But maybe I was thinking that I don't need prod_id in the despatch table. Please help. After dropping the prod_id column from the despatch table, i altered my code: begin for i in 1..2 loop insert into dba_xy.despatch select desp_id_seq.nextval, dbms_random.string('U',5), trunc(dbms_random.value(0000,9999))
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 http://stackoverflow.com/questions/22325809/oracle-ora-00933-sql-command-not-properly-ended about 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 is a community of 6.2 million programmers, just like you, helping http://www.dbforums.com/showthread.php?1691192-ORA-00933-SQL-command-not-properly-ended 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 SQL command not properly ended Code:
be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 15 of 19 Thread: ORA-00933: SQL command not properly ended Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-23-13,16:08 #1 Ritesh@ti View Profile View Forum Posts Registered User Join Date Mar 2013 Posts 14 Unanswered: ORA-00933: SQL command not properly ended Hi folks I am trying to export the table data to a text file using the following sql query : SELECT * FROM departments INTO OUTFILE C:/outfile.txt ; When the command is run on a sql editor , it gives the following error - Error code 933, SQL state 42000: ORA-00933: SQL command not properly ended Please help sort out this error. Thank you Reply With Quote 03-23-13,17:49 #2 shammat View Profile View Forum Posts Registered User Join Date Nov 2003 Posts 2,919 Provided Answers: 8 Please read the manual. There is no option "into outfile" in Oracle I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code Tips for good questions: http://tkyte.blogspot.de/2005/06/how...questions.html http://wiki.postgresql.org/wiki/SlowQueryQuestions http://catb.org/esr/faqs/smart-questions.html Reply With Quote 03-24-13,03:54 #3 Ritesh@ti View Profile View Forum Posts Registered User Join Date Mar 2013 Posts 14 Originally Posted by shammat Please read the manual. There is no option "into outfile" in Oracle But I can see Code: SELECT * INTO OUTFILE filename ... FROM tablename do exist . I have searched for it on various sites. Reply With Quote 03-24-13,04:12 #4 shammat View Profile View Forum Posts Registered User Join Date Nov 2003 Posts 2,919 Provided Answers: 8 Originally Posted by Ritesh@ti But I can see Code: SELECT * INTO OUTFILE filename ... FROM tablename do exist . I have searched for it on various sites. No it doesn't. Don't look in