select dbms_metadata.get_ddl('TABLE', 'the_table_name', 'the_schema_name') from dual Replace “the_table_name” and “the_schema_name” with yours. See also: How to generate a CREATE TABLE statement for a given table in SQL Server How to generate a CREATE TABLE statement for a ... Read more
How to generate a CREATE TABLE statement for a given table in SQL Server
declare @table varchar(100) set @table = 'my_table' -- set table name here declare @sql table(s varchar(1000), id int identity) -- create statement insert into @sql(s) values ('create table [' + @table + '] (') -- column list insert into @sql(s) select ' ['+column_name+'] ' + ... Read more
Withdata Software Released Withdata OracleToExcel 1.8
Withdata software has announced withdata oracletoexcel 1.8, a data conversion tool that export Oracle data to excel. Withdata OracleToExcel 1.8 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. Withdata ... Read more
Withdata Software Released Withdata MysqlToExcel 1.8
Withdata software has announced withdata mysqltoexcel 1.8, a data conversion tool that export MySQL data to excel. Withdata MysqlToExcel 1.8 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. Withdata ... Read more
Withdata Software Released Withdata MsSqlToExcel 1.8
Withdata software has announced withdata mssqltoexcel 1.8, a data conversion tool that export ms SQL Server data to excel. Withdata MsSqlToExcel 1.8 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. Withdata ... Read more
Withdata Software Released Withdata DB2ToExcel 1.9
Withdata software has announced withdata db2toexcel 1.9, a data conversion tool that export DB2 data to excel. Withdata DB2ToExcel 1.9 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. Withdata DB2ToExcel ... Read more
Withdata Software Released Withdata AccessToExcel 1.9
Withdata software has announced withdata accesstoexcel 1.9, a data conversion tool that export Access data to excel. Withdata AccessToExcel 1.9 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. Withdata ... Read more
Withdata Software Released SqlToTxt Version 2.4
Withdata software has announced sqltotxt 2.4, a data conversion tool that export SQL Server data to flat file (csv, xml, html, sql) and excel. SqlToTxt 2.4 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql ... Read more
Withdata Software Released MyToTxt Version 2.1
Withdata software has announced mytotxt 2.1, a data conversion tool that export MySQL data to flat file (csv, xml, html, sql) and excel. MyToTxt 2.1 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. MyToTxt ... Read more
Withdata Software Released DB2ToTxt Version 1.9
Withdata software has announced db2totxt 1.9, a data conversion tool that export DB2 data to flat file (csv, xml, html, sql) and excel. DB2ToTxt 1.9 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. DB2ToTxt ... Read more