Home » SQL & PL/SQL » SQL & PL/SQL » i want to update salary in employees table with analtical fuctions (oracle,unix)
i want to update salary in employees table with analtical fuctions [message #577459] Sat, 16 February 2013 02:53 Go to next message
rajeshbethin
Messages: 1
Registered: February 2013
Location: chennai
Junior Member
i have employee tabel i want to update salary with all employee 5 percent so please let me know the query
Re: i want to update salary in employees table with analtical fuctions [message #577460 is a reply to message #577459] Sat, 16 February 2013 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 59803
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Welcome to the forum.

Note that it will help you to learn but will not do your homework.
So post what you already tried and where you are stuck.
You can have a look at Database SQL Reference there is a page on UPDATE statement.

Regards
Michel
Re: i want to update salary in employees table with analtical fuctions [message #577488 is a reply to message #577460] Sun, 17 February 2013 03:35 Go to previous messageGo to next message
shumail
Messages: 81
Registered: September 2012
Location: Canada
Member
Something like below
UPDATE EMP
SET SAL=SAL+(SAL*5/100);
Re: i want to update salary in employees table with analtical fuctions [message #577492 is a reply to message #577488] Sun, 17 February 2013 08:39 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: i want to update salary in employees table with analtical fuctions [message #577511 is a reply to message #577488] Sun, 17 February 2013 14:11 Go to previous message
Michel Cadot
Messages: 59803
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
@shumail

Don't put solution only hint or clue as requested in OraFAQ Forum Guide, "Responding to Posts" section:

Quote:
When responding to questions, if it is obviously a student with a homework assignment or someone else just learning, it is usual to provide hints or clues, perhaps links to relevant portions of the documentation, or a similar example, to point them in the right direction so that they will research and experiment on their own and learn, and not provide complete solutions to problems. In cases where someone has a real-life complex work problem, or at least it may seem complex to them, it may be best to provide a complete demo and explanation.


Regards
Michel
Previous Topic: update query not working
Next Topic: Nesting subqueries to sum data in different ways
Goto Forum:
  


Current Time: Thu Nov 27 04:03:16 CST 2014

Total time taken to generate the page: 0.14190 seconds