I want to automatically generate a <select> list, where a user can select all measurement parameter, lets say Na, Mg, Cl and Si as (s)he likes. For instance I have a specific spring and all chemistry parameter are saved in one table. For our Oracle9iDB, this parameter select list can be easily populated using the query:
select column_name from user_tab_columns where table_name = 'ANALYSES_SPRINGS';
But when using queries on the USER_... data dictionary, Oracle delivers always big letters, which is for chemical elements (NA vs. Na) or location names (ALICE SPRINGS vs. Alice Springs) and location codes often uncomfortable to read. Has anyone a better solution? (I try to avoid handling every possible case with string fucntions.)
Thank you, Torsten
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
