The Semicolon Wars

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #259,051 by ChrisR 6/15/06 11:57:36 AM Reply	The Semicolon Wars Light reading about the diversity of programming languages: [link\|http://www.americanscientist.org/template/AssetDetail/assetid/51982\|The Semicolon Wars]. Probably even understandable for our non-PL iwethey'rs.
Post #259,086 by ben_tilly 6/15/06 5:55:20 PM Reply	Good article but one nit He thinks that there is no argument any more about CamelCase. Hasn't he heard of using_underscores_instead? Cheers, Ben The great masses of people ... will more easily fall victims to a big lie than to a small one. -- Adolf Hitler
Post #259,094 by admin 6/15/06 8:02:06 PM Reply	Agreed. I'd like to meet the person who started using camel case in our PL/SQL code... in a dark alley... with a bat. Camel case is a nightmare in a language that turns names into ALL UPPERCASE. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #259,150 by jb4 6/16/06 12:23:43 PM Reply	chuckle What benighted retrograde version of SQL does that? (Asked by a person who has been "exposed" to SQL in much the same way as one would be "exposed" to chicken pox...) jb4 "So don't pay attention to the approval ratings that say 68% of Americans disapprove of the job this man is doing. I ask you this, does that not also logically mean that 68% approve of the job he's not doing? Think about it. I haven't." — Stephen Colbert, at the White House Correspondent's Dinner 29Apr06
Post #259,151 by admin 6/16/06 12:39:08 PM Reply	Most SQL is case-insensitive by default I think MySQL isn't, though. Most of the other ones you can force it to recognize case by using double quotes around names. The issue with Oracle is that it stores object names (like schema.my_table) in uppercase, and that's how all of the error messages are returned. So if you have some object type named SchemasShatterStorage in the AS schema, when you get an error message or need to refer to the type name from some other language (like Java or Perl), it looks like this: AS.SCHEMASSHATTERSTORAGE... or AssChemAssHatterStorage... not what you really intended, eh? Or worse, MyVeryLongNameWithALotOfSmallWords becomes MYVERYLONGNAMEWITHLOTSOFSHORTWORDS... try and parse that quickly. Much better to use underscores because the meaning is preserved no matter what the case: AS.SCHEMAS_SHATTER_STORAGE. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #259,155 by ben_tilly 6/16/06 1:14:59 PM Reply	You can make Oracle case sensitive And when it is case sensitive, it returns the case in error messages. But this requires always enclosing the name in double quotes, which is a royal PITA. Cheers, Ben The great masses of people ... will more easily fall victims to a big lie than to a small one. -- Adolf Hitler
Post #259,156 by admin 6/16/06 1:25:36 PM Reply	Yep, I knew that. I forgot to include it in my post. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #259,157 by jb4 6/16/06 1:35:50 PM 6/16/06 1:37:07 PM Reply	Thanks for the clarification, Scott I didn't know about the error message problem. (And I loved the "manufactured camel case") jb4 "So don't pay attention to the approval ratings that say 68% of Americans disapprove of the job this man is doing. I ask you this, does that not also logically mean that 68% approve of the job he's not doing? Think about it. I haven't." — Stephen Colbert, at the White House Correspondent's Dinner 29Apr06 Edited by jb4 June 16, 2006, 01:37:07 PM EDT Expand All History

The Semicolon Wars - (ChrisR) - (7) - June 15, 2006, 11:57:36 AM EDT

Good article but one nit - (ben_tilly) - (6) - June 15, 2006, 05:55:20 PM EDT

Agreed. - (admin) - (5) - June 15, 2006, 08:02:06 PM EDT

**chuckle** - (jb4) - (4) - June 16, 2006, 12:23:43 PM EDT

Most SQL is case-insensitive by default - (admin) - (3) - June 16, 2006, 12:39:08 PM EDT

You can make Oracle case sensitive - (ben_tilly) - (1) - June 16, 2006, 01:14:59 PM EDT

Yep, I knew that. - (admin) - June 16, 2006, 01:25:36 PM EDT

Thanks for the clarification, Scott - (jb4) - June 16, 2006, 01:37:07 PM EDT

iwethey.org