Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

i always get this error "Oracle 10g SQL error:ORA-00933: SQL command not properly ended

2875401Feb 2 2015 — edited Feb 3 2015

hi every one i need help i have simple query

but always get this error ( Oracle 10g SQL error:ORA-00933: SQL command not properly ended)

my query is

select * from mydb.dbo.customer union select * from mydb2.dbo.customer;

where both customer table are same data type

please help me and thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2015
Added on Feb 2 2015
10 comments
851 views