{"id":472,"date":"2022-03-11T20:24:28","date_gmt":"2022-03-11T12:24:28","guid":{"rendered":"https:\/\/heoffice.com\/?p=472"},"modified":"2022-04-02T21:16:49","modified_gmt":"2022-04-02T13:16:49","slug":"mysql-and-oracle-sql","status":"publish","type":"post","link":"https:\/\/heoffice.com\/?p=472","title":{"rendered":"MySQL and Oracle SQL"},"content":{"rendered":"\n
<\/th><\/th><\/th><\/tr><\/thead>
Desc<\/td>MySQL<\/td>Oracle<\/td><\/tr>
show create table<\/td>show create table TABLE_NAME<\/td>select table_name,dbms_metadata.get_ddl(‘TABLE’,’TABLE_NAME’)from dual,user_tables where table_name=’TABLE_NAME’;<\/td><\/tr>
select table <\/td><\/td>select * from dba_tables where table_name=’TABLE_NAME’<\/td><\/tr>
select db link<\/td><\/td>select * from user_db_links;
select * from dba_db_links;<\/td><\/tr>
create table when not exists<\/td><\/td>declare
\u00a0 already_exists \u00a0exception;
\u00a0 columns_indexed exception;
\u00a0 pragma exception_init( already_exists, -955 );
\u00a0 pragma exception_init(columns_indexed, -1408);
begin
\u00a0 execute immediate 'create table MAPPING_LINKS( SOURCE_ID NUMBER(10,0), LINK(10,0) )';
\u00a0 execute immediate 'create index IDX_MAPPING_LINKS_SOURCEID on MAPPING_LINKS (SOURCE_ID)'; \u00a0
\u00a0 dbms_output.put_line( 'created' );
exception
\u00a0 when already_exists or columns_indexed then
\u00a0 dbms_output.put_line( 'skipped' ); \u00a0
end;
\/<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"

Desc MySQL Oracle show create table show create table T…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[58,59],"tags":[],"class_list":["post-472","post","type-post","status-publish","format-standard","hentry","category-program","category-sql"],"acf":[],"_links":{"self":[{"href":"https:\/\/heoffice.com\/index.php?rest_route=\/wp\/v2\/posts\/472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/heoffice.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/heoffice.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/heoffice.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/heoffice.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=472"}],"version-history":[{"count":13,"href":"https:\/\/heoffice.com\/index.php?rest_route=\/wp\/v2\/posts\/472\/revisions"}],"predecessor-version":[{"id":580,"href":"https:\/\/heoffice.com\/index.php?rest_route=\/wp\/v2\/posts\/472\/revisions\/580"}],"wp:attachment":[{"href":"https:\/\/heoffice.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/heoffice.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/heoffice.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}