Skip to content

Net island

a small island in the net

  • oracle
  • DIY
  • hardware
  • sport
  • Uncategorized
  • uru

sql server

Inner join updates

October 30, 2009November 28, 2008 by feign

Here is how to do update of a table that needs to be joined with another table in MySQL, Oracle and SqlServer. Let’s say we want to give a 20% raise to sales department. Microsoft SQL Server: ORACLE: Be careful here to have a primary key set on Department.DepID. Otherwise you get an error ORA-01779 … Read more Inner join updates

Categories oracle Tags mysql, oracle, oracle, sql, sql server Leave a comment

development

  • DSL platform

oracle blogs

  • Oracle as I learned

Archives

  • May 2016
  • November 2014
  • September 2014
  • August 2014
  • April 2014
  • October 2011
  • March 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • July 2009
  • June 2009
  • April 2009
  • January 2009
  • November 2008
  • May 2007
  • April 2007

Categories

  • hardware
  • oracle
  • sport
  • Uncategorized
  • uru
© 2021 Net island • Powered by GeneratePress