Operations Java Scala for for(int i=0;i<1;i++){System.out.print(i);}
Month: March 2022
Shell VS PHP
Bash PHP Comments Variables Operators Logical if else for String Boolean Numeric Calculate Echo & print Function Array File Net
MySQL and Oracle SQL
Desc MySQL Oracle show create table show create table TABLE_NAME select table_name,dbms_metadata.get_ddl(‘TABLE’,’TABLE_NAME’)from dual,user_tables where table_name=’TABLE_NAME’; select table select * from dba_tables where table_name=’TABLE_NAME’ select db link select * from user_db_links;select * from dba_db_links; create table when not exists declare already_exists exception; columns_indexed exception; pragma exception_init( already_exists, -955 ); pragma exception_init(columns_indexed, -1408);begin execute immediate ‘create table MAPPING_LINKS( SOURCE_ID NUMBER(10,0), LINK(10,0) )’; execute…