In MySQL, you can use “Limit n,m”, like this: select * from sometable order by name limit 20,10 How to do in Oracle? select * from ( select a.*, ROWNUM rnum from ( <your_query_goes_here, with order by> ) a where ROWNUM <= :MAX_ROW_TO_FETCH ) where rnum >= ... Read more
Fetch the row which has the Max value for a column on Mysql
I have a MySQL table clientipstat, 3 columns: barcode, statdate, count. I want to get the latest row for each barcode(1 result per unique barcode), like ... Read more
Withdata Software Released OraLobEditor 3.5
Withdata software has announced oralobeditor 3.5, a tool that helps you edit Oracle lob(clob,blob) data directly. OraLobEditor 3.5 add PDF View, add “Execute Sql from Command line”, improve logon form, improve “Check update”, and fix bug on “Execute from command ... Read more
Withdata Software Released SqlLobEditor 2.1
Withdata software has announced sqllobeditor 2.1, a tool that helps you edit SQL Server lob(text,ntext,image) data directly. SqlLobEditor 2.1 add PDF View, add “Execute Sql from Command line”, improve logon form, improve “Check update”, and fix bug on “Execute from ... Read more
Withdata Software Released MyLobEditor 1.9
Withdata software has announced mylobeditor 1.9, a tool that helps you edit MySQL lob(text,blob) data directly. MyLobEditor 1.9 add PDF View, add “Execute Sql from Command line”, improve logon form, improve “Check update”, and fix bug on “Execute from command ... Read more
Withdata Software Released DB2LobEditor 1.7
Withdata software has announced db2lobeditor 1.7, a tool that helps you edit DB2 lob (blob, clob) data directly. DB2LobEditor 1.7 add PDF View, add “Execute Sql from Command line”, improve logon form, improve “Check update”, and fix bug on “Execute from command ... Read more
Withdata Software Released DBBlobEditor 5.1
WITHDATA SOFTWARE has announced DBBlobEditor 5.1, a tool that helps you edit Database LOB (BLOB, CLOB) data directly. DBBlobEditor 5.1 add “Execute from command line”, add “Execute Sql from Command line”, improve logon form and improve “Check ... Read more
How to generate a CREATE TABLE statement for a given table in Mysql
Just use SHOW CREATE TABLE SHOW CREATE TABLE my_table 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 given table in Oracle How to generate a CREATE TABLE statement for a given table in SQLite Some MySQL tools you ... Read more
How to generate a CREATE TABLE statement for a given table in Oracle
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