{"id":1797,"date":"2013-05-30T02:11:56","date_gmt":"2013-05-30T02:11:56","guid":{"rendered":"http:\/\/www.withdata.com\/ad\/?p=1797"},"modified":"2017-04-20T11:14:55","modified_gmt":"2017-04-20T11:14:55","slug":"what-is-the-dual-table-in-oracle","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/oracle\/what-is-the-dual-table-in-oracle.html","title":{"rendered":"What is the dual table in Oracle"},"content":{"rendered":"<div>\n<p>It&#8217;s a sort of dummy table with a single record used for selecting when you&#8217;re not actually interested in the data, but instead want the results of some system function in a select statement:<\/p>\n<p>e.g.\u00a0<code>select sysdate from dual;<\/code><\/p>\n<\/div>\n<div><strong>dual<\/strong>\u00a0is a table which is created by oracle along with the\u00a0data dictionary. It consists of exactly one column whose name is\u00a0<strong>dummy<\/strong>\u00a0and one record. The value of that record is\u00a0<strong>X<\/strong>.<\/div>\n<div>\n<pre>rene@ora92&gt; desc dual\r\n Name                    Null?    Type\r\n ----------------------- -------- ----------------\r\n DUMMY                            VARCHAR2(1)\r\n\r\nrene@ora92&gt; select * from dual;\r\n\r\nD\r\n-\r\nX<\/pre>\n<\/div>\n<div>The owner of dual is\u00a0SYS\u00a0but dual can be accessed by every\u00a0user.<\/div>\n<p>In WikiPedia:\u00a0<a href=\"http:\/\/en.wikipedia.org\/wiki\/DUAL_table\">http:\/\/en.wikipedia.org\/wiki\/DUAL_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>It&#8217;s a sort of dummy table with a single record used for selecting when you&#8217;re not actually interested in the data, but instead want the results of some system function in a select statement: e.g.\u00a0select sysdate from dual; dual\u00a0is a table which is created by oracle along with the\u00a0data dictionary. It consists of exactly one [&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":[229,1325],"class_list":["post-1797","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-dual","tag-oracle"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1797","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=1797"}],"version-history":[{"count":6,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1797\/revisions"}],"predecessor-version":[{"id":6474,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/1797\/revisions\/6474"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=1797"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=1797"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=1797"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}