Home » SQL & PL/SQL » SQL & PL/SQL » Newbie two table update question (
Newbie two table update question [message #420825] Wed, 02 September 2009 09:21 Go to next message
Messages: 1
Registered: September 2009
Junior Member
Hi, I'm new to pl/sql and I can't seem to find a simple update command reference.

Here's the standard SQL version:
UPDATE cdr_temp_feed AS f, cdr_did_ranges AS r
SET citi2citi = 'Y'
WHERE f.ltrim(f.dest_number,'011') >= r.START_RANGE And f.ltrim(dest_number,'011') <= r.END_RANGE
and CALL_TYPE = 'Overseas';

This works well enough in Sybase (where I spent the last few years) but not in Oracle.

What's the equivalent SQL for oracle?

Re: Newbie two table update question [message #420827 is a reply to message #420825] Wed, 02 September 2009 09:23 Go to previous message
Messages: 24971
Registered: January 2009
Location: SoCal
Senior Member
Oracle can only UPDATE 1 file at a time is 1 problem that needs to be changed.

When all else fails, Read The Fine Manual

Previous Topic: Import File
Next Topic: How To Check The Index Creation Date(2 merged)
Goto Forum:

Current Time: Fri Oct 28 03:37:07 CDT 2016

Total time taken to generate the page: 0.12469 seconds