RE: Error ORA-00972
John Dorlon <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <4120B436C765EC43A31CC3E2A13D36A622566F70@ALVMBXW02.prod.quest.corp> |
I don't think the alias is actually required no matter how long the expression for the column. But if you do specify an alias, it needs to be 30 characters or less. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Norman Dunbar Sent: Thursday, October 20, 2011 9:31 AM To: [email protected] Subject: Re: [toad] Error ORA-00972 On 20/10/11 15:28, Flad Deborah M. (DSCYF) wrote: > Thanks - comes with years of writing and reading bad SQL J..and Toad > formatting helps lots too. Funny thing is, I tried a huge DECODE in Toad, and got an extremely wide column header and a result. No error. :-( -- Cheers, Norm. [TeamT] ------------------------------------ Yahoo! Groups Links ------------------------------------ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/toad/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/toad/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> 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/