{"id":1802,"date":"2013-05-30T02:17:26","date_gmt":"2013-05-30T02:17:26","guid":{"rendered":"http:\/\/www.withdata.com\/ad\/?p=1802"},"modified":"2017-04-20T11:20:36","modified_gmt":"2017-04-20T11:20:36","slug":"how-to-get-column-names-from-oracle-table","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/oracle\/how-to-get-column-names-from-oracle-table.html","title":{"rendered":"How to get column names from Oracle table"},"content":{"rendered":"<p>You can query the USER_TAB_COLUMNS table for table column metadata.<\/p>\n<p><strong>SELECT table_name, column_name, data_type, data_length<\/strong><br \/>\n<strong> FROM USER_TAB_COLUMNS<\/strong><br \/>\n<strong> WHERE table_name = &#8216;My_Talbe_Name&#8217;<\/strong><\/p>\n<p>See also:<\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/sql%20server\/how-to-get-column-names-from-sql-server-table.html\">How to get column names from Sql Server table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/db2\/how-to-get-column-names-from-db2-table.html\">How to get column names from DB2 table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/mysql\/how-to-get-column-names-from-mysql-table.html\">How to get column names from Mysql table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/postgresql\/how-to-get-column-names-from-postgresql-table.html\">How to get column names from PostgreSQL table<\/a><\/p>\n<p><a href=\"http:\/\/www.withdata.com\/blog\/sqlite\/how-to-get-column-names-from-sqlite-table.html\">How to get column names from SQLite table<\/a><\/p>\n<p>Some Oracle tools you can try: <a href=\"https:\/\/www.withdata.com\/oracle\/\"> https:\/\/www.withdata.com\/oracle\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 = &#8216;My_Talbe_Name&#8217; See also: How to get column names from Sql Server table How to get column names from DB2 table How to get column names from Mysql table How to get column names from PostgreSQL [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[230,1325],"class_list":["post-1802","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-get-column-names","tag-oracle"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1802","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=1802"}],"version-history":[{"count":5,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1802\/revisions"}],"predecessor-version":[{"id":6485,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1802\/revisions\/6485"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=1802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=1802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=1802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}