โดย mindphp » 08/05/2008 1:59 am
PGSql ------------> #
SELECT
column_name
FROM
information_schema.COLUMNS
WHERE
table_name = 'your_table_name_here'
Oracle --------->
select table_name, column_name from all_tab_columns where column_name like '%X%'
PGSql ------------> #
SELECT
column_name
FROM
information_schema.COLUMNS
WHERE
table_name = 'your_table_name_here'
Oracle --------->
select table_name, column_name from all_tab_columns where column_name like '%X%'