Home » SQL & PL/SQL » SQL & PL/SQL » moving records
moving records [message #291336] Thu, 03 January 2008 23:05 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi ,
I have I/P like follows.

SQL> select * from purchase;

      ITEM        LOC    ORDERED   RECEIVED
---------- ---------- ---------- ----------
      1002        623        230          0
      1002        626          0        230
      1002        636          0          0
      2001        636        900          0
      2001        626          0        908

Now I need to update the records as follows
SQL> select * from purchase;

      ITEM        LOC    ORDERED   RECEIVED
---------- ---------- ---------- ----------
      1002        623        230        230
      1002        626          0          0
      1002        636          0          0
      2001        636        900        908
      2001        626          0          0


using Pl/sql

can any one pls help me in this issue.

Thank u.

[Updated on: Thu, 03 January 2008 23:07]

Report message to a moderator

Re: moving records [message #291339 is a reply to message #291336] Thu, 03 January 2008 23:10 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW posting guidelines as state in URL above.

By The Way, "u" is not a member of this forum.

[Updated on: Thu, 03 January 2008 23:10] by Moderator

Report message to a moderator

Re: moving records [message #291342 is a reply to message #291336] Thu, 03 January 2008 23:27 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

If you like to do this using pl/sql, try using ref cursor.

Naveen
Re: moving records [message #291345 is a reply to message #291339] Thu, 03 January 2008 23:37 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi ,
I am also a member. Excuse me if didn't follow the rules. From next time i'll follow. Please help me in this issue.

thank u.
Re: moving records [message #291348 is a reply to message #291336] Thu, 03 January 2008 23:41 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

It is repetition again .

Thumbs Up
Rajuvan

[Updated on: Thu, 03 January 2008 23:42]

Report message to a moderator

Re: moving records [message #291352 is a reply to message #291336] Thu, 03 January 2008 23:47 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>From next time i'll follow. Please help me in this issue.
You choose to ignore the guidelines REPEATEDLY!
I choose to not provide answers & not provide any clues.
Re: moving records [message #291384 is a reply to message #291345] Fri, 04 January 2008 01:15 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Excuse me if didn't follow the rules. From next time i'll follow.

You're a liar as this is not the first we asked you this and you ignored it.

Quote:

Please help me in this issue.

This was already done as Rajuvan posted it.

Regards
Michel
Previous Topic: help me kick start with UTL_DBWS please
Next Topic: Stored Proceudure
Goto Forum:
  


Current Time: Sun Dec 04 16:50:43 CST 2016

Total time taken to generate the page: 0.06376 seconds