Yes, using views are often the best, but there is a limitation of 30 char. SELECT count (Mailbox_ID) from AR_System_Email_Mailbox_Configuration returns ARERR [552] Failure during SQL operation to the database : ORA-00972: identifier is too long
Is this case SELECT count (C1) from T721 works To avoid using T721 in the code, which will be changed after a migration, get the T nr before executing the command. select schemaid from arschema where name = '$SCHEMA$' Save the result, 721 in a tmp field After that You can run select count (c1) from T$Tnr Form$ where C538170941 = 0 or whatever you want. This will work even after a migration. (Databaseid's are not changed) L ars Pettersson Vattenfall Business Services Nordic AB Action Request System Engineer (Tabasco) S-461 88 Trollhättan Sweden Phone +46 520 888 35 Mobil +46 70 608 99 95 e-mail: [EMAIL PROTECTED] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
