Re: Help Help Help Help Help Help Help Help Help Help Help Paleeeeeezzzzzzz!!!!!!!!

I am a novice to Oracle, but I know SQL fairly well, and I think you can do your update with an "update query". I've used them often in Access, and I believe it is ANSI compliant, so Oracle should have the command. Look it up. It would be vastly quicker than using code.

Dave Bicking

In article <329b314c.11287833_at_news.primenet.com>, RogerRabbit_at_TuneTownUSA.com wrote:
>I have a problem that I need to solve at work, and thinking that
>there is a good chance that someone in this conference/news group
>would know how to tackle it, I decided to give this avenue a try...
>
>Here it is;
>1. I need to update a table with information from another table.
>2. These two tables are 'linked' by their equipment number (eqnum).
>3. Table names are PM and EQUIPMENT.
>4. The two rows (fields) are of the same type/size and match.
>5. The row to update is from the PM table and is called PM1
> (NUM 15.2 NOT NULL)
>6. The row the information is from the EQUIPMENT table and is
> called METERREADING (NUM 15.2 NOT NULL)

--
Come visit our humble keep at:
http://www.netaxis.com/nephilim/
You'll find many very interesting links!  Let us know if you like our pages.