Hi antzzz,
Nikhil here is right. U can generate insert statements using DBArtisan. We can do that by choosing the DBArtisan -> Schema Extraction option.
It has got a very easy wizard interface which can be used for generating the insert statements for any table.
cheers,
KK
Hi All,
Think i might be a bit late for posting a reply ..
But i have tried this one and its real kewl ....
Maybe it might be worth a look ... (for some future use maybe ..)
http://www.zlib.net/
cheers !!! ;-)
Killerkoolkris
Hi sparked,
Your problem is very interesting. I think you will have to use a combination of union and temp tables.
Here's what you can try.
1) first get all the non duplicate records using a group by key, count(*) having count(*) = 1 into a temp table.
2) get all the duplicate records into...
Hi JohnVai,
I think this will be of help for you.
If you only want to show the first 50 rows then try
set rowcount <<50>>
select * from <<TABLEA>> order by <<column1 desc>>
set rowcount <<0>>
The set rowcount will assure that only the number of rows mentioned in the statement will be returned...
Hi,
I want to perform a mathematical function for calculating the median for the values in a particular column containing numeric values.
Is there any inbuilt function which can be used directly to perform this function ?
If not what can be the alternative solution ??
Thanks in Advance...
Hi,
I am currently having a set of 20 items which i am showing in a dropdown list. Some of these items are more than 255 characters in length. I am facing 2 problems -
1) if i show the list using a single column then the items having more than 255 characters appear as '######' and one can view...
Hi,
I am a newbie to XML / XSLT.
I am currently facing a problem. Below is the prototype of a XML i am using.
<xml>
<row>
<field1>1</field1>
<field2>1</field2>
<field3>1</field3>
<field4></field4>
</row>
<row>
<field1>1</field1>
<field2>1</field2>
<field3>2</field3>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.