--- "D. K. Wema" <[EMAIL PROTECTED]> wrote: > Thanks Brian. I'll try that, or simply keep the ELSE > option since it's UPDATING the table fine. > > -- > dkwema
For comparisons of how four RDBMS implement standard ANSI SQL get a copy of SQL IN A NUTSHELL http://www.amazon.com/exec/obidos/ASIN/0596004818/timetravellitera It includes examples from Oracle, SQL Server, PostgreSQL, and MySQL along with the ANSI standard. It is essential for making SQL queries which must be compatable with several database systems. There is even brief information on the functions available in each system. Here are some links to indicate how CASE and IF ... ELSE is handled in MySQL for comparison to your Oracle docs: http://mysqld.active-venture.com/Control_flow_functions.html http://dev.mysql.com/doc/mysql/en/if-statement.html The first one has more examples than the standard docs. MySQL also has an IF function: IF(condition, val_if_true, val_if_false) which could be ideal for you as well if it is available in Oracle as well. James _____ James D. Keeline http://www.Keeline.com http://www.Keeline.com/articles http://Stratemeyer.org http://www.Keeline.com/TSCollection http://www.ITeachPHP.com -- Free Computer Classes: Linux, PHP, etc. Summer Semester Begins Jun 20 -- New Classes Start Every Few Weeks. ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12ht83ftj/M=362335.6886445.7839731.1510227/D=groups/S=1705005703:TM/Y=YAHOO/EXP=1122998437/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</a>.</font> --------------------------------------------------------------------~-> Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
