{"id":1598,"date":"2011-09-05T23:04:35","date_gmt":"2011-09-05T23:04:35","guid":{"rendered":"http:\/\/www.juniovitor.com\/?p=1598"},"modified":"2016-09-05T13:18:21","modified_gmt":"2016-09-05T13:18:21","slug":"1598","status":"publish","type":"post","link":"https:\/\/www.juniovitor.com\/?p=1598","title":{"rendered":"Tabelas Demo Oracle"},"content":{"rendered":"
\nAmigos, boa noite!<\/p>\n

Para voc\u00ea que est\u00e1 iniciando no PL\/SQL \/ SQL Oracle, segue um facilitador para suas consultas.<\/p>\n

Com a cria\u00e7\u00e3o dessas tabelas\/views\/indices voc\u00ea consegue trabalhar com testes de fun\u00e7\u00f5es, consultas, programas e demais atividades sem se preocupar com este pr\u00e9-requisito! Ainda mais que muitos dos exemplos de fun\u00e7\u00f5es que voc\u00ea encontrar\u00e1 na web utilizar\u00e1 essas tabelas como exemplo. Ent\u00e3o, vamos l\u00e1!<\/p>\n

Seguem scripts para Demos ORACLE SQL<\/strong>. Essas instru\u00e7\u00f5es criam\/inserem dados nas tabelas:<\/p>\n

DEMOBLD<\/strong>
\n– Emp;
\n– Dept;
\n– Bonus;
\n– Salgrade;
\n– DUMMY;<\/p>\n

LOAD SAMPLE<\/strong>
\n– Regions
\n– Countries
\n– Locations
\n– Departments
\n– Jobs
\n– Employees
\n– Job_history.<\/p>\n

Download Script Demobld.sql<\/a>
\nDownload Script Load_Sample.sql<\/a><\/p>\n

Download Script para Drop nas tabelas DemoBld.sql<\/a>
\nDownload Script para Drop nas tabelas LoadSample.sql<\/a><\/p>\n

Grande abra\u00e7o,
\nJunio Vitor\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

Amigos, boa noite! Para voc\u00ea que est\u00e1 iniciando no PL\/SQL \/ SQL Oracle, segue um facilitador para suas consultas. Com a cria\u00e7\u00e3o […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[650,662,643,654,634,638,645,656,649,661,652,664,648,660,646,658,636,640,647,659,78,657,639,644,655,622,633,204,642,653,651,663,637,162,641,635],"class_list":["post-1598","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-bonus","tag-bonus-table","tag-countries","tag-countries-table","tag-demo-oracle","tag-demobld-sql","tag-departments","tag-departments-table","tag-dept","tag-dept-table","tag-dummy","tag-dummy-table","tag-emp","tag-emp-table","tag-employees","tag-employees-table","tag-exemplos-oracle","tag-insert-data","tag-job_history","tag-job_history-table","tag-jobs","tag-jobs-table","tag-load_sample-sql","tag-locations","tag-locations-table","tag-oracle","tag-oracle-demo","tag-plsql","tag-regions","tag-regions-table","tag-salgrade","tag-salgrade-table","tag-sample-sql","tag-sql","tag-tabelas-demonstracao","tag-tabelas-oracle"],"_links":{"self":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/1598"}],"collection":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1598"}],"version-history":[{"count":4,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/1598\/revisions"}],"predecessor-version":[{"id":1602,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=\/wp\/v2\/posts\/1598\/revisions\/1602"}],"wp:attachment":[{"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1598"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1598"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juniovitor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1598"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}