Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 6th, 2004, 01:21 PM
Authorized User
 
Join Date: Sep 2003
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default This statement fails!



How come this statement fails on Oracle!!

UPDATE TestTickets_T SET TestTicketStatusID=(select TestTicketStatusID from TestTicketStatus_T where InternalName='TICKET_STATUS_IMPORTING') FROM TestTickets_T WHERE TestTicketID=382

I am puzzled!

Pankaj

 
Old July 6th, 2004, 02:38 PM
Authorized User
 
Join Date: Sep 2003
Posts: 83
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Found out Oracle UPDATE statements do not have a FROM clause!

Pankaj






Similar Threads
Thread Thread Starter Forum Replies Last Post
INSERT Fails teddyk ASP.NET 2.0 Basics 3 July 23rd, 2008 08:58 AM
Fails To Update sirmilt BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 12 May 8th, 2008 11:16 AM
CreateObject fails slam Javascript 1 October 6th, 2006 10:32 AM
insert fails Mitch MySQL 3 June 3rd, 2006 11:48 AM
xp_sendmail fails rvw SQL Server 2000 1 December 9th, 2003 06:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.