Search results
17 sty 2009 · You can query the USER_TAB_COLUMNS table for table column metadata. SELECT table_name, column_name, data_type, data_length FROM USER_TAB_COLUMNS WHERE table_name = 'MYTABLE'
8 sie 2017 · I find this one useful in Oracle: SELECT obj.object_name, atc.column_name, atc.data_type, atc.data_length FROM all_tab_columns atc, (SELECT * FROM all_objects WHERE object_name like 'GL_JE%' AND owner = 'GL' AND object_type in ('TABLE','VIEW') ) obj WHERE atc.table_name = obj.object_name ORDER BY obj.object_name, atc.column_name;
28 lis 2018 · select col.column_id, col.owner as schema_name, col.table_name, col.column_name, col.data_type, col.data_length, col.data_precision, col.data_scale, col.nullable from sys.all_tab_columns col inner join sys.all_tables t on col.owner = t.owner and col.table_name = t.table_name where col.owner = 'AP' and col.table_name = 'AP_INVOICES_ALL' order by ...
1 lis 2013 · SELECT <column_name> FROM <table_name> WHERE NVL(LENGTH(REPLACE( translate( <column_name>, '0123456789', '0000000000' ), '0', '' )), 0) = 0
4 sie 2024 · This query retrieves the column names for a specific table within a specified database. For instance, we print the column names from the Course table using INFORMATION_SCHEMA: SELECT COLUMN_NAME FROM information_schema.columns WHERE TABLE_NAME = 'course'; COLUMN_NAME credits department_id id is_active name textbook
SELECT column_name FROM all_tab_columns WHERE table_name = ‘your_table_name’; By simply replacing ‘your_table_name’ with the specific name of your table, this query will return a list of column names in that table.
Specify query_name followed by a period and the asterisk to select all columns from the specified subquery block. For query_name, specify a subquery block name already specified in the subquery_factoring_clause.
