Home » SQL & PL/SQL » SQL & PL/SQL » query required
query required [message #250979] Thu, 12 July 2007 02:03 Go to next message
Messages: 10
Registered: November 2006
Junior Member
hi this is preeti,
I have a table emp and i want to update the rows based on salary filed (i.e., sal > 3000) I want to increase1 1000 for these recors . what i need is I have to get the count of these rows that r updated. how to write aquery
Re: query required [message #251000 is a reply to message #250979] Thu, 12 July 2007 02:47 Go to previous message
Messages: 1832
Registered: November 2006
Senior Member
you should start studying documentation found eg. at http://tahiti.oracle.com/. You will find there a lot of useful examples too.
How to update desired rows: SQL Reference, SQL Statements, UPDATE
How to get the updated row count: PL/SQL User's Guide and Reference, PL/SQL Language Elements, SQL Cursor

If you get into trouble, show here, how far did you get so far. Please follow then How to get a quick answer to your question: TIPS AND TRICKS recommendation (found in the newbie forum).

[Edit: hints precised]

[Updated on: Thu, 12 July 2007 02:51]

Report message to a moderator

Previous Topic: Error ORA-00947(not enough values)
Next Topic: PL/SQL - DATETIME variable
Goto Forum:

Current Time: Tue Oct 25 00:00:05 CDT 2016

Total time taken to generate the page: 0.10174 seconds