SELECT colname, typename, length, scale, default FROM syscat.columns WHERE tabname = “<table name>” AND tabschema = “<schema name>” See also: How to get column names from Sql Server table How to get column names from Oracle table How to get column names from ... Read more
How to get column names from Mysql table
We can use information_schema.columns for getting column information SELECT column_name FROM information_schema.columns WHERE table_schema = ‘My_Schema_Name’ AND table_name = ‘My_Table_Name’ See also: How to get column names from Sql Server table How to get column names ... Read more
How to get column names from Sql Server table
SELECT [name] AS [Column Name] FROM syscolumns WHERE id = (SELECT id FROM sysobjects WHERE type = ‘U’ AND [Name] = ‘My_Table_Name’) Type = ‘V’ for views Type = ‘U’ for tables For SQL Server 2008, we can use information_schema.columns for getting ... Read more
How to get column names from Oracle table
You can query the USER_TAB_COLUMNS table for table column metadata. SELECT table_name, column_name, data_type, data_length FROM USER_TAB_COLUMNS WHERE table_name = ‘My_Talbe_Name’ See also: How to get column names from Sql Server table How to get column names from DB2 table How to ... Read more
What is the dual table in Oracle
It’s a sort of dummy table with a single record used for selecting when you’re not actually interested in the data, but instead want the results of some system function in a select statement: e.g. select sysdate from dual; dual is a table which is created by oracle along with ... Read more
Withdata Software Released XlsToSql Version 2.3
Withdata software has announced xlstosql 2.3, a data conversion tool that import Excel data to ms SQL Server database. XlsToSql 2.3 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance, and fix bug of exporting multiple sheets at ... Read more
Withdata Software Released XlsToOra Version 2.8
Withdata software has announced xlstoora 2.8, a data conversion tool that import Excel data to Oracle database. XlsToOra 2.8 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance, and fix bug of exporting multiple sheets at one ... Read more
Withdata Software Released XlsToMy Version 2.0
Withdata software has announced xlstomy 2.0, a data conversion tool that import Excel data to MySQL database. XlsToMy 2.0 add “Make Batch File”, add “Date Format Config”, and some other bug fixes and enhancements. XlsToMy – The better way to import Excel data to ... Read more
Withdata Software Released XlsToMdb Version 2.4
Withdata software has announced xlstomdb 2.4, a data conversion tool that import Excel data to Access database. XlsToMdb 2.4 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance, and fix bug of exporting multiple sheets at one ... Read more
Withdata Software Released XlsToDB2 Version 1.8
Withdata software has announced xlstodb2 1.8, a data conversion tool that import Excel data to DB2 database. XlsToDB2 1.8 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance, and fix bug of exporting multiple sheets at one ... Read more