what a piece code :)

actually not me but lewisC

hi debasisdas...
may i get some article about toad? but if you don't have that article its ok.

best regards
Jery.

thx too nige ridd :)

i suggest to use or operand in query, don't use and.

thx for the site jwenting :)

if u use this clause (and operator) it means two condition must be available. if just one condition only (ex CMCode=4) then this command didn't give result. so CMcode = 4 & CMcode = 5 must be...

This a Good article (from LewisC)
http://downloads.enterprisedb.com/alpha/EnterpriseDB_OraCompat_8.2_v1.2.pdf

I m not understand friend... Please explain more detail about the copied one.

really nice post lewis :)

hi debasisdas, good post. it help me too.

there are site for toad? usually i used s-designor 5.0 to do this.

hi anant266...
welcome to daniweb

hi, i have same idea like alekhan too. this is completed task in building database like what alekhan describe. but you will get a complex db.:)
so have a nice try.