create global temporary table temp_tab_name (column datatype[,column datatype]) [on commit{delete|preserve} rows];