Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: justTryingThis
- Order by date
-
ORA-00933: SQL command not properly ended
Turkbear I tried your suggestion the query ran two mins longer Tables are indixed as follows Sample PRIMARY KEY ( SAMPLEID ) INDEX U_SUBMISSIONID ON SAMPLE(U_SUBMISSIONID) Submission PRIMARY KEY ( SUBMISSIONID ) SDIDATAITEM PRIMARY KEY ( SDCID, KEYID1, KEYID2, KEYID3, PARAMLISTID...- justTryingThis
- Post #9
- Forum: Oracle: All versions
-
ORA-00933: SQL command not properly ended
Turkbear The original query is below I tried to revise it so it would run faster select sdidataitem.paramid, sdidataitem.displayvalue, sdidataitem.DISPLAYUNITS, sdidataitem.PARAMLISTID, sdidataitem.dataset, sdidataitem.u_quant_element, SDIDATAITEM.U_NONREPORTABLE...- justTryingThis
- Post #6
- Forum: Oracle: All versions
-
ORA-00933: SQL command not properly ended
Mufasa I tried the query with just a join instead of inner joins I get the same error I would appreciate any help you could give me on this query- justTryingThis
- Post #4
- Forum: Oracle: All versions
-
ORA-00933: SQL command not properly ended
Hi I'm new to oracle using 8.1 I getting the 933 error when excuting the following code what am I missing ? select sdidataitem.paramid, sdidataitem.displayvalue, sdidataitem.DISPLAYUNITS, sdidataitem.PARAMLISTID, sdidataitem.dataset, sdidataitem.u_quant_element, SDIDATAITEM.U_NONREPORTABLE from...- justTryingThis
- Thread
- Replies: 10
- Forum: Oracle: All versions
